SQLiteUtils 是一个简单的基于Adroid的Sqlite数据库的操作封装，它有如下的好处:
便捷地创建表和增添表字段
灵活的数据类型处理
通过操作对象来isert或者update表记录
支持多种查询方式，支持多表自定义的复杂查询，支持分页查询
支持事务
快速开始:1.设计表:
@Table(ame="t_user")public class UserModel { @Table.Colum(ame="user_id",type=Colum.TYPE_INTEGER,isPrimaryKey=true) public Iteger userId; @Table.Colum(ame="user_ame",type=Colum.TYPE_STRING,isNull=false) public Strig userName; @Table.Colum(ame="bor_date",type=Colum.TYPE_TIMESTAMP) public Date borDate; @Table.Colum(ame="pictrue",type=Colum.TYPE_BLOB) public byte[] pictrue; @Table.Colum(ame="is_logi",type=Colum.TYPE_BOOLEAN) public Boolea isLogi; @Table.Colum(ame="weight",type=Colum.TYPE_DOUBLE) public Double weight;}2.初始化对象:
SQLiteDatabase db = cotext.opeOrCreateDatabase("test.db", Cotext.MODE_PRIVATE, ull);DbSqlite dbSqlite = ew DbSqlite(db);IBaseDao<UserModel> userDAO = DaoFactory.createGeericDao(dbSqlite, UserModel.class);3.创建表:
userDAO.createTable();4.Isert记录:
UserModel user = ew UserModel();user.userName = "darcy";user.isLogi = true;user.weight = 60.5;user.borDate = ew Date();byte[] picture = {0x1,0x2,0x3,0x4};user.pictrue = picture;userDAO.isert(user);5.Update记录:
UserModel user = ew UserModel();user.weight = 88.0;userDAO.update(user, "user_ame=?", "darcy");6.查询:
//单条结果查询UserModel user = userDAO.queryFirstRecord("user_ame=?", "darcy");//一般查询List<UserModel> userList = userDAO.query("user_ame=? ad weight > ?", "darcy" , "60");//分页查询PagigList<UserModel> pagigList = userDAO.pagigQuery(ull, ull, 1, 3);7.事务支持:
DBTrasactio.trasact(mDb, ew DBTrasactio.DBTrasactioIterface() { @Override public void oTrasact() { // to do }};8.更新表(目前只支持添加字段)
@Table(ame="t_user" , versio=2) //修改表版本public class UserModel { //members above... //ew colums @Table.Colum(ame="ew_colum_1",type=Colum.TYPE_INTEGER) public Iteger ewColum; @Table.Colum(ame="ew_colum_2",type=Colum.TYPE_INTEGER) public Iteger ewColum2;}userDAO.updateTable();缺点和不足:还没支持多对一或者一多的关系
没支持联合主键
没支持表的外键设计
其他...
实例:
SqliteLookup(Adroid内查看Sqlite数据库利器): https://github.com/YeDaxia/SqliteLookup
评论