GreenDAO ORM

1.简介

GreenDAO是一个将对象映射到SQlite数据库中的轻量且快速的ORM解决方案
官网:http://greenrobot.org/greendao/
源码:https://github.com/greenrobot/greenDAO

# git clone https://github.com/greenrobot/greenDAO

2.添加greenDAO到工程项目中

在build.gradle(Project)中添加
buildscript {
    
    repositories {
        google()
        jcenter()
        mavenCentral() //add repository
    }
    dependencies {
        classpath 'com.android.tools.build:gradle:3.0.1'
        classpath 'org.greenrobot:greendao-gradle-plugin:3.2.2' //add plugin
    }
}
在build.gradle(Model)中添加
在android{}之前添加
apply plugin: 'org.greenrobot.greendao' //add plugin
dependencies {
    
    compile 'org.greenrobot:greendao:3.2.2' //add library
}
添加完成后同步一下gradle

3.创建一个User的实体类

@Entity
public class User {
    @Id
    private Long id;
    @NotNull
    private String name; //姓名
    private String age;

}
greendao中的注解
1)@Entity 定义实体
@nameInDb 在数据库中的名字，如不写则为实体中类名
@indexes 索引
@createInDb 是否创建表，默认为true,false时不创建
@schema 指定架构名称为实体
@active 无论是更新生成都刷新
2)@Id 数据库的主键,实体的ID
3)@NotNull 使字段在数据库中成为非空字段
4)@Unique 唯一约束
5)@ToMany 一对多
6)@OrderBy 排序
7)@ToOne 一对一
8)@Transient 不存储在数据库中
9)@generated 由greendao产生的构造函数或方法

创建完后build Project
User实体类自动生成相应的get,set方法
@Entity
public class User {
    @Id
    private Long id;
    @NotNull
    private String name; //姓名
    private String age;
    @Generated(hash = 1072248277)
    public User(Long id, @NotNull String name, String age) {
        this.id = id;
        this.name = name;
        this.age = age;
    }
    @Generated(hash = 586692638)
    public User() {
    }
    public Long getId() {
        return this.id;
    }
    public void setId(Long id) {
        this.id = id;
    }
    public String getName() {
        return this.name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getAge() {
        return this.age;
    }
    public void setAge(String age) {
        this.age = age;
    }

}

在project视图下
app/build/generated/source/greendao下生成了三个文件
DaoMaster:管理数据库
DaoSession:管理所有的xxxDao
UserDao:对实体进行操作

4.获取UserDao

DaoMaster.DevOpenHelper helper = new DaoMaster.DevOpenHelper(this, "user-db");
Database db = helper.getWritableDb();
daoSession = new DaoMaster(db).newSession();
userDao = daoSession.getUserDao();

基它Activity获取mUserDao = MainActivity.getInstances().getDaoSession().getUserDao();

5.操作

1)增加
 User user = new User();
 user.setName(name);
 user.setAge(age);
 userDao.insert(user);

2)查询
users = userDao.loadAll();

3)删除
 userDao.delete(users.get(i));

4)修改
 user.setId(users.get(i).getId());
 user.setName(name);
 user.setAge(age);
 userDao.update(user);

Demo功能

输入姓名,年龄,点增加加入一条数据

点击选项(短按)删除一条数据

长按删除一条数据

public class MainActivity extends AppCompatActivity {
    private EditText edName;
    private EditText edAge;
    private Button btAdd;
    private ListView lv;
    private List<User> users;
    private UserAdapter userAdapter;

    private DaoSession daoSession;
    private UserDao    userDao;
    public static MainActivity instances;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        instances = this;


        //get the UserDAO
        DaoMaster.DevOpenHelper helper = new DaoMaster.DevOpenHelper(this, "user-db");
        Database db = helper.getWritableDb();
        daoSession = new DaoMaster(db).newSession();
        userDao = daoSession.getUserDao();

        setUpViews();

    }

    public static MainActivity getInstances(){
        return instances;
    }

    public DaoSession getDaoSession(){
        return daoSession;
    }

    protected void setUpViews(){
        edName = (EditText)findViewById(R.id.edName);
        edAge  = (EditText)findViewById(R.id.edAge);
        btAdd  = (Button)findViewById(R.id.btAdd);
        btAdd.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                addUser();
            }
        });
        lv = (ListView)findViewById(R.id.lv_user);
        userAdapter = new UserAdapter(this);
        users = userDao.loadAll();
        lv.setAdapter(userAdapter);
        //单击选项修改,从ed获取数据
        lv.setOnItemClickListener(new AdapterView.OnItemClickListener() {
            @Override
            public void onItemClick(AdapterView<?> adapterView, View view, int i, long l) {
                User user = new User();

                String name = edName.getText().toString();
                String age = edAge.getText().toString();
                if(!name.isEmpty() && !age.isEmpty()){
                    user.setId(users.get(i).getId());
                    user.setName(name);
                    user.setAge(age);
                    userDao.update(user);
                    updateUsers();
                    Toast.makeText(getInstances(),
                            "你修改了一条数据",Toast.LENGTH_LONG).show();
                }else{
                    Toast.makeText(getInstances(),
                            "请输入要修改的姓名和年龄",Toast.LENGTH_LONG).show();
                }


            }
        });
        //长按选项删除
        lv.setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() {
            @Override
            public boolean onItemLongClick(AdapterView<?> adapterView, View view, int i, long l) {
                Toast.makeText(getInstances(),
                        "你删除了一条信息",Toast.LENGTH_LONG).show();
                userDao.delete(users.get(i));
                updateUsers();
                return false;
            }
        });




    }

    private void addUser(){
        String name = edName.getText().toString();
        edName.setText("");
        String age = edAge.getText().toString();
        edAge.setText("");
        if(!name.isEmpty() && !age.isEmpty()){
            User user = new User();
            user.setName(name);
            user.setAge(age);
            userDao.insert(user);
            //更新查询的表listView

            updateUsers();

        }else{
            Toast.makeText(this,
                    "请输入正确的信息",Toast.LENGTH_LONG).show();
        }
    }

    private void updateUsers(){
        users = userDao.loadAll();
        userAdapter.notifyDataSetChanged();

    }

    static class ViewHolder{
        TextView id;
        TextView name;
        TextView age;
    }
    private class UserAdapter extends BaseAdapter{
        private LayoutInflater mInflator;

        public UserAdapter(Context context){
            this.mInflator = LayoutInflater.from(context);
        }

        @Override
        public int getCount() {
            return users.size();
        }

        @Override
        public long getItemId(int i) {
            return 0;
        }

        @Override
        public Object getItem(int i) {
            return null;
        }

        @Override
        public View getView(int i, View view, ViewGroup viewGroup) {
            ViewHolder viewHolder = null;
            if(view == null){
                viewHolder = new ViewHolder();
                view = mInflator.inflate(R.layout.lv_student,null);

                viewHolder.id   = (TextView)view.findViewById(R.id.user_id);
                viewHolder.name = (TextView)view.findViewById(R.id.user_name);
                viewHolder.age  = (TextView)view.findViewById(R.id.user_age);

                view.setTag(viewHolder);
            }else {
                viewHolder = (ViewHolder)view.getTag();
            }

                User user = users.get(i);
                viewHolder.id.setText(user.getId().toString());
                viewHolder.name.setText(user.getName());
                viewHolder.age.setText(user.getAge());
            return view;
        }
    }
}