Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- SQLiteDatabase sqLiteDatabase = this.openOrCreateDatabase("Users", MODE_PRIVATE, null);
- // sqLiteDatabase.execSQL("DROP TABLE users");
- // sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS users (name VARCHAR, age INT(3))");
- sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS users (name VARCHAR, age INTEGER(3), id INTEGER PRIMARY KEY)");
- // sqLiteDatabase.execSQL("INSERT INTO users (name, age) VALUES ('Rob', '34')");
- // sqLiteDatabase.execSQL("INSERT INTO users (name, age) VALUES ('Tommy', '4')");
- // sqLiteDatabase.execSQL("INSERT INTO users (name, age) VALUES ('Danny', '10')");
- // sqLiteDatabase.execSQL("UPDATE users SET age = 9 WHERE name = 'Danny'");
- Cursor cursor = sqLiteDatabase.rawQuery("SELECT * FROM users", null);
- int nameIndex = cursor.getColumnIndex("name");
- int ageIndex = cursor.getColumnIndex("age");
- int idIndex = cursor.getColumnIndex("id");
- cursor.moveToFirst();
- while (cursor != null) {
- Log.i("UserResults - name", cursor.getString(nameIndex));
- Log.i("UserResults - age", Integer.toString(cursor.getInt(ageIndex)));
- Log.i("UserResults - id", Integer.toString(cursor.getInt(idIndex)));
- cursor.moveToNext();
- }
- } catch (Exception e) {
- e.printStackTrace();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement