创建单例类Student类
@Entity
public class Student {@Id(autoincrement = true)
private Long id;
@Property(nameInDb = "name")
private String name;
@Property(nameInDb = "age")
private int age;
@Property(nameInDb = "gender")
private String gender;
@Transient
private String url;
@Generated(hash = 1368667304)
public Student(Long id, String name, int age, String gender) {
this.id = id;
this.name = name;
this.age = age;
this.gender = gender;
}
@Generated(hash = 1556870573)
public Student() {
}
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 int getAge() {
return this.age;
}
public void setAge(int age) {
this.age = age;
}
public String getGender() {
return this.gender;
}
public void setGender(String gender) {
this.gender = gender;
}
@Override
public String toString() {
return "Student{" +
"id=" + id +
", name='" + name + '\'' +
", age=" + age +
", gender='" + gender + '\'' +
", url='" + url + '\'' +
'}';
}
}
Activity正文
public class MainActivity extends AppCompatActivity implements View.OnClickListener {
private Button insert;
private Button delete;
private Button query;
private Button update;
private StudentDao studentDao;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
initView();
initDb();
}
private void initDb() {
//1、创建DevOpenHelper对象,创建数据库
DaoMaster.DevOpenHelper helper = new DaoMaster.DevOpenHelper(this,"student.db");
//2、创建Daomaster对象
DaoMaster master = new DaoMaster(helper.getWritableDatabase());
//3、获取DaoSession对象
DaoSession daoSession = master.newSession();
//4、获取Dao对象
studentDao = daoSession.getStudentDao();
}
private void initView() {
insert = (Button) findViewById(R.id.insert);
delete = (Button) findViewById(R.id.delete);
query = (Button) findViewById(R.id.query);
update = (Button) findViewById(R.id.update);
insert.setOnClickListener(this);
delete.setOnClickListener(this);
query.setOnClickListener(this);
update.setOnClickListener(this);
}
@Override
public void onClick(View v) {
switch (v.getId()) {
case R.id.insert:
Student student = new Student(null,"张三"+System.currentTimeMillis(),18,"男");
studentDao.insert(student);
break;
case R.id.delete:
List<Student> list = studentDao.queryBuilder().list();
studentDao.delete(list.get(list.size()-1));
break;
case R.id.query:
list = studentDao.queryBuilder().list();
Log.e("TAG",list.toString());
break;
case R.id.update:
list = studentDao.queryBuilder().list();
Student student1 = list.get(list.size() - 1);
student1.setGender("女");
studentDao.update(student1);
break;
}
}
}