package pethospitalsystem;

import java.sql.*;

//相對應用戶信息表的操作Bean.

public class UserInfoDaoBean {

    public UserInfoDaoBean() {
    }

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

    //判斷注冊的用戶名是否存在.
    public boolean validateusername(){
        try {
            if(sqlb.getCon()!=null){
                con=sqlb.getCon();
                String strSql="select * from UserInfo where UserName='"+uib.getUserName()+"'";
                stmt=con.createStatement();
                rs=stmt.executeQuery(strSql);
                if(rs.next()){
                    return true;
                }else{
                    return false;
                }
            }else{
                return false;
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
            return false;
        }
    }

    //插入注冊用戶信息到UserInfo表中.
    public boolean insertdata(){
        try {
            if(sqlb.getCon()!=null){
                con=sqlb.getCon();
                String strSql="Insert into UserInfo values('"+uib.getUserName()+"','"+uib.getUPassword()+
                              "','"+uib.getUPwdQuestion()+"','"+uib.getUPwdAnswer()+"','"+uib.getUTrueName()+
                              "','"+uib.getUGender()+"','"+uib.getUBirthday()+"','"+uib.getUIdType()+
                              "','"+uib.getUIdCard()+"','"+uib.getUEmail()+"')";
                stmt=con.createStatement();
                stmt.executeUpdate(strSql);
                return true;
            }else{
                return false;
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
            return false;
        }
    }

    //用戶登陸時的驗證.
    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;
    }
}

}