方法一:
if(StringUtil.isNotBlank(receivingFilter)){
hql.append(" and (a.receivingBillcode like ? or a.companyName like ? or a.partsnameName like ? or a.goodsContractstr2 like ?)");
params.add("%"+receivingFilter+"%");
params.add("%"+receivingFilter+"%");
params.add("%"+receivingFilter+"%");
params.add("%"+receivingFilter+"%");}
方法二:
if(StringUtil.isNotBlank(receivingFilter)){
hql.append(" and (a.receivingBillcode like '%'||?||'%' or a.companyName like '%'||?||'%' or a.partsnameName like '%'||?||'%' or a.goodsContractstr2 like '%'||?||'%')");
params.add(receivingFilter);
params.add(receivingFilter);
params.add(receivingFilter);
params.add(receivingFilter);}