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;

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