public int getIdByIdentifier(String identifier){ db = mSQLHelper.getReadableDatabase(); String selection = KEY_GOOGLE_TASK_IDENTIFIER + "=?"; String[] selectionArgs = { identifier }; Cursor cursor = db.query(TASKS_TABLE_NAME, null, selection, selectionArgs, null, null, null); int index = cursor.getColumnIndex(KEY_ID); if(cursor.getCount() == 0){ return 0000; }else { cursor.moveToFirst(); return cursor.getInt(index); } } // public List<String> getAllTasksTitle(){ // db = mSQLHelper.getReadableDatabase(); // Cursor cursor; // cursor = db.query(TASKS_TABLE_NAME, null, null, // null, null, null, null);
Other popular examples for SQLiteDatabase
49: db.execSQL("CREATE TABLE orgs (id INTEGER PRIMARY KEY);");
50: db.execSQL("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, avatarurl TEXT);");
51: db.execSQL("CREATE TABLE repos (id INTEGER PRIMARY KEY, repoId INTEGER, orgId INTEGER, name TEXT, ownerId INTEGER, private INTEGER, fork INTEGER, description TEXT, forks INTEGER, watchers INTEGER, language TEXT, hasIssues INTEGER, mirrorUrl TEXT);");
-
57: db.execSQL("DROP TABLE IF EXISTS orgs");
58: db.execSQL("DROP TABLE IF EXISTS users");
59: db.execSQL("DROP TABLE IF EXISTS repos");
Full Snippet Info129: db.beginTransaction();
-
131: persistableResource.store(db, items);
132: db.setTransactionSuccessful();
-
134: db.endTransaction();
Full Snippet Info448: database.delete("exectable", null, null);
-
450: Cursor cursor = database.rawQuery("select * from exectable", null);
-
454: database.execSQL("insert into exectable (first_column) values (?);", new String[]{});
455: Cursor cursor2 = database.rawQuery("select * from exectable", new String[]{null});
Full Snippet Info