hibernate 查询
String hql = "select * from Commodity where commodityName like :commodityname";
Query q = sessionFactory.getCurrentSession().createSQLQuery(hql).addEntity(Commodity.class);
q.setParameter("commodityname", "%"+commodityName+"%",Hibernate.STRING);
// q.setString(0,commodityName);
// q.executeUpdate();
List<Commodity> res = q.list();
System.out.print(res.get(0).getCommodityName());
commodityName 是传入的参数。Commodity是一个实体.
上述代码实现的是模糊查询功能。如果要实现非模糊查询,则将%去掉即可。
@Resource
private SessionFactory sessionFactory;
public List<Commodity> getAllCommodity() { try { return sessionFactory.getCurrentSession().createQuery( "from Commodity order by soldNumbers desc").list(); } catch (Exception e) { System.out.print(e.getMessage()); return null; } }
上述代码实现简单的查询