09_android入门_listView的几种Adaptor的实现_simplecursoradaptor

1、数据的获取

public Cursor findCursor() {
		SQLiteDatabase db=databaseHelper.getWritableDatabase();
		//面试题：总是出现_id的错误--》添加as _id
		Cursor c=db.rawQuery("select userid as _id,username,userage,usersalary,userphone from user",null);
		//db.close();//报错
		return c;
	}

2、MVC层的实现

@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		// 设置显示的视图
		setContentView(R.layout.activity_main);
		
		//获取显示的数据 Model
		DatabaseHelper databaseHelper=new DatabaseHelper(this);
		userDao=new UserDaoImpl(databaseHelper);
		//查询获取的数据
		c=userDao.findCursor();
		//entities=userDao.findAll();
		//获取控件对象
		lv_user=(ListView) findViewById(R.id.lv_user);//获取显示的视图
	
		
		//SimpleCursorAdapter adapter=new SimpleCursorAdapter(this, android.R.layout.simple_list_item_2, c, new String[]{"username","userphone"}, new int[]{android.R.id.text1,android.R.id.text2},CursorAdapter.FLAG_REGISTER_CONTENT_OBSERVER);
		SimpleCursorAdapter adapter=new SimpleCursorAdapter(this, R.layout.list_item_user, c, new String[]{"_id","username","userage","userphone"}, new int[]{R.id.tv_id,R.id.tv_name,R.id.tv_age,R.id.tv_phone},CursorAdapter.FLAG_REGISTER_CONTENT_OBSERVER);
		
		lv_user.setAdapter(adapter);
	}

3、结果的显示