Hibernate记录

like

query.append(" AND lci.aaa like :aaa");
parameters.put("aaa", "%" + value + "%");

大于/小于/等于

t1.sign_time>=:Sign_StartDate
queryParameterMap.put("Sign_StartDate", sdf.parse(searchFieldMap.get(key)));

t2.sign_time<=:Sign_EndDate
queryParameterMap.put("Sign_EndDate", sdfTime.parse(searchFieldMap.get(key)+" 23:59:59"));

参数

规则：冒号+变量名
info.EXECUTOR_ACCOUNT=:owner_account  OR FIND_IN_SET( :owner_account,info.SEAL_ADMINISTRATOR_CODE ))
Map<String, String> parameters = new HashMap<String, String>();
        parameters.put("owner_account", owner.getAccount());

列表参数

oppNameArr = oppNameStr.split(",");
List<String> namesList  =  Arrays.asList(oppNameArr);
query.append(" and id in (select lcor.idfrom xxx lcor where lcor.AAAA IN (:namesList) ) ");
queryParameterMap.put("namesList", namesList);