bool DatabaseForm::CreateDatabase(){ Database pDatabase; String sql; String sql2; String statement; result r = E_SUCCESS; // create the database if it doesn't exist r = pDatabase.Construct(__databaseName, true); if (IsFailed(r)) return false; //pDatabase = new Database(); //if (pDatabase == null) return false; //r = pDatabase->Construct(pDatabaseName,true); //if (IsFailed(r)) return false; // Create the main table sql.Append(L"CREATE TABLE IF NOT EXISTS movies (id INTEGER PRIMARY KEY AUTOINCREMENT, description TEXT)"); r = pDatabase.ExecuteSql(sql, true); if (IsFailed(r)) return false; return true; }
void DatabaseForm::ReadItemsFromDatabase() { Database pDatabase; DbEnumerator* pEnum; String sql; String statement; result r = E_SUCCESS; r = pDatabase.Construct(__databaseName, false); sql.Append(L"select id, description from movies"); pEnum = pDatabase.QueryN(sql); String description; int id; while( pEnum->MoveNext()== E_SUCCESS ) { pEnum->GetIntAt(0, id); pEnum->GetStringAt(1, description); // Store the item in our data structure DatabaseItem* newItem = new DatabaseItem(description); newItem->SetIndex(id); // Display the item in our user interface using our own method AddItemToList(newItem); } if (pEnum != null) delete pEnum; }