Android ORM框架介绍之android-liteorm(archiver)注解与封装

逃离我推掉我的手 2022-07-17 03:08 161阅读 0赞

## Android ORM框架介绍之android-liteorm注解与封装 ##

### LiteOrm ###

#### 代号: archiver ####

LiteOrm 是一个速度快、小巧却强大的 Android ORM 框架类库，速度快、体积小、性能高，开发者基本一行代码实现数据库的增删改查操作，以及实体关系的持久化和自动映射。 自动化且比系统自带数据库操作快1倍！

[*作者个人主页*][Link 1]

### liteorm注解 ###

![这里写图片描述][20160828225333085]

常用注解

*  @Table：用于类，默认使用类名，也可以自定义。如：*@Table(“tb\_user”)*
 *  @PrimaryKey：主键，通过AssignType枚举来设置值，如：*@PrimaryKey(AssignType.AUTO\_INCREMENT)*  
    
    
     *  BY\_MYSELF,
     *  AUTO\_INCREMENT;//自增
 *  @Unique：唯一字段（行）
 *  @UniqueCombine：唯一（列中字段值唯一）
 *  @NotNull：字段部位none
 *  @Ingore：使用该注解表示字段不存入数据库
 *  @Mapping：表示关联关系，通过枚举Relation设置值，如： *@Mapping(Relation.OneToOne)*  
    
    
     *  ManyToMany,//多对多
     *  OneToMany,//一对多
     *  ManyToOne,//多对一
     *  OneToOne;//一对一
 *  @Column：自定义字段名(列名)。如：*@Column(“name”)*
 *  @Conflict：数据库冲突策略，通过枚举Strategy设置值，可用于表，也可用于字段上  
    
    
     *  ROLLBACK(” ROLLBACK “),//回滚
     *  ABORT(” ABORT “),//中断
     *  FAIL(” FAIL “),//失败
     *  IGNORE(” IGNORE “),//忽略
     *  REPLACE(” REPLACE “);//替换

### liteorm的封装 ###

public class DataBaseManager { 
        private static DataBaseManager manager;
        private static final String DB_NAME = "my.db";
        private LiteOrm liteOrm;
    
        private DataBaseManager(Context context) {
            if (liteOrm == null) {
                liteOrm = LiteOrm.newSingleInstance(context, DB_NAME);
            }
        }
    
        public static DataBaseManager getInstance(Context context) {
            context = context.getApplicationContext();
            if (manager == null) {
                synchronized (DataBaseManager.class) {
                    if (manager == null) {
                        manager = new DataBaseManager(context);
                    }
                }
            }
            return manager;
        }
    
        /** * 插入一条记录 */
        public <T> long insert(T t) {
            return liteOrm.save(t);
        }
    
        /** * 插入所有记录 */
        public <T> void insertAll(List<T> list) {
            liteOrm.save(list);
        }
    
        /** * 根据对象查询数据 */
        public <T> int update(T t) {
            return liteOrm.update(t);
        }
    
        /** * 查询所有数据 */
        public <T> int updateAll(List<T> list) {
            return liteOrm.update(list);
        }
    
        /** * 根据id查询 */
        public <T> T query(long id, Class<T> clazz) {
            return liteOrm.queryById(id, clazz);
        }
    
        /** * 查询所有 */
        public <T> List<T> queryAll(Class<T> cla) {
            return liteOrm.query(cla);
        }
    
        /** * 查询 某字段 等于 Value的值 */
        @SuppressWarnings("unchecked")
        public <T> List<T> queryByWhere(Class<T> cla, String field, String[] value) {
            return liteOrm.query(new QueryBuilder(cla).where(field + "=?", value));
        }
    
        /** * 查询 某字段 等于 Value的值 可以指定从1-20，就是分页 */
        @SuppressWarnings("unchecked")
        public <T> List<T> queryByWhereLength(Class<T> cla, String field, String[] value, int start, int length) {
            return liteOrm.query(new QueryBuilder(cla).where(field + "=?", value).limit(start, length));
        }
    
        /** * 删除一个数据 */
        public <T> void delete(T t) {
            liteOrm.delete(t);
        }
    
        /** * 删除所有数据 */
        public <T> void deleteAll(Class<T> clazz) {
            liteOrm.deleteAll(clazz);
        }
    
        /** * 删除集合中的数据 */
        public <T> void deleteList(List<T> list) {
            liteOrm.delete(list);
        }
    
        /** * 删除数据库 */
        public void deleteDatabase() {
            liteOrm.deleteDatabase();
        }
    }

### liteorm的使用 ###

@Table("tb_user")
    public class User { 
        @PrimaryKey(AssignType.AUTO_INCREMENT)//主键，自增
        private long id;
        @NotNull
        private String name;
        private int age;
    
        public User(){}
        public User(long id, String name, int age) {
            this.id = id;
            this.name = name;
            this.age = age;
        }
    
        public long getId() {
            return id;
        }
    
        public void setId(long id) {
            this.id = id;
        }
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        public int getAge() {
            return age;
        }
    
        public void setAge(int age) {
            this.age = age;
        }
    
        @Override
        public String toString() {
            return "User{" +
                    "id=" + id +
                    ", name='" + name + '\'' +
                    ", age=" + age +
                    '}';
        }
    }

MainActivity

public class MainActivity extends AppCompatActivity implements View.OnClickListener { 
    
        private Button insert;
        private Button update;
        private Button query;
        private Button queryAll;
        private Button delete;
        private Button deleteAll;
        private TextView tv_query;
        private TextView tv_queryall;
        private DataBaseManager manager;
    
        @Override
        protected void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.activity_main);
    
            insert = (Button) findViewById(R.id.btn1);
            update = (Button) findViewById(R.id.btn2);
            query = (Button) findViewById(R.id.btn3);
            queryAll = (Button) findViewById(R.id.btn4);
            delete = (Button) findViewById(R.id.btn5);
            deleteAll = (Button) findViewById(R.id.btn6);
    
            tv_query = (TextView) findViewById(R.id.tv_query);
            tv_queryall = (TextView) findViewById(R.id.tv_queryall);
    
            insert.setOnClickListener(this);
            update.setOnClickListener(this);
            query.setOnClickListener(this);
            queryAll.setOnClickListener(this);
            delete.setOnClickListener(this);
            deleteAll.setOnClickListener(this);
    
            manager = DataBaseManager.getInstance(MainActivity.this);
        }
    
        private void deleteAll() {
            manager.deleteAll(User.class);
        }
    
        private void deleteData() {
            User user = new User();
            user.setId(1);
            manager.delete(user);
        }
    
        private List<User> queryAll() {
            return manager.queryAll(User.class);
        }
    
        private User queryData() {
            return manager.query(1, User.class);
        }
    
        private void updateData() {
            User user = new User(1, "lisi", 28);
            manager.update(user);
        }
    
        private void insertData() {
            User user1 = new User(1, "zhangsan", 20);
            manager.insert(user1);
            User user2 = new User(2, "zhangsan", 20);
            manager.insert(user2);
            User user3 = new User(3, "zhangsan", 20);
            manager.insert(user3);
            User user4 = new User(4, "zhangsan", 20);
            manager.insert(user4);
    
            //inserAll
    // List<User> list = new ArrayList<>();
    // list.add(user1);
    // list.add(user2);
    // list.add(user3);
    // list.add(user4);
    // manager.insertAll(list);
        }
    
        @Override
        public void onClick(View v) {
            switch (v.getId()) {
                case R.id.btn1:
                    insertData();
                    break;
                case R.id.btn2:
                    updateData();
                    break;
                case R.id.btn3:
                    User user = queryData();
                    if (user == null) {
                        tv_query.setText("查询的数据不存在");
                    } else {
                        tv_query.setText(user.toString());
                    }
                    break;
                case R.id.btn4:
                    List<User> list = queryAll();
                    if (list == null) {
                        tv_queryall.setText("查询的数据不存在");
                    } else {
                        tv_queryall.setText(list.toString());
                    }
                    break;
                case R.id.btn5:
                    deleteData();
                    break;
                case R.id.btn6:
                    deleteAll();
                    break;
            }
        }
    }

![image][]

[Link 1]: http://litesuits.com/
[20160828225333085]: /images/20220717/112899d92ba545a6997e7ba85e1d52f2.png
[image]: /images/20220717/50e8e766628f4dafbb2b12d648082c98.png