14.03.04

数据库适配器

游标适配器cursorAdapter

Newview：创建行布局对象

Bindview：更新数据

Id默认必须为_id

private void show() {
        Cursor cursor = mDb.query("students", null, null, null, null, null, null);
        String[] from=new String[]{"name","phone"};
        int[] to=new int[]{R.id.textView1,R.id.textView2};
        SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, R.layout.item_list, cursor, from, to);
        listview.setAdapter(adapter);
}

若任然报错，将数据库表删除

适配器声明为成员变量，则添加数据后无显示

添加显示：

   重新遍历游标

private void show() {
        Cursor cursor = mDb.query("students", null, null, null, null, null, null);
        String[] from=new String[]{"name","phone"};
        int[] to=new int[]{R.id.textView1,R.id.textView2};
        SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, R.layout.item_list, cursor, from, to);
        listview.setAdapter(adapter);
}

simpleCursorAdapter:简单游标适配器

显示

优：代码结构简单

缺：支持的控件有限

textview、p_w_picpathview、radiobutton、checkbox（CompoundButton）

private void show() {
        Cursor cursor = mDb.query("students", null, null, null, null, null, null);
        String[] from=new String[]{"name","phone"};
        int[] to=new int[]{R.id.textView1,R.id.textView2};
        SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, R.layout.item_list, cursor, from, to);
        listview.setAdapter(adapter);
}