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;
@Override
protected 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} ));
}
@Override
public 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;
}