dhroid-Dhdborm简化sqlite数据库操作

//数据库初始化
DhDB db=IocContainer.getShare().get(DhDB.class);
db.init("dhdbname", Const.DATABASE_VERSION);

db.initInSD("文件夹位置", "dhdbname", Const.DATABASE_VERSION);

bean定义
@Entity(table="student")
public class Student {

@Column(pk=true)//主键不能为基本类型
public Long id;
public String name;
@Column(name="num_no")
public String num;
@Column(name="create_time")
public Date createTime;
public int age;
public int sex;
public boolean dangyuang;

@NoColumn
public String temp;
//setget...
}

@Inject
DhDB db;

 

 


保存和更新
if(student == null){
student=new Student();
isnew=true;
}
student.setName(nameV.getText().toString());
student.setNum(numV.getText().toString());
student.setSex(Integer.parseInt(sexV.getText().toString()));
student.setAge(Integer.parseInt(ageV.getText().toString()));
student.setDangyuang(dangyuanV.getText().toString().equals("1")?true:false);
student.setCreateTime(new Date());
if(isnew){
db.save(student);
}else{
db.update(student);
}

db.delete(student);

List list=db.queryList(Student.class, ":name like ? or :num like ?","%name%","%num%");