1.首先学简单的配置
https://www.jianshu.com/p/ec37ea99ef69 , https://www.jianshu.com/p/53083f782ea2
2.简单的增删改查
https://www.jianshu.com/p/53083f782ea2
3.稍复杂的查
QueryBuilder很重要
1.且查询(下面例子查username == xxx且userpwd==xxx的数据)
Query query = daoSession.queryBuilder(UserBean.class).where(UserBeanDao.Properties.UserName.eq(userName)).where(UserBeanDao.Properties.UserPwd.eq(userPwd)).build();
List<UserBean> list = query.list();
2.或查询(查询买方是currentUserName或者卖方是currentUserName的所有数据)
QueryBuilder qb = daoSession.getOrderBeanDao().queryBuilder();
//查询涉及到本人的订单,都列出来(本人作为买方或者卖方都查出来)
qb.whereOr(OrderBeanDao.Properties.OrderBuyUser.eq(MyApplication.currenUserName), OrderBeanDao.Properties.OrderSeilUser.eq(MyApplication.currenUserName));
datas = qb.list();
3.删除查询(删掉xxx条件下的数据,下面例子是删除当前OwenerId所关联的全部数据)
QueryBuilder<Book> queryBuilder = daoSession.queryBuilder(Book.class).where(BookDao.Properties.OwnerId.eq(MyApplication.currenUserId));
DeleteQuery<Book> deleteQuery = queryBuilder.buildDelete();
deleteQuery.executeDeleteWithoutDetachingEntities();
多表关联
看这两篇
https://www.cnblogs.com/woaixingxing/p/7772138.html
https://blog.csdn.net/RobotHost/article/details/70098744
一对一toone 主外键
一对多 tomany主外键