访问外部存储中的数据库文件，使用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;@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";/** * 打开数据库文件，得到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;@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);/** * 创建适配器 *  参数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>