SQLiteOpenHelper数据库工具包

CreateTable.java

package com.example.util;

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

public class CreateTable extends SQLiteOpenHelper {
	private Context context;// 上下文内容
	private String name;// 表名
	private CursorFactory factory;// 游标工厂
	private int version;// 版本号

	/**
	 * 有参构造函数
	 * @param context 上下文内容
	 * @param name 表名
	 * @param factory 游标工厂
	 * @param version 版本号
	 */
	public CreateTable(Context context, String name, CursorFactory factory,
			int version) {
		super(context, name, factory, version);
		this.context = context;
		this.name = name;
		this.factory = factory;
		this.version = version;
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		// 创建表
		String sql = "create table "
				+ name
				+ " (userid integer primary key autoincrement,username text not null,userpassword text not null)";
		// 执行语句
		db.execSQL(sql);

	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO Auto-generated method stub
	}
}

DBUtil.java

package com.example.util;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;

import com.example.constant.Constant;
import com.example.util.CreateTable;

/**
 * 数据库的工具类
 * @author Lenovo
 *
 */
public class DBUtil {
	 Context context;//上下文内容
	 String name;//表名
	 CursorFactory factory;//游标工厂
	 int version;//版本号
	 CreateTable ct;//创建表的类
	 SQLiteDatabase sqlDatabase;//数据库读写对象
	 Cursor cursor;//游标对象
	/**
	 * 有参构造函数
	 * @param context 上下文内容
	 * @param name 表名
	 * @param factory 游标工厂
	 * @param version 版本号
	 */
	public DBUtil(Context context, String name, CursorFactory factory, int version) {
		super();
		this.context = context;
		this.name = name;
		this.factory = factory;
		this.version = version;
	}
	public void openDb(){
		ct=new CreateTable(context, name, factory, version);
	}
	/**
	 * 关闭数据库
	 */
	public void closeDb(){
		if (cursor!=null) {
			cursor.close();
		}
		if (ct!=null) {
			ct.close();
		}
	}
	/**
	 * 增删改
	 * @param values 存值的容器
	 * @param keyparams 存值的名字
	 * @param valueparams 存值的值
	 * @param whereClause 带问号sql语句
	 * @param whereArgs 问号的值
	 * @return
	 */
	public long doUpdate(ContentValues values,String[] keyparams,String[] valueparams,String whereClause,String[] whereArgs){
		openDb();
		sqlDatabase=ct.getWritableDatabase();
		long length=0;
//		sqlDatabase.insert(table, nullColumnHack, values)
//		sqlDatabase.update(table, values, whereClause, whereArgs)
//		sqlDatabase.delete(table, whereClause, whereArgs)
		if (keyparams==null) {
			length=sqlDatabase.delete(Constant.TABLE_1, whereClause, whereArgs);
		}else {
			for (int i = 0; i < valueparams.length; i++) {
				values.put(keyparams[i], valueparams[i]);
			}
			if (whereClause==null) {
				length=sqlDatabase.insert(Constant.TABLE_1, null, values);
			}else {
				length=sqlDatabase.update(Constant.TABLE_1, values, whereClause, whereArgs);
			}
		}
		closeDb();
		return length;
	}
	/**
	 * 
	 * @param selection 
	 * @param selectionArgs
	 * @return
	 */
	public Cursor doQuery(String selection,String[] selectionArgs){
		openDb();
		sqlDatabase=ct.getReadableDatabase();
		return sqlDatabase.query(Constant.TABLE_1, null, selection, selectionArgs, null, null, null);		
	}
	
}