hibernate条件查询:数据库中有student表,表中有:“id,name,sex,age”四个字段,要求hql查询语句查询:“男性中(sex)名字(name)相同的项,并且相同项数量大于10,查询结果以list<实体>返回
先做一个实体类
private String id;
private String name;
private String age;
private String sex;
private long count; //相同名字的数量
public Stu(String name,long count){
this.name = name;
this.count = count;
}
//下面是上面属性的setget方法
HQL语句
//创建一个查询String hql = "select new com.turing.hibernate.entity.Stu(name,count(*)) from Stu where sex='男' group by name having count(*) > 10";
Query query = session.createQuery(hql);
List<Stu> list = query.list();
for (int i = 0; i < list.size(); i++) {
Stu p = (Stu) list.get(i);
System.out.println(p.getName());
}
温馨提示:答案为网友推荐,仅供参考