我的新书《Android App开发入门与实战》已于2020年8月由人民邮电出版社出版,欢迎购买。点击进入详情
项目地址
https://github.com/ddnosh/android-tiny-sql
解决方案
- 使用BaseDao处理数据库的增删改查操作;
- 使用DaoFactory生产具体的业务Dao文件;
- 业务Dao文件处理具体的业务逻辑相关的数据库操作;
功能介绍
- 使用对象Object去操作数据库;
用法
public void insert(View view) {
UserDao userDao = DaoFactory.getInstance().getBaseDao(UserDao.class);
userDao.insert(new User("1", "Jack", "123456"));
Toast.makeText(this, "插入成功", Toast.LENGTH_SHORT).show();
}
public void update(View view) {
UserDao userDao = DaoFactory.getInstance().getBaseDao(UserDao.class);
User user = new User();
user.setName("Tom");
User where = new User();
where.setId("1");
userDao.update(user, where);
Toast.makeText(this, "更新成功", Toast.LENGTH_SHORT).show();
}
public void delete(View view) {
UserDao userDao = DaoFactory.getInstance().getBaseDao(UserDao.class);
User where = new User();
where.setName("Tom");
userDao.delete(where);
Toast.makeText(this, "删除成功", Toast.LENGTH_SHORT).show();
}
public void query(View view) {
UserDao userDao = DaoFactory.getInstance().getBaseDao(UserDao.class);
User where = new User();
where.setPassword("123456");
List<User> list = userDao.query(where);
Log.d(TAG, "list.size =========" + list.size());
for (int i = 0; i < list.size(); i++) {
Log.d(TAG, list.get(i) + " =====i=====" + i);
}
Toast.makeText(this, "查询成功", Toast.LENGTH_SHORT).show();
}