hibernate 集合查询

hibernate 集合查询:

 public Long getPurchaseRecordByBlueIdCount(List<Long> blueIdList) {
StringBuilder sql = new StringBuilder();
//--投保人姓名(只显示姓名字脱敏处理)、产品名称、保费、购买数量、成交时间
sql.append("SELECT count(1)");
sql.append("FROM ISP_POLICY pol, ISP_APP_CUSTOMER AC, ISP_BLUEPRINT BP,isp_apply ap ");
sql.append("WHERE 1 = 1 ");
sql.append("AND AC.APPLY_ID = AP.APPLY_ID ");
sql.append("AND AC.CUST_TYPE = 1 ");
sql.append("AND AP.BLUE_ID = BP.BLUE_ID ");
sql.append("AND ap.policy_no = pol.policy_no ");
sql.append("AND bp.blue_fee_type = 1 ");
sql.append("AND bp.blue_id in (:blueIdList) "); LogTool.debug(this.getClass(), sql.toString(),true);
LogTool.debug(this.getClass(), "blueIdList: "+blueIdList.toString(),true);
Query query = super.getSession().createSQLQuery(sql.toString());
query.setParameterList("blueIdList", blueIdList);
BigDecimal count = (BigDecimal)query.uniqueResult(); LogTool.debug(this.getClass(), "size: "+count);
return count.longValue();
}
上一篇:IO(文件)处理


下一篇:android之imgView插件的使用