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