Advertisement
Kredens234

SQLDatabase example

Jul 17th, 2018
234
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.46 KB | None | 0 0
  1.  
  2.         try {
  3.             SQLiteDatabase sqLiteDatabase = this.openOrCreateDatabase("Users", MODE_PRIVATE, null);
  4. //            sqLiteDatabase.execSQL("DROP TABLE users");
  5. //            sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS users (name VARCHAR, age INT(3))");
  6.                 sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS users (name VARCHAR, age INTEGER(3), id INTEGER PRIMARY KEY)");
  7. //            sqLiteDatabase.execSQL("INSERT INTO users (name, age) VALUES ('Rob', '34')");
  8. //            sqLiteDatabase.execSQL("INSERT INTO users (name, age) VALUES ('Tommy', '4')");
  9. //            sqLiteDatabase.execSQL("INSERT INTO users (name, age) VALUES ('Danny', '10')");
  10.  
  11. //            sqLiteDatabase.execSQL("UPDATE users SET age = 9 WHERE name = 'Danny'");
  12.  
  13.             Cursor cursor = sqLiteDatabase.rawQuery("SELECT * FROM users", null);
  14.             int nameIndex = cursor.getColumnIndex("name");
  15.             int ageIndex = cursor.getColumnIndex("age");
  16.             int idIndex = cursor.getColumnIndex("id");
  17.             cursor.moveToFirst();
  18.  
  19.             while (cursor != null) {
  20.                 Log.i("UserResults - name", cursor.getString(nameIndex));
  21.                 Log.i("UserResults - age", Integer.toString(cursor.getInt(ageIndex)));
  22.                 Log.i("UserResults - id", Integer.toString(cursor.getInt(idIndex)));
  23.                 cursor.moveToNext();
  24.             }
  25.         } catch (Exception e) {
  26.             e.printStackTrace();
  27.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement