@Entity(nameInDb = "person_table")
public class Person {
@Id(autoincrement = true)
public Long id;
public String name;
public int age;
@Transient
public String sex;
daoMangre
package com.bwie.greendao;
import android.content.Context;
/**
* Created by dell on 2018/11/1.
*/
public class DaoManager {
private static DaoManager daoManager;
private DaoSession daoSession;
private DaoManager(Context context){
daoSession = DaoMaster.newDevSession(context,"person.db");
}
public static DaoManager getDaoManager(Context context){
if (daoManager == null){
synchronized (DaoManager.class){
if (null == daoManager){
daoManager = new DaoManager(context);
}
}
}
return daoManager;
}
public DaoSession getDaoSession(){
return daoSession;
}
}
activity
package com.bwie.greendao;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Toast;
import java.util.List;
public class MainActivity extends AppCompatActivity {
private DaoSession daoSession;
private int index;
private PersonDao personDao;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
daoSession = DaoManager.getDaoManager(this).getDaoSession();
personDao = daoSession.getPersonDao();
}
public void btn_add(View view) {
index++;
Person person = new Person(null,"name"+index,index*10);
personDao.insert(person);
}
public void btn_del(View view) {
Person person = personDao.queryBuilder()
.where(PersonDao.Properties.Id.eq(2))
.build()
.unique();
if (person != null){
personDao.delete(person);
}
}
public void btn_update(View view) {
List<Person> list = personDao.queryBuilder()
.where(PersonDao.Properties.Age.lt(500))
.orderDesc(PersonDao.Properties.Age)
.build()
.list();
for (Person person : list) {
if (person.age == 20){
person.age = 100;
personDao.update(person);
}
}
}
public void btn_query(View view) {
List<Person> list = personDao.queryBuilder()
.where(PersonDao.Properties.Age.lt(500))
.orderDesc(PersonDao.Properties.Age)
.build()
.list();
for (Person person : list) {
Log.e("tag", "btn_query: "+person.toString() );
}
}
}