ViewStoreStockLib lib = new ViewStoreStockLib();
lib.getQuery().addCondition(ViewStoreStockLib.Field.district, Operator.IN, codeList);
lib.getQuery().addCondition(ViewStoreStockLib.Field.disable, "0");
Selects selects = QB.selectFrom(lib.getQuery());
selects.column(ViewStoreStockLib.Field.grainBreed).group();
selects.column(ViewStoreStockLib.Field.grainBreedname).group();
selects.column(ViewStoreStockLib.Field.num).sum().as("num");
try {
libs = dao.getSession().selectAs(lib.getQuery(), ViewStoreStockLib.class);
} catch (SQLException e) {
throw DbUtils.toRuntimeException(e);
}
利用框架进行group,sum等操作
最新推荐文章于 2022-09-16 14:12:36 发布