Contoh query sqlite
public void cekdata() { SQLiteDatabase db = dbcenter.getReadableDatabase(); SQLiteDatabase sql=dbcenter.getWritableDatabase(); cursor = db.rawQuery("SELECT id_user FROM pesan limit 1", null); cursor.moveToFirst(); if (cursor.getCount()>0) { String returnStringb =cursor.getString(cursor.getColumnIndex("id_user")); sql.execSQL("update pesan set id_user='"+user.getText().toString()+"'" + ",status='0' where id='1'"); } else { ...