Hibernate HQL基础 distinct关键字
时间:2010-10-10 来源:juxiangwu
在HQL中可以使用distinct关键字,其作用与SQL中的同名关键相同,均在返回记录中除去重复的记录
示例:
public void testUseDistinct(){
Session session = null;
session = HibernateUtils.getCurrentSession();
String hql = "select distinct name from Guestbook";
Query query = session.createQuery(hql);
List<String> list = query.list();
HibernateUtils.closeSession(session);
int i = 0;
for(String name : list){
System.out.println(name);
i++;
}
}
示例:
public void testUseDistinct(){
Session session = null;
session = HibernateUtils.getCurrentSession();
String hql = "select distinct name from Guestbook";
Query query = session.createQuery(hql);
List<String> list = query.list();
HibernateUtils.closeSession(session);
int i = 0;
for(String name : list){
System.out.println(name);
i++;
}
}
相关阅读 更多 +