DBUtils创建数据库,增删改查

public class DBUtilsDatabases {
    private DbUtils db;

    public DBUtilsDatabases(Context context) {
        db = DbUtils.create(context, "user.db", 1, null);
    }

    public void insert(Context context) {
        try {
            Person per = new Person();
            per.setName("张三");
            per.setPhone("110");
            db.save(per);
            Toast.makeText(context, "添加成功", 0).show();
        } catch (DbException e) {
            e.printStackTrace();
            Toast.makeText(context, "添加失败", 0).show();
        }
    }

    public void update(Context context) {
        try {
            Person per = new Person();
            per.setName("李四");
            per.setPhone("150");
            db.update(per, WhereBuilder.b("id", "=", 1), "name", "phone");
            Toast.makeText(context, "修改成功", 0).show();
        } catch (DbException e) {
            e.printStackTrace();
            Toast.makeText(context, "修改失败", 0).show();
        }
    }

    public void delete(Context context) {
        try {
            db.delete(Person.class, WhereBuilder.b("id", "=", 1));
            Toast.makeText(context, "删除成功", 0).show();
        } catch (DbException e) {
            e.printStackTrace();
            Toast.makeText(context, "删除失败", 0).show();
        }
    }

    // 查询全部
    public void selectAll(Context context) {
        try {
            List<Person> list = db.findAll(Person.class);
            Toast.makeText(context, list.toString(), 0).show();
        } catch (DbException e) {
            e.printStackTrace();
        }
    }

    // 查询单个
    public void select(Context context) {
        try {
            List<Object> list = db.findAll(Selector.from(Person.class).where(
                    "id", ">", 1));
            Toast.makeText(context, list.toString(), 0).show();
        } catch (DbException e) {
            e.printStackTrace();
        }
    }
}