学习日志——2019/08/23

Hibernate的查询的方式

Hibernate的查询方式：QBC检索

• QBC查询：Query By Criteria，条件查询。是一种更加面向对象化的查询的方式。

简单查询

@Test
	/**
	 * 简单查询
	 */
	public void demo01() {
		Session session = HibernateUtils.getCurrentSession();
		Transaction tx = session.beginTransaction();
		
		//获得riteria的对象
		Criteria criteria = session.createCriteria(Customer.class);
		List<Customer> list=criteria.list();
		
		for (Customer customer : list) {
			System.out.println(customer);
		}
		
		tx.commit();
	}

排序查询

@Test
	/**
	 * 排序查询
	 */
	public void demo02() {
		Session session = HibernateUtils.getCurrentSession();
		Transaction tx = session.beginTransaction();
		
		//获得riteria的对象
		Criteria criteria = session.createCriteria(Customer.class);
		//设置排序
//		criteria.addOrder(Order.asc("cust_id"));//升序
		criteria.addOrder(Order.desc("cust_id"));
		List<Customer> list=criteria.list();
		
		for (Customer customer : list) {
			System.out.println(customer);
		}
		
		tx.commit();
	}
	

分页查询

@Test
	/**
	 * 分页查询
	 */
	public void demo03() {
		Session session = HibernateUtils.getCurrentSession();
		Transaction tx = session.beginTransaction();
		
		//分页查询
		Criteria criteria = session.createCriteria(LinkMan.class);
		criteria.setFirstResult(10);
		criteria.setMaxResults(10);
		List<LinkMan> list = criteria.list();
		for (LinkMan linkMan : list) {
			System.out.println(linkMan);
		}
		
		tx.commit();
	}

条件查询

@Test
	/**
	 * 条件查询
	 */
	public void demo04() {
		Session session = HibernateUtils.getCurrentSession();
		Transaction tx = session.beginTransaction();
		//条件查询
		Criteria criteria = session.createCriteria(Customer.class);
		//设置条件：
		/**
		 *  = 	eq
		 *  > 	gt
		 *  >=	ge
		 *  <	lt
		 *  <=	le
		 *  <>	ne	不等于
		 * 	like
		 * 	in 
		 * 	and
		 * 	or
		 */	
		 
		criteria.add(Restrictions.eq("cust_source", "广告"));
		criteria.add(Restrictions.like("cust_name", "陈%"));
		List<Customer> list = criteria.list();
		
		for (Customer customer : list) {
			System.out.println(customer);
		}
		
		tx.commit();
	}

统计查询

@Test
	/**
	 * 统计查询
	 */
	public void demo05() {
		Session session = HibernateUtils.getCurrentSession();
		Transaction tx = session.beginTransaction();
		
		Criteria criteria = session.createCriteria(Customer.class);
		/**
		 * add		:普通条件
		 * addOrder	:排序
		 * setProjection:聚合函数和group by having 
		 */
		criteria.setProjection(Projections.rowCount());
		Long num = (Long)criteria.uniqueResult();
		System.out.println(num);
		
		tx.commit();
	}

离线条件查询（SSH）—DetachedCriteria

@Test
	/**
	 * 离线条件查询
	 */
	public void demo06() {
		DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Customer.class);
		detachedCriteria.add(Restrictions.ilike("cust_name", "陈%"));
		
		Session session=HibernateUtils.getCurrentSession();
		Transaction tx = session.beginTransaction();
		
		Criteria criteria = detachedCriteria.getExecutableCriteria(session);
		List<Customer> list = criteria.list();
		
		for (Customer customer : list) {
			System.out.println(customer);
		}
		
		tx.commit();
	}
	

Hibernate的查询方式：SQL检索

SQL查询

• SQL查询：通过使用sql语句进行查询

	@Test 
	public void demo01() {
		Session session = HibernateUtils.getCurrentSession();
		Transaction tx = session.beginTransaction();
//		
//		SQLQuery sqlQuery = session.createSQLQuery("select * from cst_customer ");
//		List<Object[]> list = sqlQuery.list();
//		for (Object[] objects : list) {
//			System.out.println(objects);
//		}
		SQLQuery sqlQuery = session.createSQLQuery("select * from cst_customer");
		sqlQuery.addEntity(Customer.class);
		List<Customer> list = sqlQuery.list();
		for (Customer customer : list) {
			System.out.println(customer);
		}
		
		tx.commit();
	}