package shop;
import java.sql.*;
public class regBean {
  String id="";
  String name="";
  String pwd="";
  String sex="";
  String mail="";
  String addr="";
  String call="";
  String intr="";
  String success="false";
  Connection con;
  Statement sql;
  ResultSet rs;
  public regBean() {
    try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }catch(ClassNotFoundException e){}
  }
  public void setId(String s){id=s;}
  public void setName(String s){name=s;}
  public void setPwd(String s){pwd=s;}
  public void setSex(String s){sex=s;}
  public void setMail(String s){mail=s;}
  public void setAddr(String s){addr=s;}
  public void setCall(String s){call=s;}
  public void setIntr(String s){intr=s;}
  public String getId(){return id;}
  public String getName(){return name;}
  public String getPwd(){return pwd;}
  public String getSex(){return sex;}
  public String getMail(){return mail;}
  public String getAddr(){return addr;}
  public String getCall(){return call;}
  public String getIntr(){return intr;}
  public String getSuccess(){
    if(id.equals("")){
        success="false";
        return success;
      }
    try{
      con=DriverManager.getConnection("jdbc:odbc:myshop","","");
      sql = con.createStatement();
      String condition="select * from user where id="+"'"+id+"'";
      rs=sql.executeQuery(condition);
      if(rs.next()){
        success="false";
        con.close();
        return success;
      }
      else{
        String insert="insert into user values (?,?,?,?,?,?,?,?);";
        PreparedStatement pstmt=con.prepareStatement(insert);
        pstmt.setString(1,id);
        pstmt.setString(2,name);
        pstmt.setString(3,pwd);
        pstmt.setString(4,sex);
        pstmt.setString(5,mail);
        pstmt.setString(6,addr);
        pstmt.setString(7,call);
        pstmt.setString(8,intr);
        pstmt.executeUpdate();
        pstmt.close();
        success="true";
        con.close();
        return success;
      }
    }catch(SQLException e){
      success="false";
      return success;
    }
  }

}