对安卓原生db操作进行封装,方便数据库的增删改查操作。使用简单方便。
详细的介绍请移步CSDN : http://blog.csdn.net/achilles_lee/article/details/78327849
##简单使用
###准备工作
- 每一个表对应一个Bean类和一个用来创建表的Dao类
bean类如下:
import com.bravo.dblib.anno.DbFlied;
import com.bravo.dblib.anno.DbTable;
@DbTable("tb_user")
public class User {
@DbFlied("user_id")
public int userId = 0;
@DbFlied("name")
public String name;
@DbFlied("password")
public String password;
@Override
public String toString() {
return "User{" +
"userId=" + userId +
", name='" + name + '\'' +
", password='" + password + '\'' +
'}';
}
}
Dao类如下:
public class UserDao extends BaseDao<User>{
/**
* @return 创建数据库的语句。
*/
@Override
public String createTable() {
return "create table if not exists tb_user(user_id int,name varchar(20),password varchar(20))";
}
}
###初始化
-
初始化操作类:
UserDao userDao = BaseDaoFactory.getInstance().getDataHelper(UserDao.class, User.class);
###增删改查操作
-
增
public void insert(View v) { for (int i = 0; i < 5; i++) { User user = new User(); user.name = "alex" + i; user.password = "123" + i; userDao.insert(user); } Toast.makeText(this, "insert finished", Toast.LENGTH_SHORT).show(); }
-
删
public void delete(View v) { User user = new User(); user.name = "alex0"; userDao.delete(user); Toast.makeText(this, "delete finished", Toast.LENGTH_SHORT).show(); }
-
改
public void update(View v) { User where = new User(); where.name = "alex1"; User entity = new User(); entity.password = "xxxx"; userDao.update(where, entity); Toast.makeText(this, "update finished", Toast.LENGTH_SHORT).show(); }
-
查
public void query(View v) { User where = new User(); where.name = "alex2"; List<User> query = userDao.query(where); Toast.makeText(this, "query finished , Number : " + query.size(), Toast.LENGTH_SHORT).show(); for (User user : query) { Log.e(TAG, query.toString()); } }
将dblib以module的形式导入项目即可使用。目前只实现了简单的功能,还需要更多的扩展。