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;
}
});
}
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;
}
});
}