Xutils数据库

    xiaoxiao2021-03-25  69

    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; } }
    转载请注明原文地址: https://ju.6miu.com/read-38577.html

    最新回复(0)