ListActivity+sqlite+SimpleCurrsorAdapterの簡単な例

以下は簡単な例で、ListActivity+sqlite+SimpleCurrsorAdapterの使い方を主に実証します.
インスタンスパッケージのダウンロード:http://download.csdn.net/detail/yang_hui 1986527/441978
DBHelper.java

package com.example.sqlitedemo.db;

import android.content.Context;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper extends SQLiteOpenHelper {

	/**
	 *      
	 */
	private static final String DATABASE_NAME = "test.db";  
	
	/**
	 *      
	 */
	private static final int DATABASE_VERSION = 1;  

	/**
	 *     
	 */
	public static final String TABLE_NAME = "profile";
	
	/**
	 *    ，_ID，    
	 */
	public static final String COLUMN_ID = "_id";
	
	/**
	 *    ，  
	 */
	public static final String COLUMN_NAME = "name";
	
	public DBHelper(Context context) {
		super(context, DATABASE_NAME, null, DATABASE_VERSION);
	}


	@Override
	public void onCreate(SQLiteDatabase db)  throws SQLException {
		//    
		db.execSQL("CREATE TABLE IF NOT EXISTS "+ TABLE_NAME + "("+ COLUMN_ID +" INTEGER PRIMARY KEY AUTOINCREMENT," + COLUMN_NAME +" VARCHAR NOT NULL);");
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)  throws SQLException {
		//       
		db.execSQL("DROP TABLE IF EXISTS "+ TABLE_NAME+";");
		onCreate(db);
	}
}

MainActivity.java

package com.example.sqlitedemo;

import android.app.ListActivity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.Menu;
import android.widget.SimpleCursorAdapter;

import com.example.sqlitedemo.db.DBHelper;

public class MainActivity extends ListActivity {
	private DBHelper helper = null;  
	private SQLiteDatabase db = null;  
	private SimpleCursorAdapter adapter= null;
	private Cursor mCursor = null;

	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		initData();
		initAdapter();
	}

	public void initData(){
		//     
		helper = new DBHelper(this);
		db = helper.getReadableDatabase();

		//    
		try {
			insert("zhang san");
			insert("li si");
			insert("wang wu");
			insert("chen liu");
			insert("zhang san");
			insert("li si");
			insert("wang wu");
			insert("chen liu");
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	
	public void initAdapter(){
		//    ，   Cursor
		mCursor = db.query(DBHelper.TABLE_NAME, new String[]{DBHelper.COLUMN_ID,DBHelper.COLUMN_NAME}, null, null, null, null, null);
		
		//  adapter
		adapter = new SimpleCursorAdapter(this, android.R.layout.simple_list_item_2, mCursor, new String[]{DBHelper.COLUMN_ID,DBHelper.COLUMN_NAME}, new int[]{android.R.id.text1,android.R.id.text2});
		setListAdapter(adapter);
	}

	public void insert(String name) throws SQLException {
		ContentValues values = new ContentValues();
		values.put(DBHelper.COLUMN_NAME, name);
		db.insertOrThrow(DBHelper.TABLE_NAME, null, values);
	}

	@Override
	public boolean onCreateOptionsMenu(Menu menu) {
		getMenuInflater().inflate(R.menu.activity_main, menu);
		return true;
	}


}

プレビューの効果: