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);}