网站推广全过程,网站手机优化,wordpress mysql 挂了,网站设计 网站开发 西安Android 数据库操作#xff08;SQLite#xff09; Android 数据库操作#xff08;SQLite#xff09;动态预览使用初始化生成表实体类插入数据批量插入删除数据删除全部修改数据查找#xff08;列表#xff09;查找#xff08;单条#xff09;条件查找#xff08;列表SQLite Android 数据库操作SQLite动态预览使用初始化生成表实体类插入数据批量插入删除数据删除全部修改数据查找列表查找单条条件查找列表条件查找单条 源码 Android 数据库操作SQLite 数据库封装方便使用。实现了数据库拷贝实体类注解配置表及字段并实现数据封装返回实体类简化了sql编写和对游标的操作。 动态预览 使用
初始化 QuickDb dbHelper;dbHelper new QuickDb(this, quick_db1.db, quick_db2.db, null, 10, this);
生成表 dbHelper.createTable(User.class);实体类
DBTable(name user)
public class User {SQLObj(name id,constraints Constraints(primaryKey true))private int id;SQLObj(name name)private String name;SQLObj(name header)private String header;private int age;private int sex;public int getId() {return id;}public void setId(int id) {this.id id;}public String getName() {return name;}public void setName(String name) {this.name name;}public String getHeader() {return header;}public void setHeader(String header) {this.header header;}public int getAge() {return age;}public void setAge(int age) {this.age age;}public int getSex() {return sex;}public void setSex(int sex) {this.sex sex;}
}插入数据 User user new User();user.setName(张三);user.setAge(18);dbHelper.insert(user);批量插入
ListMember members new ArrayList();
for (int i 1; i 10; i) {Member member1 new Member();member1.setAge(i);member1.setName(M_ i);members.add(member1);
}
dbHelper.insertArray(members);删除数据
User user_d new User();
user_d.setId(2);
dbHelper.delete(user_d);删除全部
dbHelper.deleteAll(Member.class);修改数据
Member member members.get(0);
member.setName(sb);
member.setAge(18);
dbHelper.modify(member);查找列表
Member member1 new Member();
member1.setId(1);
ListMember members dbHelper.findArray(member1);查找单条
User user_t new User();
user_t.setId(3);
User user2 dbHelper.findOne(user_t);条件查找列表
ListMember members new ArrayList();
members dbHelper.findArray(select * from member, Member.class);条件查找单条
Member member dbHelper.findOne(select * from member, Member.class);源码
https://gitee.com/squirrelhuan/quick-db
