ORMlite多表关联查询实现

一、使用ORMLite的API实现
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();

二、使用执行原生SQL实现

StringBuilder sqlbd = new StringBuilder(" select SUM(t2.payMoney) from order_data AS t1 ");
sqlbd.append(" INNER JOIN orderPay AS t2 ON t1.orderSyncId = t2.orderId ");

GenericRawResults<String[]> rawResults =orderDao.queryRaw(sqlbd.toString());
List<String[]> results = rawResults.getResults();


String[] resultArray = results.get(0);