动态绑定参数
/**
* 动态绑定参数
* @param id
* @param name
* @return
*/
@SuppressWarnings("unchecked")
public List<Employee> findByDongTaiBangDing(final int id, final String name) {
return (List<Employee>) this.getHibernateTemplate().execute(
new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException,SQLException {
String hql ="from Employee as e where e.employeeId >= :id and e.employeeName like :name";
Query query = session.createQuery(hql);
query.setInteger("id", id);
query.setString("name", "%"+name+"%");
List<User> list = (List<User>) query.list();
return list;
}
});
}