Android 数据库封装（SQLite）

Android 数据库操作（SQLite）

数据库封装，方便使用。实现了数据库拷贝，实体类注解配置表及字段，并实现数据封装返回实体类，简化了sql编写和对游标的操作。

动态预览

使用

初始化

 QuickDb dbHelper;
 dbHelper = new QuickDb(this, "quick_db1.db", "quick_db2.db", null, 10, this);

1
2
3

生成表

  dbHelper.createTable(User.class);
1

实体类

@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;
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56

插入数据

 User user = new User();
 user.setName("张三");
 user.setAge(18);
 dbHelper.insert(user);
1
2
3
4

批量插入

List 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);
1
2
3
4
5
6
7
8

删除数据

User user_d = new User();
user_d.setId(2);
dbHelper.delete(user_d);
1
2
3

删除全部

dbHelper.deleteAll(Member.class);
1

修改数据

Member member = members.get(0);
member.setName("sb");
member.setAge(18);
dbHelper.modify(member);
1
2
3
4

查找（列表）

Member member1 = new Member();
member1.setId(1);
List members = dbHelper.findArray(member1);
1
2
3

查找（单条）

User user_t = new User();
user_t.setId(3);
User user2 = dbHelper.findOne(user_t);
1
2
3

条件查找（列表）

List members = new ArrayList<>();
members = dbHelper.findArray("select * from member", Member.class);
1
2

条件查找（单条）

Member member = dbHelper.findOne("select * from member", Member.class);
1

源码

https://gitee.com/squirrelhuan/quick-db