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();
}

}
一个简单的基于Android的Sqlite数据库操作封装,它有如下的好处:便捷地创建表和增添表字段灵活的数据类型处理通过操作对象来insert或者update表记录支持多种查询方式,支持多表自定义的复杂查询,支持分页查询支持事务快速开始:    1. 设计表:@Table(name="t_user") public class UserModel {     @Table.Column(name="user_id",type=Column.TYPE_INTEGER,isPrimaryKey=true)     public Integer userId;     @Table.Column(name="user_name",type=Column.TYPE_STRING,isNull=false)     public String userName;     @Table.Column(name="born_date",type=Column.TYPE_TIMESTAMP)     public Date bornDate;     @Table.Column(name="pictrue",type=Column.TYPE_BLOB)     public byte[] pictrue;     @Table.Column(name="is_login",type=Column.TYPE_BOOLEAN)     public Boolean isLogin;     @Table.Column(name="weight",type=Column.TYPE_DOUBLE)     public Double weight; }2. 初始化对象:SQLiteDatabase db = context.openOrCreateDatabase("test.db", Context.MODE_PRIVATE, null); DbSqlite dbSqlite = new DbSqlite(db); IBaseDao userDAO = DaoFactory.createGenericDao(dbSqlite, UserModel.class);3. 创建表:userDAO.createTable(); 4. Insert 记录:UserModel user = new UserModel(); user.userName = "darcy"; user.isLogin = true; user.weight = 60.5; user.bornDate = new Date(); byte[] picture = {0x1,0x2,0x3,0x4}; user.pictrue = picture; userDAO.insert(user);5. Update 记录:UserModel user = new UserModel(); user.weight = 88.0; userDAO.update(user, "user_name=?", "darcy");6. 查询://单条结果查询 UserModel user = userDAO.queryFirstRecord("user_name=?", "darcy"); //一般查询 List userList = userDAO.query("user_name=? and weight > ?", "darcy" , "60"); //分页查询 PagingList pagingList = userDAO.pagingQuery(null, null, 1, 3);7. 事务支持:DBTransaction.transact(mDb, new DBTransaction.DBTransactionInterface() {         @Override         public void onTransact() {             // to do                 } };8. 更新表(目前只支持添加字段)@Table(name="t_user" , version=2) //修改表版本 public class UserModel {     //members above...     //new columns     @Table.Column(name="new_column_1",type=Column.TYPE_INTEGER)     public Integer newColumn;     @Table.Column(name="new_column_2",type=Column.TYPE_INTEGER)     public Integer newColumn2; } userDAO.updateTable();缺点和不足:还没支持多对一或者一多的关系没支持联合主键没支持表的外键设计其他...实例:SqliteLookup(Android内查看Sqlite数据库利器): https://github.com/YeDaxia/SqliteLookup 标签:SQLiteUtils
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值