sqlite-SQLite讀取全部數據

SQLite讀取全部數據

table中一共有11條記錄，每個記錄有三個內容"name","address","city"。現在要獲取這些記錄，但是我寫的代碼只能顯示出一條記錄，不知道怎麼實現顯示全部記錄？

public void readData(View v)
    {
        DatabaseClass mydb = new DatabaseClass(this);
        SQLiteDatabase readdata = mydb.getReadableDatabase();
        TextView tv = (TextView)findViewById(R.id.readtext);
        Cursor c = readdata.rawQuery("select * from mylistdata", null);
        int[] elementId = {R.id.textView1, R.id.textView2, R.id.textView3}; 
        if(c !=null)
        {
            c.moveToFirst();
            while(c.isAfterLast() == false)
            {
                listData = new ArrayList<GenericListItem>();
                String name = c.getString(c.getColumnIndex(DatabaseClass.NAME));
                String address = c.getString(c.getColumnIndex(DatabaseClass.ADDRESS));
                String city = c.getString(c.getColumnIndex(DatabaseClass.CITY));
                listData.add(new GenericListItem(new String[]{name,address,city}));
                listAdapter = new GenericListAdapter(getApplicationContext(), R.layout.list_layout, listData, elementId);
                result.setAdapter(listAdapter);
                c.moveToNext();
            }



        }

最佳回答：

要把Adapter放到循環前初始化，然後最後再加載（調用setAdapter()），否則每次都對ListView設置了一個新的Adapter，當然只能看到最後一次設置的值了