高級查詢
//高級查詢
/**
* 提交標(biāo)準(zhǔn)SQL到DB查詢
*/
public void query1(){
List<Member> list = manager.getDaoSession().queryRaw(Member.class,"where MEM_NAME like ? and _id > ?",new String[]{"%張三%","50"});
Logger.d(list.toString());
}
/**
* 提交QueryBuilder到DB查詢
*/
public void query2(){
QueryBuilder<Member> builder = manager.getDaoSession().queryBuilder(Member.class);
List<Member> list = builder.where(MemberDao.Properties.MemSex.ge(99)).list();
Logger.d("QueryBuilder-->"+list.toString());
}
/**
* 提交QueryBuilder到DB查詢
*/
public void query3(){
QueryBuilder<Member> builder = manager.getDaoSession().queryBuilder(Member.class);
List<Member> list = builder.whereOr(MemberDao.Properties.MemSex.le(30),MemberDao.Properties.MemName.like("張三1%")).list();
Logger.d("QueryBuilder-->"+list.toString());
}
DEMO入口
