Android SQLiter cursor的使用

private SQLite dbHelper;public void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);setContentView(R.layout.main); dbHelper = new SQLite(this);Cursor cursor = dbHelper.getAll();//取得SQLite類別的回傳值:Cursor物件int rows_num = cursor.getCount();//取得資料表列數 cursor.moveToFirst();//將指標移至第一筆資料for(int i=0; i<rows_num; i++) {int id = cursor.getInt(0);//取得第0欄的資料，根據欄位type使用適當語法String name = cursor.getString(1);int value = cursor.getInt(2); cursor.moveToNext();//將指標移至下一筆資料}cursor.close();//關閉CursordbHelper.close();//關閉資料庫，釋放記憶體}

from http://www.moke.tw/wordpress/computer/advanced/249