hibernate 集合查询：

1 public Long getPurchaseRecordByBlueIdCount(List
     
       blueIdList) { 2         StringBuilder sql = new StringBuilder(); 3         //--投保人姓名（只显示姓名字脱敏处理）、产品名称、保费、购买数量、成交时间 4         sql.append("SELECT count(1)"); 5         sql.append("FROM ISP_POLICY pol, ISP_APP_CUSTOMER AC, ISP_BLUEPRINT BP,isp_apply ap "); 6         sql.append("WHERE 1 = 1 "); 7         sql.append("AND AC.APPLY_ID = AP.APPLY_ID "); 8         sql.append("AND AC.CUST_TYPE = 1 "); 9         sql.append("AND AP.BLUE_ID = BP.BLUE_ID ");10         sql.append("AND ap.policy_no = pol.policy_no ");11         sql.append("AND bp.blue_fee_type = 1 ");12         sql.append("AND bp.blue_id in (:blueIdList) ");13         14         LogTool.debug(this.getClass(), sql.toString(),true);15         LogTool.debug(this.getClass(), "blueIdList: "+blueIdList.toString(),true);16         Query query = super.getSession().createSQLQuery(sql.toString());17         query.setParameterList("blueIdList", blueIdList);18         BigDecimal count = (BigDecimal)query.uniqueResult();19         20         LogTool.debug(this.getClass(), "size: "+count);21         return count.longValue();22     }