public static DbManager
DB(){
DbManager.DaoConfig daoConfig =
new DbManager.DaoConfig().setDbName(
"bw.db").setDbVersion(
1)
;
DbManager db = x.
getDb(daoConfig)
;
return db
;
}
@Table(
name =
"students",onCreated =
"")
public class Student {
@Column(
name =
"id",isId =
true,autoGen =
true,property =
"NOT NULL")
private int id;
@Column(
name =
"name")
private String
name;
@Column(
name =
"age")
private int age;@Event({R.id.
btn_add,R.id.
btn_delete,R.id.
btn_update,R.id.
btn_look})
private void Text(View v){
DbManager db = MyApplication.
DB()
;
switch (v.getId()){
case R.id.
btn_add:
List<Student>list =
new ArrayList<>()
;
list.add(
new Student(
"zhangsan",18))
;
list.add(
new Student(
"lisi",19))
;
list.add(
new Student(
"wangwu",6))
;
list.add(
new Student(
"zhaoliu",9))
;
try {
db.save(list)
;
}
catch (DbException e) {
e.printStackTrace()
;
}
break;
case R.id.
btn_delete:
WhereBuilder b = WhereBuilder.
b()
;
b.and(
"age",">","16")
;
try {
db.delete(Student.
class,b)
;
}
catch (DbException e) {
e.printStackTrace()
;
}
break;
case R.id.
btn_update:
WhereBuilder bs = WhereBuilder.
b()
;
bs.and(
"id","=",2)
;
KeyValue s =
new KeyValue(
"name","sisi")
;
try {
db.update(Student.
class,bs
,s)
;
}
catch (DbException e) {
e.printStackTrace()
;
}
break;
case R.id.
btn_look:
try {
List<Student> all = db.findAll(Student.
class)
;
for (Student student : all) {
Log.
i(
"xxx",student.toString())
;
}
}
catch (DbException e) {
e.printStackTrace()
;
}
break;
}
}
转载请注明原文地址: https://ju.6miu.com/read-38577.html