hibernate学习笔记（day04）

hibernate学习流程

1. 查询-HQL语法

1. 基础语法

		String hql = " from  cn.itcast.domain.Customer ";//完整写法
		String hql2 = " from  Customer "; //简单写法
		String hql3 = " from java.lang.Object "; 
		
		Query query = session.createQuery(hql3);
		
		List list = query.list();
		
		System.out.println(list);

2. 排序

		String hql1 = " from  cn.itcast.domain.Customer order by cust_id asc ";//完整写法
		String hql2 = " from  cn.itcast.domain.Customer order by cust_id desc ";//完整写法
		
		Query query = session.createQuery(hql2);
		
		List list = query.list();
		
		System.out.println(list);

3. 条件

		String hql1 = " from  cn.itcast.domain.Customer where cust_id =? ";//完整写法
		String hql2 = " from  cn.itcast.domain.Customer where cust_id = :id ";//完整写法
		
		Query query = session.createQuery(hql2);
		
//		query.setParameter(0, 2l);
		query.setParameter("id", 2l);
		
		
		List list = query.list();

4. 分页

		String hql1 = " from  cn.itcast.domain.Customer  ";//完整写法
		Query query = session.createQuery(hql1);
		//limit ?,?
		// (当前页数-1)*每页条数
		query.setFirstResult(2);
		query.setMaxResults(2);
		
		List list = query.list();

5. 聚合

@Test
	//统计查询
	//count	计数
	//sum 	求和
	//avg	平均数
	//max
	//min
	public void fun5(){
		Session session = HibernateUtils.openSession();
		Transaction tx = session.beginTransaction();
		//----------------------------------------------------
		String hql1 = " select count(*) from  cn.itcast.domain.Customer  ";//完整写法
		String hql2 = " select sum(cust_id) from  cn.itcast.domain.Customer  ";//完整写法
		String hql3 = " select avg(cust_id) from  cn.itcast.domain.Customer  ";//完整写法
		String hql4 = " select max(cust_id) from  cn.itcast.domain.Customer  ";//完整写法
		String hql5 = " select min(cust_id) from  cn.itcast.domain.Customer  ";//完整写法
		
		Query query = session.createQuery(hql5);
		
		Number number  = (Number) query.uniqueResult();
		
		System.out.println(number);
		//----------------------------------------------------
		tx.commit();
		session.close();
		
	}

6. 投影

	String hql1 = " select cust_name from  cn.itcast.domain.Customer  ";
		String hql2 = " select cust_name,cust_id from  cn.itcast.domain.Customer  ";
		String hql3 = " select new Customer(cust_id,cust_name) from  cn.itcast.domain.Customer  ";
		
		Query query = session.createQuery(hql3);
		
		List list = query.list();

7. 多表查询

SQL
HQL

HQL语法

1. 内连接

@Test
	//HQL 内连接 => 将连接的两端对象分别返回.放到数组中.
	public void fun1(){
		Session session = HibernateUtils.openSession();
		Transaction tx = session.beginTransaction();
		//----------------------------------------------------
		String hql = " from Customer c inner join c.linkMens ";
		
		Query query = session.createQuery(hql);
		
		List<Object[]> list = query.list();
		
		for(Object[] arr : list){
			System.out.println(Arrays.toString(arr));
		}
		//----------------------------------------------------
		tx.commit();
		session.close();
		
	}

2. 左外链接

	@Test
	//HQL 左外连接 => 将连接的两端对象分别返回.放到数组中.
	public void fun3(){
		Session session = HibernateUtils.openSession();
		Transaction tx = session.beginTransaction();
		//----------------------------------------------------
		String hql = " from Customer c left join c.linkMens ";
		
		Query query = session.createQuery(hql);
		
		List<Object[]> list = query.list();
		
		for(Object[] arr : list){
			System.out.println(Arrays.toString(arr));
		}
		//----------------------------------------------------
		tx.commit();
		session.close();
		
	}
	

3. 右外连接

@Test
	//HQL 右外连接 => 将连接的两端对象分别返回.放到数组中.
	public void fun4(){
		Session session = HibernateUtils.openSession();
		Transaction tx = session.beginTransaction();
		//----------------------------------------------------
		String hql = " from Customer c right join c.linkMens ";
		
		Query query = session.createQuery(hql);
		
		List<Object[]> list = query.list();
		
		for(Object[] arr : list){
			System.out.println(Arrays.toString(arr));
		}
		//----------------------------------------------------
		tx.commit();
		session.close();
		
	}