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;
}
}
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;
}
}