读出Sqlite中的数据并加载到ListView上

<span style="font-family:Comic Sans MS;font-size:18px;">package com.example.week3_day4_sqliteadapter;

import java.io.File;

import android.app.Activity;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.os.Environment;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.CursorAdapter;
import android.widget.ListView;
import android.widget.TextView;

public class CursorAdapterActivity extends Activity {
	private ListView listView;// 声明列表控件

	private SQLiteDatabase db;

	@Override
	protected void onCreate(Bundle savedInstanceState) {
		// TODO Auto-generated method stub
		super.onCreate(savedInstanceState);
		setContentView(R.layout.listview);// 加载布局文件
		listView = (ListView) findViewById(R.id.lv);
		// 找到数据库路径
		String path = Environment.getExternalStorageDirectory()
				.getAbsolutePath()
				+ File.separator
				+ "Download"
				+ File.separator + "info.db";
		db = SQLiteDatabase.openDatabase(path, null,
				SQLiteDatabase.OPEN_READWRITE);
		// 指定查询语句
		Cursor c = db.rawQuery("select * from person", null);
		// 实例化自定义适配器
		MyCursorAdapter adapter = new MyCursorAdapter(
				CursorAdapterActivity.this, c);
		// 将适配器填充到ListView上
		listView.setAdapter(adapter);
	}

	// 自定义适配器
	class MyCursorAdapter extends CursorAdapter {

		public MyCursorAdapter(Context context, Cursor c) {
			super(context, c);
			// TODO Auto-generated constructor stub
		}

		/**
		 * newView 返回item布局 view 给 bindView
		 */
		@Override
		public View newView(Context context, Cursor arg1, ViewGroup arg2) {
			// TODO Auto-generated method stub
			return LayoutInflater.from(context).inflate(R.layout.item, null);
		}

		/**
		 * 参数1：newVIew 里返回的View视图 参数2：上下文对象 参数3：Cursor对象
		 * 
		 */
		@Override
		public void bindView(View v, Context arg1, Cursor cursor) {
			TextView tv_id = (TextView) v.findViewById(R.id.tv_id);
			TextView tv_name = (TextView) v.findViewById(R.id.tv_name);
			//将数据显示到ListView上
			tv_id.setText(cursor.getInt(cursor.getColumnIndex("_id")) + "");
			tv_name.setText(cursor.getString(cursor.getColumnIndex("name")));

		}

	}
}
</span>