package com.accp.dao;

import java.util.Iterator;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;

import com.accp.entity.Emp;
import com.accp.hib.HibernateSessionFactory;
import com.accp.util.TransTool;

public class EmpDao {
	//ename job HIREDATE
	//SAL
    public List getEmpDyna(Emp emp,String endDate, int curPage){
    	List list = null;
    	Session se = HibernateSessionFactory.getSession();
    	Criteria cri =  se.createCriteria(Emp.class);
    	if(emp.getEname() != null && !"".equals(emp.getEname())){
    	  cri.add(Restrictions.like("ename", "%"+emp.getEname()+"%"));
    	}
    	if(emp.getJob() != null && !"".equals(emp.getJob())){
    	  cri.add(Restrictions.like("job", "%"+emp.getJob()+"%"));
    	}
    	if(emp.getHiredate() != null){
    	  cri.add(Restrictions.gt("hiredate", emp.getHiredate()));
    	}
    	if(endDate != null && !"".equals(endDate)){
    	  cri.add(Restrictions.le("hiredate", TransTool.addOneDate(endDate)));
    	}
    	if(emp.getSal() != null){
    	  cri.add(Restrictions.ge("sal", emp.getSal()));
    	}
    	cri.setFirstResult(5*(curPage - 1));
    	cri.setMaxResults(5);
        cri.addOrder(Order.asc("empno"));
        
        list = cri.list();
          
    	se.close();
		return list;
   
    }
    
    public static void main(String[] args) {
    	EmpDao empDao = new EmpDao();
    	List list  = empDao.getEmpDyna(new Emp(), null,3);
    
    	Iterator iter = list.iterator();
    	
    	while (iter.hasNext()) {
			Emp elem = (Emp) iter.next();
			System.out.println(elem.getEmpno()+","+elem.getEname());
		}
    	
	}
}