ormlite 多表联合查询

最新推荐文章于 2021-05-27 14:55:14 发布

A08110123

最新推荐文章于 2021-05-27 14:55:14 发布

阅读量392

点赞数

原文链接：http://www.cnblogs.com/androidsuperman/p/4208392.html

版权

ormlite 多表联合查询

QueryBuilder shopBrandQueryBuilder = shopBrandDao.queryBuilder();
QueryBuilder shopQueryBuilder = shopDao.queryBuilder();

Where shopBrandWhere = shopBrandQueryBuilder.where();
shopBrandWhere .eq(ShopBrand.SHOP_NO, shopNo);

Where shopWhere = shopQueryBuilder.where();
shopWhere
.like(Shop.SHOP_CODE, "%" + serch + "%")
.or()
.like(Shop.SHOP_LNAME, "%" + serch + "%");

QueryBuilder resultQueryBuilder =          
shopBrandQueryBuilder
.join(shopQueryBuilder);
shopBrands=resultQueryBuilder.query();

转载于:https://www.cnblogs.com/androidsuperman/p/4208392.html