在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++;
}
}
转载于:https://blog.51cto.com/wujuxiang/403682