Hibernate的HQL查询
static List query(String name){
Session session = null;
try{
s = HibernateUtil.getSession();
String hql = "from User as user where user.name =?";
Query query = s.createQuery(hql); //查询语句
query.setString(0,name);//参数传递,下标从零开始、、
// query.setString("name",name);//String hql = "from User as user where user.name =:name";
// query.setFirstResult(1) //分页
// query.setMaxResults(10) // 分页
// User u = (User)query.uniqueResult(); //当确定查询结果只有一个对象,多个时会报错
List list = qyery.list();//执行查询
}finally{
if(s!=null)
s.close();
}
return list
}
相关推荐
  LetonLIU    2020-03-28  
   tugangkai    2020-07-04  
   taisenki    2020-06-02  
   zzjmay    2020-05-17  
   shuiluobu    2020-03-20  
   solarspot    2014-06-27  
   LetonLIU    2019-12-23  
   东方咖啡屋    2019-12-08  
   浮生    2011-12-12  
   surpassdream    2011-12-11  
   keruis    2015-02-03  
   小黄鸡kimhuhg    2015-02-16  
   Lingforme    2015-07-23  
   bigcactus    2012-05-21  
   张浩BIT    2012-04-22  
   虽然我很菜    2016-01-08  
   WJI    2014-11-06  
   kobexing    2014-07-16  
   crazzylp    2014-01-08  
 