Question

this.getHibernateTemplate().findByCriteria(criteria);为什么只有首次有效，第二次开始返回的都是空？

public List<Employee> findEmp(Employee emp) {
if (emp != null) {
if (emp.getCode() != null
&& String.valueOf(emp.getCode()).trim().length() > 0) {
System.out.println("~Code = " + emp.getCode());
criteria.add(Restrictions.eq("code", emp.getCode()));
}
if (emp.getName() != null
&& String.valueOf(emp.getName()).trim().length() > 0) {
System.out.println("~Name = " + emp.getName());
criteria.add(Restrictions.like("name", emp.getName(),
MatchMode.ANYWHERE));
}
}

List<Employee> list = this.getHibernateTemplate().findByCriteria(
criteria);
System.out.println("~List.size = " + list.size());
return list;
}
控制台打印：
~Code = 11
Hibernate: select this_.id as id0_0_, this_.code as code0_0_, this_.name as name0_0_, this_.birthday as birthday0_0_, this_.sex as sex0_0_, this_.telephone as telephone0_0_, this_.email as email0_0_ from employee this_ where this_.code=?
~List.size = 1
~Code = 111
Hibernate: select this_.id as id0_0_, this_.code as code0_0_, this_.name as name0_0_, this_.birthday as birthday0_0_, this_.sex as sex0_0_, this_.telephone as telephone0_0_, this_.email as email0_0_ from employee this_ where this_.code=? and this_.code=?
~List.size = 0

明明有值传进去啊，就算不传都是可以把全部记录查询出来的，求解啊！！！难受！！！

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励10（财富值+成长值）+提问者悬赏5（财富值+成长值）

Answer 1

我也遇到这样的问题,正在研究
没有答案，eq的方法无法传进去值，一直为空
但是换个方法就好了
你要不试试sqlRestriction方法，它也是Restrictions提供的方法，你试一下

Answer 2

criteria.add(Restrictions.eq("code", emp.getCode()));

重复了

追问

我看HQL发现，第一次的时候是：where this_.code=?，第二次的时候是：where this_.code=? and this_.code=?

感觉好像是把我第一次的也add到了第二次上了，请问要怎么修改呢？