package com.REP.DAO;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import com.REP.DAO.base.BaseEmployeeDAO;
import com.REP.bean.Employee;


public class EmployeeDAO extends BaseEmployeeDAO implements com.REP.DAO.iface.IEmployeeDAO {

	public EmployeeDAO () {}
	
	public EmployeeDAO (Session session) {
		super(session);
	}
    //查找員工
    public Employee findEmployee(String employeeName,String idCard){
        //定義查找字符串
        String hql = "from Employee as e where e.Name=:employeename and e.Idcard=:idcard";
        //執行查找
        Query query = getQuery(hql,getSession());
        query.setString("employeename",employeeName);
        query.setString("idcard",idCard);
        System.out.println("have come the dao1");
        List list = new ArrayList();
        list = query.list();
        if(list.isEmpty()) return null;
        return (Employee)list.iterator().next();
    }

}