SQLiteOpenHelper dummy = new SQLiteOpenHelper(this, "mobileAppBeginner.db", null, 1) { @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {} @Override public void onCreate(SQLiteDatabase db) {} }; SQLiteDatabase db = dummy.getWritableDatabase(); db.execSQL("CREATE TEMP TABLE messages (read_status INTEGER, direction INTEGER, target TEXT)"); db.execSQL("CREATE TEMP TABLE IF NOT EXISTS tt1 (unread_message int, target varchar)"); db.execSQL("INSERT INTO tt1 SELECT count(*), target FROM messages where read_status=0 and direction=1 GROUP BY target");
SQLiteOpenHelper helper = new SQLiteOpenHelper() SQLiteDatabase db = helper.getWritableDatabase();
SQLiteOpenHelper mDbHelper = new SQLiteOpenHelper(this); SQLiteDatabase DB= mDbHelper.getWritableDatabase();
SQLiteOpenHelper helper = new SQLiteOpenHelper(this, "fts3.db", null, 1) { @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {}
SQLiteOpenHelper helper = new SQLiteOpenHelper(this, "nomebanco", null, 1) {
sqLiteOpenHelper = new SQLiteOpenHelper(context, DB_NAME, null, 1) {
singleton = new SQLiteOpenHelper(context, DATABASE_NAME, null, DATABASE_VERSION) {