023——hibernate统计查询

最新推荐文章于 2022-01-02 11:00:00 发布

MsjGodBoy

最新推荐文章于 2022-01-02 11:00:00 发布

阅读量230

点赞数

分类专栏： Hibernate 文章标签： hibernate统计查询

本文链接：https://blog.csdn.net/msj_god_boy/article/details/51991808

版权

Hibernate 专栏收录该内容

23 篇文章 0 订阅

订阅专栏

实体类和映射文件请参考015篇

测试类：

package test;

import java.util.List;

import junit.framework.TestCase;

import org.hibernate.Session;

import com.java.hibernate.HibernateUtils;

public class StateQueryTest extends TestCase {

	public void testQuery1() {
		Session session = null;
		try {
			session = HibernateUtils.getSession();
			session.beginTransaction();
			
//			List list = session.createQuery("select count(*) from Student").list();
//			Long count = (Long)list.get(0);
			
			Long count = (Long)session.createQuery("select count(*) from Student").uniqueResult();
//			Long count = (Long)session.createQuery("select count(*) from Student").setMaxResults(1).uniqueResult();
			System.out.println("count=" + count);
			
			session.getTransaction().commit();
		} catch (Exception e) {
			e.printStackTrace();
			session.getTransaction().rollback();
		} finally {
			HibernateUtils.closeSession(session);
		}
	}
	
	public void testQuery2() {
		Session session = null;
		try {
			session = HibernateUtils.getSession();
			session.beginTransaction();
			String hql = "select c.name, count(s) from Classes c join c.students s group by c.name order by c.name";
			List students = session.createQuery(hql).list();
			for (int i=0; i<students.size(); i++) {
				Object[] obj = (Object[])students.get(i);
				System.out.println(obj[0] + "------" + obj[1]);
			}
			session.getTransaction().commit();
		}catch(Exception e) {
			e.printStackTrace();
			session.getTransaction().rollback();
		}finally {
			HibernateUtils.closeSession(session);
		}
	}
}