public List
String hql = "FROM UserInfo u WHERE u.loginId = ? ";
return getHibernateTemplate().find(hql, loginId);
}
private HibernateTemplate hibernateTemplate;
public void setSessionFactory(SessionFactory sessionFactory) {
hibernateTemplate = new HibernateTemplate(sessionFactory);
}//sessionFactory通过Spring注入 查询用hibernateTemplate.get或
hibernateTemplate.find()方法
public Student findStudentById(Integer id) {
Student s = (Student)hibernateTemplate.get(Student.class, id);
return s;
}
string sql = “select * from post where xxx like '%abc%'"; sqlquery query = session.createsqlquery(sql); if (params != null) { for (int i = 0; i < params.length; i++) { query.setparameter(i, params[i]); } } query.setmaxresults(pagesize); query.setfirstresult((pagenumber - 1) * pagesize); list result = query.list(); 大致这样,具体要自己整理