Hibernate多条件查询，HQL拼接

最新推荐文章于 2022-03-10 16:39:21 发布

原创最新推荐文章于 2022-03-10 16:39:21 发布 · 2.1k 阅读

4 ·

CC 4.0 BY-SA版权

Hibernate 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一个使用Hibernate进行复杂条件查询的例子，通过拼接HQL语句实现学生信息的灵活筛选，涉及条件包括学号、姓名等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

今天学习Hibernate，要做一个或多个条件的查询的时候，需要用到判断进行HQL语句的拼接！

dao：

	@Override
	public PageBean<Student> findByAllMsg(Student student, int currentPage,
			int pageSize) {
		int begin = (currentPage - 1) * pageSize;

		String hql = "from Student where 1=1";
		if (student.getStuid() != -1) {
			hql = hql + " AND stuid = " + student.getStuid();
		}
		if (student.getName() != "") {
			hql = hql + " AND name = " + student.getName();
		}
		if (student.getBirthday() != null) {
			hql = hql + " AND birthday = " + student.getBirthday();
		}
		if (student.getAge() != -1) {
			hql = hql + " AND age = " + student.getAge();
		}
		if (student.getSex() != "") {
			hql = hql + " AND sex = '" + student.getSex() + "'";
		}
		if (student.getGrade() != "") {
			hql = hql + " AND grade = '" + student.getGrade() + "'";
		}
		
		Query query = sessionFactory.getCurrentSession().createQuery(hql);
		query.setFirstResult(begin);
		query.setMaxResults(pageSize);
		List<Student> pageList = query.list();
		return fenYe.base(pageSize, currentPage, hql, pageList);
	}

entity：

public class Student {

	private int stuid;
	private String name;
	private Date birthday;
	private int age;
	private String sex;
	private String grade;

｝