访问外部存储中的数据库文件，使用CursorAdapter显示在ListView组件上

<pre name="code" class="java"><pre name="code" class="java"><span style="font-size:18px;">package com.lixiangjian.android_sqliteadapter;

import java.io.File;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.os.Environment;
import android.widget.ListView;
import android.widget.SimpleAdapter;

/**
 * 需求：访问外部存储中的数据库文件，使用SimpleAdapter显示在ListView组件上
 * 
 * @author lixiangjian
 *
 */
public class MainActivity extends Activity {

	private ListView listView;
	private SQLiteDatabase db;
	private List<Map<String, Object>> list;

	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		listView = (ListView) findViewById(R.id.listView);
		// 数据库文件的路径
		String path = Environment.getExternalStorageDirectory() + File.separator + "sqq" + File.separator
				+ "info_db.db";
		/**
		 * 打开数据库文件，得到SQLiteDatabase对象 参1：要打开的数据库文件的路径 参2：游标工厂 参数3：访问数据库文件的权限
		 */
		db = SQLiteDatabase.openDatabase(path, null, SQLiteDatabase.OPEN_READWRITE);
		// 获取数据
		getDatabaseData();
		// 创建适配器
		SimpleAdapter adapter = new SimpleAdapter(MainActivity.this, list, R.layout.mb, new String[] { "_id", "name" },
				new int[] { R.id.textView1, R.id.textView2 });
		//给ListView设置适配器
		listView.setAdapter(adapter);
	}

	private void getDatabaseData() {
		list = new ArrayList<Map<String, Object>>();
		Cursor cusor = db.query("person", null, null, null, null, null, "_id desc");
		while (cusor.moveToNext()) {
			int _id = cusor.getInt(cusor.getColumnIndex("_id"));
			String name = cusor.getString(cusor.getColumnIndex("name"));
			Map<String, Object> map = new HashMap<String, Object>();
			map.put("_id", _id);
			map.put("name", name);
			list.add(map);
		}
	}

}
</span>

package com.lixiangjian.android_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;/** * 需求：访问外部存储中的数据库文件，使用CursorAdapter显示在ListView组件上 * @author lixiangjian * */public class CursorAdapterActivity extends Activity {private ListView listView;private SQLiteDatabase db;@Overrideprotected void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);setContentView(R.layout.activity_main);listView = (ListView)findViewById(R.id.listView);String path = Environment.getExternalStorageDirectory()+File.separator+"sqq"+File.separator+"info_db.db";db = SQLiteDatabase.openDatabase(path, null, SQLiteDatabase.OPEN_READWRITE);//获取数据Cursor cursor = db.query("person", null, null, null, null, null, null);//创建适配器MyCursorAdapter adapter = new MyCursorAdapter(CursorAdapterActivity.this, cursor);//给LsitView设置适配器listView.setAdapter(adapter);}public class MyCursorAdapter extends CursorAdapter{public MyCursorAdapter(Context context, Cursor c) {super(context, c);}/** * 返回View对象 ，item的布局文件 */@Overridepublic View newView(Context context, Cursor cursor, ViewGroup parent) {return LayoutInflater.from(context).inflate(R.layout.mb, null);}/** * 绑定数据 * 参数1：View :newView方法返回的View对象 * 参2： * 参3：构造器中的 Cursor */@Overridepublic void bindView(View view, Context context, Cursor cursor) {TextView textView1 = (TextView) view.findViewById(R.id.textView1);TextView textView2 = (TextView) view.findViewById(R.id.textView2);int _id = cursor.getInt(cursor.getColumnIndex("_id"));String name = cursor.getString(cursor.getColumnIndex("name"));textView1.setText(_id+"");textView2.setText(name);}}}

<span style="font-size:18px;">package com.lixiangjian.android_sqliteadapter;

import java.io.File;

import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.os.Environment;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;

/**
 * 需求：访问外部存储中的数据库文件，使用SimpleCursorAdapter显示在ListView组件上
 * 
 * @author lixiangjian
 *
 */
public class SimpleCursorActivity extends Activity {

	private ListView listView;
	private SQLiteDatabase db;

	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		listView = (ListView) findViewById(R.id.listView);
		String path = Environment.getExternalStorageDirectory() + File.separator + "sqq" + File.separator
				+ "info_db.db";
		db = SQLiteDatabase.openDatabase(path, null, SQLiteDatabase.OPEN_READWRITE);
		// 获取数据
		Cursor cursor = db.query("person", null, null, null, null, null, null);
		/**
		 * 创建适配器
		 *  参数1：上下文对象 
		 *  参2：item的布局文件 
		 *  参数3：Cursor对象 
		 *  参4：表中列名的集合
		 *  参5：列对应的数据显示在哪个组件上
		 */
		SimpleCursorAdapter adapter = new SimpleCursorAdapter(SimpleCursorActivity.this, R.layout.mb, cursor,
				new String[] { "_id", "name" }, new int[] { R.id.textView1, R.id.textView2 });

		//给ListView设适配器
		listView.setAdapter(adapter);
	}
}
 </span>

activity_main.xml:

<span style="font-size:18px;"><RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent" >

    <ListView
        android:id="@+id/listView"
        android:layout_width="match_parent"
        android:layout_height="match_parent"/>

</RelativeLayout>
</span>

<span style="font-size:18px;">mb.xml:
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical" >

    <TextView
        android:id="@+id/textView1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="TextView" />

    <TextView
        android:id="@+id/textView2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="TextView" />

</LinearLayout>
</span>