Android中ListView,SQLite,BaseAdapter的结合.doc

Android中ListView，SQLite，BaseAdapter的结合 2011-03-24 21:34 今天突然有个奇妙的想法，就是用listview结合自定义的Adapter来写一个结合SQLite数据库的例子，想必很多童鞋都有过这种想法，但是一个爱编程的程序员，单单是有想法是不行的，所以说我们要付之于行动。那么就一起看看吧： 第一步：编写关于数据库的类和方法 DBHelper.java 代码如下： package com.jftt.db; import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;import android.util.Log; import com.jftt.conmmon.CONST; public class DBHelper extends SQLiteOpenHelper {private static final String TAG = DBHelper; public DBHelper(Context context) {super(context, CONST.JFTT_DATABASE_NAME, null,CONST.JFTT_DATABASE_VERSION); // TODO Auto-generated constructor stub} @Overridepublic void onCreate(SQLiteDatabase db) { String createTableSql = create table + CONST.JFTT_DATABASE_TABLE_USER+ (_id autoinc primary key , u_name varchar(20),u_pass varchar(20));db.execSQL(createTableSql);Log.d(TAG, Table + CONST.JFTT_DATABASE_TABLE_USER+ createad succesfully);createTableSql = CREATE TABLE + CONST.JFTT_DATABASE_TABLE_INFO + (+ _id AUTOINC PRIMARY KEY,+ u_age VARCHAR(20)NOT NULL ON CONFLICT FAIL,+ u_addr VARCHAR(20)NOT NULL ON CONFLICT FAIL,+ u_email VARCHAR(20)NOT NULL ON CONFLICT FAIL );db.execSQL(createTableSql);Log.d(TAG, Database + CONST.JFTT_DATABASE_NAME+ createad succesfully);} @Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {// TODO Auto-generated method stubString dropTableSQL = DROP TABLE IF EXISTS + CONST.JFTT_DATABASE_TABLE_INFO + ;db.execSQL(dropTableSQL);dropTableSQL = DROP TABLE IF EXISTS + CONST.JFTT_DATABASE_TABLE_USER+ ;db.execSQL(dropTableSQL);onCreate(db);} // execute insert,update,delete and so on..public void execSQL(String sql, Object[] args) {SQLiteDatabase db = this.getWritableDatabase();db.execSQL(sql, args);Log.d(TAG, Execute SQL + sql + succesfully);} public Cursor query(String sql, String[] args) { SQLiteDatabase db = this.getWritableDatabase();Log.d(TAG, Que