package pethospitalsystem;

import java.sql.*;

/**
 * <p>Title: PetHospital</p>
 *
 * <p>Description: 寵物醫院系統</p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: T19</p>
 *
 * @author 劉洋
 * @version 1.0
 */
public class LoginBean {

    Connection con;
    Statement stmt;
    ResultSet rs;
    SQLBean sqlb=new SQLBean();
    UserInfoBean uib=new UserInfoBean();

    public boolean Login(){
        try {
            if(sqlb.getCon()!=null){
                con=sqlb.getCon();
                //通過用戶名查找數據.
                String strSql="select * from UserInfo where UserName='"+uib.getUserName()+"'";
                String pwd="";
                stmt=con.createStatement();
                rs=stmt.executeQuery(strSql);
                if(rs.next()){
                    //如果該用戶名存在，則將密碼取出來進行下一步判斷.
                    pwd=rs.getString(2);
                    if(pwd.equals(uib.getUPassword())){
                        //密碼也正確就直接返回true.
                        return true;
                    }else{
                        return false;
                    }
                }else{
                    return false;
                }
            }else{
                return false;
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
            return false;
        }
    }

    public LoginBean() {
    }
}