Xutils数据库

最新推荐文章于 2023-07-14 15:09:41 发布

追风中Zzz

最新推荐文章于 2023-07-14 15:09:41 发布

阅读量280

点赞数

本文介绍了一种基于GreenDAO的数据库操作实现方法，通过具体的Java代码示例展示了如何进行数据的增删改查等基本操作。具体包括：创建数据库连接、定义数据表结构、批量插入数据、条件删除数据、条件更新数据以及查询所有数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public static DbManager DB(){
    DbManager.DaoConfig daoConfig = new DbManager.DaoConfig().setDbName("bw.db").setDbVersion(1);
    DbManager db = x.getDb(daoConfig);
    return db;
}
@Table(name ="students",onCreated = "")
public class Student {
    @Column(name = "id",isId = true,autoGen = true,property = "NOT NULL")
    private int id;
    @Column(name = "name")
    private String name;
    @Column(name = "age")
    private int age;
@Event({R.id.btn_add,R.id.btn_delete,R.id.btn_update,R.id.btn_look})
private void Text(View v){
    DbManager db = MyApplication.DB();
    switch (v.getId()){
        case R.id.btn_add:
            List<Student>list = new ArrayList<>();
            list.add(new Student("zhangsan",18));
            list.add(new Student("lisi",19));
            list.add(new Student("wangwu",6));
            list.add(new Student("zhaoliu",9));
            try {
                db.save(list);
            } catch (DbException e) {
                e.printStackTrace();
            }
            break;
        case R.id.btn_delete:
            WhereBuilder b = WhereBuilder.b();
            b.and("age",">","16");
            try {
                db.delete(Student.class,b);
            } catch (DbException e) {
                e.printStackTrace();
            }
            break;
        case R.id.btn_update:
            WhereBuilder bs = WhereBuilder.b();
            bs.and("id","=",2);
            KeyValue s = new KeyValue("name","sisi");
            try {
                db.update(Student.class,bs,s);
            } catch (DbException e) {
                e.printStackTrace();
            }
            break;
        case R.id.btn_look:
            try {
                List<Student> all = db.findAll(Student.class);
                for (Student student : all) {
                    Log.i("xxx",student.toString());
                }
            } catch (DbException e) {
                e.printStackTrace();
            }
            break;
    }
}