Hibernate 教程（四）[HQL使用]

HQL插入数据

package query.HQL;

import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.query.Query;
import org.junit.jupiter.api.Test;

import util.SessionUtil;

/**
 * HQL插入数据
 * @author LiHan
 *
 */
public class HQLInsert {
	
	private Session session = SessionUtil.getSession();

	private Transaction transaction = session.beginTransaction();
	
	private String hql;
	
	/**
	 * 插入操作
	 * Hibernate 支持从对象查出值插入到其他表里的操作，类型必须匹配
	 * 
	 */
	@Test
	public void test01() {
		hql = "INSERT INTO Event (title, date) SELECT data1, data2 From Datas WHERE id = :id";
		Query<?> query = session.createQuery(hql);
		query.setParameter("id", 1);
		System.out.println(query.executeUpdate());
		transaction.commit();
	}
}

HQL删除数据

package query.HQL;

import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.query.Query;
import org.junit.jupiter.api.Test;

import util.SessionUtil;

/**
 * HQL删除数据
 * @author LiHan
 *
 */
public class HQLDelete {
	
	private Session session = SessionUtil.getSession();

	private Transaction transaction = session.beginTransaction();

	private String hql;
	
	@Test
	public void test00() {
		hql = "DELETE FROM Event WHERE id = :id";
		Query<?> query = session.createQuery(hql);
		query.setParameter("id", Long.valueOf(9));
		System.out.println(query.executeUpdate());
		transaction.commit();
	}
}

HQL修改数据

package query.HQL;

import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.query.Query;
import org.junit.jupiter.api.Test;

import util.SessionUtil;

/**
 * HQL修改数据
 * @author LiHan
 *
 */
public class HQLUpdate {
	
	private Session session = SessionUtil.getSession();

	private Transaction transaction = session.beginTransaction();

	private String hql;
	
	/**
	 * 修改操作
	 */
	@Test
	public void test07() {
		hql = "UPDATE Event SET title = :title  WHERE id = :id";
		Query<?> query = session.createQuery(hql);
		query.setParameter("title", "标题8");
		query.setParameter("id", 8l);
		System.out.println(query.executeUpdate());
		transaction.commit();
	}
}

HQL查询数据

package query.HQL;

import java.util.Arrays;
import java.util.List;

import org.hibernate.ScrollableResults;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.query.Query;
import org.junit.jupiter.api.Test;

import orm.entity.Event;
import util.SessionUtil;

/**
 * HQL 查询数据
 * @author LiHan
 *
 */
public class HQLQuery {
	
	private Session session = SessionUtil.getSession();

	private Transaction transaction = session.beginTransaction();

	private String hql;
	
	/**
	 * 查询所有数据
	 */
	@Test
	public void test00() {
		// form 后面是实体类名，不是表面，通过类对象来查询
		hql = "from Event";
		Query<Event> query = session.createQuery(hql, Event.class);
		System.out.println(query.list());
		transaction.commit();
	}
	
	/**
	 * 传参数查找
	 */
	@Test
	public void test01() {
		// 格式： ?1, ?2, ?3
		hql = "from Event where id = ?1 and title = ?2";
		Query<Event> query = session.createQuery(hql, Event.class);
		// 第几个参数， 参数值
		query.setParameter(1, Long.valueOf(1));
		query.setParameter(2, "标题一");
		System.out.println(query.list());
		transaction.commit();
	}
	
	/**
	 * 传参数查找
	 */
	@Test
	public void test02() {
		// 格式： :id, :name, :abc, :asdasudyu
		hql = "from Event where id = :id";
		Query<Event> query = session.createQuery(hql, Event.class);
		// 第几个参数， 参数值
		query.setParameter("id", Long.valueOf(1));
		System.out.println(query.list());
		transaction.commit();
	}
	
	/**
	 * 查找指定字段
	 */
	@Test
	public void test03() {
		// 实体类的属性名： id, title, date
		hql = "select title from Event";
		// 这个Query查找的就不是对象了，而是对象数组
		// 需要滚动结果集接收，不懂的查看一下官方文档，或者API, 类似于Result
		ScrollableResults scrollableResults = session.createQuery(hql).scroll();
		while (scrollableResults.next()) {
			Object[] row = scrollableResults.get();
			System.out.println(Arrays.toString(row));
		}
	}
	
	/**
	 * 分页查询
	 */
	@Test
	public void test04() {
		hql = "from Event";
		int first = 0; // 从第几行开始
		int size = 10; // 每页的大小
		Query<Event> query = session.createQuery(hql, Event.class);
		query.setFirstResult(first);
		query.setMaxResults(size);
		List<Event> events = query.list();
		for (int i = 0; i < events.size(); i++) {
			Event event = events.get(i);
			System.out.println(event);
		}
	}
	
	/**
	 * 聚集函数的使用
	 */
	@Test
	public void test06() {
		hql = "SELECT count(*) FROM Event";
		System.out.println(session.createQuery(hql).getSingleResult());
	}
}