android——ListView(使用simpleCursorAdapter)

1、simpleCursorAdapter

package com.njupt.listview;import java.util.List;import android.os.Bundle;import android.app.Activity;import android.database.Cursor;import android.view.Menu;import android.view.View;import android.view.ViewGroup;import android.widget.BaseAdapter;import android.widget.ListView;import android.widget.SimpleCursorAdapter;import android.widget.TextView;public class SimpleCursorAdapterActivity extends Activity {private ListView personLV;private List<Person> persons;@Overrideprotected void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);setContentView(R.layout.main);    personLV = (ListView) findViewById(R.id.personLV);PersonDao dao = new PersonDao(this);Cursor c = dao.queryAllCursor();personLV.setAdapter(new SimpleCursorAdapter(getApplicationContext(), R.layout.item, c, new String[]{"_id" ,"name","balance"},new int[]{R.id.idTV,R.id.nameTV,R.id.balanceTV} ));}@Overridepublic boolean onCreateOptionsMenu(Menu menu) {// Inflate the menu; this adds items to the action bar if it is present.getMenuInflater().inflate(R.menu.main, menu);return true;}}

2、PersonDao

這時在PersonDao中加上以下方法

public Cursor queryAllCursor() {System.out.println("調用queryAllCursor方法");SQLiteDatabase db = helper.getReadableDatabase();Cursor c = db.query("person", new String[]{"id  _id" , "name","balance"}, null, null, null, null, null);return c;}