package pethospitalsystem;

import java.sql.*;

//相對(duì)應(yīng)用戶信息表的操作Bean.

public class UserInfoDaoBean {

    public UserInfoDaoBean() {
    }

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

    //插入注冊(cè)用戶信息到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()+"',Convert(varchar(10),datetime,'"+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;
        }
    }
}