笔记:
1.关键字模糊查找
sql:
a.JOB_NAME like '%jobName%' or a.JOB_KEY like '%jobName%'
hql:
hqlSb.append(" and a.jobName like ? or a.jobKey like ?");
params.add("%"+jobName+"%");
params.add("%"+jobName+"%");
有单引号和没单引号的区别!
笔记:
1.关键字模糊查找
sql:
a.JOB_NAME like '%jobName%' or a.JOB_KEY like '%jobName%'
hql:
hqlSb.append(" and a.jobName like ? or a.jobKey like ?");
params.add("%"+jobName+"%");
params.add("%"+jobName+"%");
有单引号和没单引号的区别!