Hibernate（六）

最新推荐文章于 2024-12-03 10:49:25 发布

原创最新推荐文章于 2024-12-03 10:49:25 发布 · 329 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

Hibernate 专栏收录该内容

10 篇文章

订阅专栏

Hibernate的其他API:

Query:

查询多个对象，通过获得sessioin.createQuery()，接收一个HQL语句，然后调用Query的list()方法执行查询。

HQL：Hibernate Query Language缩写，与SQL语法极其类似，面向对象的查询语言。

/**
* Query查询所有
*/
@Test
public void demo1() {

	Session session = HibernateUtils.getCurrentSession();
	Transaction ts = session.beginTransaction();
	
	String hql="from Customer";
	Query query = session.createQuery(hql);
	List<Customer> list = query.list();
	for (Customer customer : list) {
		System.out.println(customer);
	}		
	ts.commit();
}
	
/**
 * 	Query条件查询
 */
@Test
public void demo2() {
	
	Session session = HibernateUtils.getCurrentSession();
	Transaction ts = session.beginTransaction();
		
	String hql="from Customer where cust_id=?";
	Query query = session.createQuery(hql);
	query.setParameter(0, 8l);
	List<Customer> list = query.list();
	for (Customer customer : list) {
		System.out.println(customer);
	}		
	ts.commit();
}
	
/**
 * 	Query分页查询
 */
@Test
public void demo3() {
		
	Session session = HibernateUtils.getCurrentSession();
	Transaction ts = session.beginTransaction();
		
	String hql="from Customer";
	Query query = session.createQuery(hql);
	//设置获取第一个记录的位置，即从第几条记录开始查询，默认从0开始计算
	query.setFirstResult(0);
	//设置结果集的最大记录数，与setFirstResult()方法结合使用，用于限制结果集的范围，以实现分页功能。
	query.setMaxResults(3);
	List<Customer> list = query.list();
	for (Customer customer : list) {
		System.out.println(customer);
	}		
	ts.commit();
}

Criteria:

又称为QBC（Query By Criteria）查询，完全面向对象。

/**
 * Criteria查询所有
 */
@Test
public void demo4() {
		
	Session session = HibernateUtils.getCurrentSession();
	Transaction ts = session.beginTransaction();
	
	Criteria criteria = session.createCriteria(Customer.class);
	List<Customer> list = criteria.list();
	for (Customer customer : list) {
		System.out.println(customer);
	}
	ts.commit();
}
	
/**
 * Criteria条件查询
 */
@Test
public void demo5() {
		
	Session session = HibernateUtils.getCurrentSession();
	Transaction ts = session.beginTransaction();
		
	Criteria criteria = session.createCriteria(Customer.class);
	criteria.add(Restrictions.like("cust_id", 8l));
	List<Customer> list = criteria.list();
	for (Customer customer : list) {
		System.out.println(customer);
	}
	ts.commit();
}
	
/**
 * Criteria分页查询
 */
@Test
public void demo6() {
		
	Session session = HibernateUtils.getCurrentSession();
	Transaction ts = session.beginTransaction();
	
	Criteria criteria = session.createCriteria(Customer.class);
	criteria.setFirstResult(3);
	criteria.setMaxResults(3);
	List<Customer> list = criteria.list();
	for (Customer customer : list) {
		System.out.println(customer);
	}
	ts.commit();
}