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;
        }
    }
}