spring+hibernate 中使用SESSION处理业务

最新推荐文章于 2024-09-21 22:45:23 发布

tameit

最新推荐文章于 2024-09-21 22:45:23 发布

阅读量458

点赞数

文章标签： session hibernate spring list query object

本文链接：https://blog.csdn.net/tameit/article/details/1544873

版权

public List findStudentByusername(final String username){
  return this.getHibernateTemplate().executeFind(new HibernateCallback(){
   public Object doInHibernate(Session session)
      throws HibernateException, SQLException {
      StringBuffer sb = new StringBuffer(100);
      sb.append("select distinct order ");
      sb.append("from Order order ");
      sb.append("join order.lineItems lineItems ");
      sb.append("where order.placedBy = :placedBy");
      sb.append("order by order.id");
      Query query = session.createQuery(sb.toString());
      query.setString("placedBy", username);
      List list = query.list();
      return list;
     }
  });
}