Cacher is the code snippet organizer for pro developers

      try {
            SQLiteDatabase myDatabase = this.openOrCreateDatabase("Users", MODE_PRIVATE, null);
            myDatabase.execSQL("CREATE TABLE IF NOT EXISTS users (name VARCHAR, age INT(3))");
            myDatabase.execSQL("INSERT INTO users (name, age) VALUES ('Foo', 42)");
            myDatabase.execSQL("INSERT INTO users (name, age) VALUES ('Bar', 101)");

            Cursor c = myDatabase.rawQuery("SELECT * FROM users", null);
            int nameIndex = c.getColumnIndex("name");
            int ageIndex = c.getColumnIndex("age");
            c.moveToFirst();

            while (!c.isAfterLast()) {
                Log.i("name", c.getString(nameIndex));
                Log.i("age", Integer.toString(c.getInt(ageIndex)));
                c.moveToNext();
            }
        } catch (Exception e) {
            //
        }
        
        
        //Sample 2 with a PRIMARY KEY
        try {
            SQLiteDatabase myDatabase = this.openOrCreateDatabase("Users", MODE_PRIVATE, null);
            myDatabase.execSQL("CREATE TABLE IF NOT EXISTS newUsers (name VARCHAR, age INT(3), id INTEGER PRIMARY KEY)");

            myDatabase.execSQL("INSERT INTO newUsers (name, age) VALUES ('Foo', 63)");
            myDatabase.execSQL("INSERT INTO newUsers (name, age) VALUES ('Bar', 101)");
            myDatabase.execSQL("INSERT INTO newUsers (name, age) VALUES ('FooBar', 32)");

            //myDatabase.execSQL("DELETE FROM newUsers WHERE id = 2");

            Cursor c = myDatabase.rawQuery("SELECT * FROM newUsers", null);
            int nameIndex = c.getColumnIndex("name");
            int ageIndex = c.getColumnIndex("age");
            int idIndex = c.getColumnIndex("id");
            c.moveToFirst();

            while (!c.isAfterLast()) {
                Log.i("name", c.getString(nameIndex));
                Log.i("age", Integer.toString(c.getInt(ageIndex)));
                Log.i("id", Integer.toString(c.getInt(idIndex)));
                c.moveToNext();
            }
        } catch (Exception e) {
            //
        }