今天是需要过滤查询保单号,使用了 List 作为过滤条件,如下:
HQL: where id.publicPolicyId in(?)
java: query.setParameter(0, (ArrayList类型)tmpList);
但是总报错误,
Can not bind to Type java.util.ArrayList
问同事,原来更改条件设置方法:
query.setParameterList("plist", tmpList);
查询成功。
代码如下:
String hql = "select publicPolicyId from TMuster where musterDate >= ? and publicPolicyId between ? and ? ";
Query query = session.createQuery(hql);
query.setParameter(0, DateUtil.toDate("2010-01-01"));
query.setParameter(1, policyIdStart);
query.setParameter(2, policyIdEnd);
List tmpList = query.list();
if(tmpList == null){return null;}
// 过滤查询 TPolicyInsurantTemporary 非空条件
hql = "select id.publicPolicyId from TPolicyInsurantTemporary where id.publicPolicyId in(:plist) and name <> '' and cert <> '' and cerc <> '' ";
query = session.createQuery(hql);
query.setParameterList("plist", tmpList);
tmpList = query.list();
if(tmpList == null){return null;}
// 过滤查询 PublicPolicyTemporary 非空条件
hql = "from TPublicPolicyTemporary where publicPolicyId in(:plist) and applyName <> '' and applyCert <> '' and applyCerc <> '' and billNo <> '' ";
query = session.createQuery(hql);
query.setParameterList("plist", tmpList);
tmpList = query.list();
if(tmpList == null){return null;}
rstList = this.TPublicPolicyTrVO(tmpList);