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.BaseManagerDAO;
import com.REP.bean.Manager;


public class ManagerDAO extends BaseManagerDAO implements com.REP.DAO.iface.IManagerDAO {

	public ManagerDAO () {}
	
	public ManagerDAO (Session session) {
		super(session);
	}
    //查找用戶是否存在
    public Manager findUser(String username,String password){
         List list = new ArrayList();
         Manager manager = new Manager();
         String hql = "from Manager" 
                + " as u where u.LoginName=:username and u.Password=:password";
        Query query = getQuery(hql, getSession());
        query.setString("username",username);
        query.setString("password",password);
        list = query.list();
        if(!list.isEmpty()){
             manager =(Manager)list.iterator().next();
             closeCurrentSession();
             return manager;
        }
        return null;
   }

}