Android 数据库操作封装，简化操作

package com.abc.lyq.util;

import java.util.List;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class DataBaseTool extends SQLiteOpenHelper {

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

public final static String SETTING_TABLE_NAME = "setting_tb_yq";

public final static String ID = "lyq001000";

private final static String SET_NAME = "lyq001";
private final static String SET_VALUE = "lyq010";

private final static String NAME = "lyq001";

public final static String[] setting_cols = {SET_NAME, SET_VALUE};


public DataBaseTool(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}

public void onCreate(SQLiteDatabase db) {
createTable(db, createSQL(SETTING_TABLE_NAME, setting_cols));
}

private void createTable(SQLiteDatabase db, String tableSQL) {
try {
db.execSQL(tableSQL);
} catch (SQLException e) {
Log.e(ConstantUtil.TAG, "create table failed! " + tableSQL, e);
}
}

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

public long insert(String tablename, ContentValues values) {
SQLiteDatabase db = getWritableDatabase();
return db.insert(tablename, null, values);
}

public void batchInsert(String tablename, List<ContentValues> records) {
SQLiteDatabase db = getWritableDatabase();
db.beginTransaction();
for (ContentValues values : records) {
db.insert(tablename, null, values);
}
db.setTransactionSuccessful();
db.endTransaction();
}

public int update(String tablename, ContentValues values, String whereClause, String[] whereArgs) {
SQLiteDatabase db = getWritableDatabase();
return db.update(tablename, values, whereClause, whereArgs);
}

public int remove(String tablename, String whereClause, String[] whereArgs) {
SQLiteDatabase db = getWritableDatabase();
return db.delete(tablename, whereClause, whereArgs);
}

public Cursor select(String tablename, String[] cols, String where, String[] whereArgs, String groupBy, String having, String orderBy) {
SQLiteDatabase db = getReadableDatabase();
return db.query(tablename, cols, where, whereArgs, groupBy, having, orderBy);
}

private String createSQL(String table, String[] cols) {
StringBuffer sb = new StringBuffer("CREATE TABLE if not exists ");
sb.append(table);
sb.append(" ( ").append(ID).append(" INTEGER PRIMARY KEY autoincrement ");
for (String col : cols) {
sb.append(" , ").append(col).append(" TEXT");
}
sb.append(" ) ");
return sb.toString();
}

}