package com.aptech.module.dao.system;

import java.sql.ResultSet;
import java.util.List;

import com.aptech.business.dm.BaseDM;
import com.aptech.business.dm.UserDM;
import com.aptech.business.exception.FatalException;
import com.aptech.module.dao.BaseDAO;
import com.aptech.module.manager.DBManager;

/**
 * UserDAO
 * @author Justin Liu  E-mail: liu.jin_accp@163.com
 * @version 創建時間：2007-1-6 上午02:33:01
 * 類說明
 */
public class UserDAO extends BaseDAO {

	@Override
	public List findAll() {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public int remove(BaseDM baseDM) {
		// TODO Auto-generated method stub
		return 0;
	}

	@Override
	public int save(BaseDM baseDM) {
		// TODO Auto-generated method stub
		return 0;
	}

	@Override
	public int update(BaseDM baseDM) {
		// TODO Auto-generated method stub
		return 0;
	}
	/**
	 * 驗證登陸是否成功
	 * @param baseDM
	 * @return
	 * @throws FatalException
	 */
	public boolean findByLogin(BaseDM baseDM) throws FatalException{
		try{
			UserDM dm = (UserDM)baseDM;
			DBManager db = new DBManager();
			String sql = "select * from sys_user where user_no = '" + 
				dm.getUserno() + "' and passwrd = '"+dm.getUserpwd()+"'";
			ResultSet rs = db.queryData(sql);
			if(rs!=null && rs.next()){
				db.closeConn();
				return true;
			}
			db.closeConn();
			return false;
		}catch(Exception e){
			throw new FatalException(e);
		}
	}

}