listview显示数据库内容的问题 SimpleCursorAdapter

Question

我查了数据内容，确信就是4条，也是4个列表，就是啥都看不到...R.layout.simple_list_item_2是android自带的布局方法，我觉得问题可能出在int[] to=new int[] {R.id.textView1,R.id.textView2};我想确认一下R.id.textView1,R.id.textView2应该取自哪个layout呢？是随意吗？

Answer 1

显示函数源码如下：
void showclxxlist(){
db = new MySQLiteHelper(this,DB_NAME,null,VERSION).getReadableDatabase();
        String col[]={"_id",
         "name","sex","type","zjid","carname","carid","color","created"};
        Cursor clxxCursor=db.query("clxx", col, null, null, null, null, null);
      startManagingCursor(clxxCursor);
      String[] from=new String[]{"carname","_id"};
      int[] to=new int[] {R.id.textView1,R.id.textView2};
      SimpleCursorAdapter notes=new SimpleCursorAdapter(this,android.R.layout.simple_list_item_2,clxxCursor,from,to);
      setListAdapter(notes);
      db.close();
}

Answer 2

 你看一下你是否拿到值了，
如果拿到地话会显示出来地
这是我以前做地一个，能显示出来Cursor cursor=diaryDB.getAllDiary();
             if (cursor.moveToNext()) {
startManagingCursor(cursor);
System.out.println(true);
}
SimpleCursorAdapter diaryAdapter=new SimpleCursorAdapter(ActivityMain.this, 
android.R.layout.simple_list_item_2,  cursor, 
new String[]{"title","time"}, 
new int[]{android.R.id.text1,android.R.id.text2});
setListAdapter(diaryAdapter);

Answer 3

你地游标值可能拿到了，
不过要想取值必须用这个方法
cursor.moveToNext()
看他有值没？？
有了在进行下一步操作

Answer 4

void showclxxlist(){
db = new MySQLiteHelper(this,DB_NAME,null,VERSION).getReadableDatabase();
  String col[]={"_id",
  "name","sex","type","zjid","carname","carid","color","created"};
  Cursor clxxCursor=db.query("clxx", col, null, null, null, null, null);
  startManagingCursor(clxxCursor);
  String[] from=new String[]{"carname","_id"};
  int[] to=new int[] {R.id.textView1,R.id.textView2};/*这里错了,应该设置为 android.R.id.text1，它是根据android.R.layout.simple_list_item_2而定的。*/
  SimpleCursorAdapter notes=new SimpleCursorAdapter(this,android.R.layout.simple_list_item_2,clxxCursor,from,to);
  setListAdapter(notes);
  db.close();
}