Hibernate HQL like

最新推荐文章于 2023-05-22 09:21:59 发布

w2222288

最新推荐文章于 2023-05-22 09:21:59 发布

阅读量483

点赞数

分类专栏： hibernate

hibernate 专栏收录该内容

21 篇文章

订阅专栏

本文介绍了一个基于Hibernate的员工查询模块实现细节。该模块能够根据不同条件（如员工编号、姓名或部门ID）进行灵活的员工信息检索。通过使用不同的HQL查询语句，并结合条件判断来动态生成查询语句，从而实现了高效且灵活的数据查询功能。

package com.lixing.hr.dao.impl;

import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;

import com.lixing.hr.dao.ReportDAO;
import com.lixing.hr.model.Emp;
import com.lixing.hr.util.HibernateUtils;

public class ReportDAOImpl implements ReportDAO {
    private SessionFactory sf = HibernateUtils.getSessionFactory();

    public List<Emp> query(String employNo, String employName, int deptId) {
        String employNoStr = "FROM Emp e WHERE e.employNo LIKE :employNo";
        String employNameStr = "FROM Emp e WHERE e.employName LIKE :employName";
        String employNoAndEmployName="FROM Emp e WHERE e.employNo LIKE :employNo OR e.employName LIKE :employName ";
        String defaultDeptStr="FROM Emp e";
        String deptIdStr = "FROM Emp e WHERE e.dept.id=:deptId";
        List<Emp> emps = null;

        Session session = sf.getCurrentSession();
        session.beginTransaction();
        if(employNo.trim().isEmpty() && ( !(employName.trim().isEmpty()) )){
            emps=(List<Emp>)session.createQuery(employNameStr).setParameter("employName","%"+employName+"%").list();
        }else if( (!employNo.trim().isEmpty()) && employName.trim().isEmpty() ){
            emps=(List<Emp>)session.createQuery(employNoStr).setParameter("employNo","%"+employNo+"%").list();
        }else if(!(employNo.trim().isEmpty()) || (!(employName.trim().isEmpty())) ){
            emps=(List<Emp>)session.createQuery(employNoAndEmployName).setParameter("employNo","%"+employNo+"%").setParameter("employName", "%"+employName+"%").list();
        }else if(deptId==0){
            emps=(List<Emp>)session.createQuery(defaultDeptStr).list();
        }else{
            emps=(List<Emp>)session.createQuery(deptIdStr).setParameter("deptId", deptId).list();
        }
        session.getTransaction().commit();
        return emps;
    }
}