請問如何在SQlite上取得id資料

請問如何在SQlite上取得id資料,並顯示在EditText上??
p.s. id number 是ramdam的...

請參考，沒實際 run 過

1. 
   
2. Cursor cursor = db.rawquery("SELECT id, name FROM table_name", new String[]{});
   
3. cursor.moveNext();
   
4. String id = cursor.getString(0);
   
5. String name = cursor.getString(1);
   
6. EditText et_id = (EditText) findViewById(R.id.edittext01);
   
7. EditText et_name = (EditText) findViewById(R.id.edittext02);
   
8. et_id.setText(et_id);
   
9. et_name.setText(et_name);
   

複製代碼