nutz笔记(一)

最新推荐文章于 2019-05-07 15:41:54 发布

胖仔小哥哥

最新推荐文章于 2019-05-07 15:41:54 发布

阅读量539

点赞数

分类专栏：学习文章标签： NUTZ

本文链接：https://blog.csdn.net/u012925673/article/details/75286251

版权

public static Map<Long, ShopInfoModel.ShopCategory> getShopCategoryLst(long groupID,
                                                                    Collection shops) {

    //1.组装脚本语句
    StringBuilder sb = new StringBuilder();
    sb.append("select c.shopCategoryID,c.shopCategoryName,c.shopID");
    sb.append(" from tbl_shop_base_info_class c where c.groupID=" + groupID);
    sb.append(" and c.action in (0,1) and c.shopID!=0");
    String shopInCondition = Utils.parseInCondition(shops);
    if (shopInCondition != null) {
      sb.append(" and c.shopID IN ").append(shopInCondition);
    }
    
    //2.创建sql对象
    Sql sql = Sqls.create(sb.toString());
    logger.debug("getShopCategoryLst sql:" + sql.toString());

    //3.设置回调函数
    sql.setCallback(new SqlCallback() {

      @Override
      public Map<Long, ShopInfoModel.ShopCategory> invoke(Connec