一、使用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);
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);