package coreservlets.beans;

import coreservlets.*;
import java.sql.*;  
import java.io.*;  

public class DbBean { 

  String dbURL = "jdbc:mysql://ocelot.aul.fiu.edu:3306/barton";
  private Connection dbCon; 

  private ResultSet rS    = null;
  private  String f_name  = "";
  private  String l_name  = "";
  private  String e_mail  = "";
  private  String p_word  = "";
  private  String cp_word = "";
  private  String register= "";
  private  String submit  = "";
  private  String login   = "";
  private  String detas   = "";

  public DbBean(){ super(); } 

  public boolean connect() throws ClassNotFoundException,SQLException
  { Class.forName("com.mysql.jdbc.Driver");
    dbCon = DriverManager.getConnection(dbURL,"barton","db2008msql");
    return true; 
  } 

  public void close() throws SQLException{ dbCon.close(); } 

  public ResultSet execSQL(String sql) throws SQLException
  { Statement s = dbCon.createStatement(); 
    ResultSet r = s.executeQuery(sql); 
    return (r == null) ? null : r; 
  } 

  public int updateSQL(String sql) throws SQLException
  { Statement s = dbCon.createStatement();
    int r = s.executeUpdate(sql);
    return (r == 0) ? 0 : r; 
  } 

  public void    setF_name(String f_name)     { this.f_name = f_name;     }
  public String  getF_name()                  { return f_name;            }
 
  public void    setL_name(String l_name)     { this.l_name = l_name;     }
  public String  getL_name()                  { return l_name;            }

  public void    setE_mail(String e_mail)     { this.e_mail = e_mail;     }
  public String  getE_mail()                  { return e_mail;            }

  public void    setP_word(String p_word)     { this.p_word = p_word;     }
  public String  getP_word()                  { return p_word;            }
 
  public void    setCp_word(String cp_word)   { this.cp_word = cp_word;   }
  public String  getCp_word()                 { return cp_word;           }

  public void    setRegister(String register) { this.register = register; }
  public String  getRegister()                { return register;          }
  public Boolean testRegister()           { return ! register.equals(""); }

  public void    setSubmit(String submit)     { this.submit = submit;     }
  public String  getSubmit()                  { return submit;            }
  public Boolean testSubmit()             { return ! submit.equals("");   }

  public void    setLogin(String login)       { this.login = login;       }
  public String  getLogin()                   { return login;             }
  public Boolean testLogin()              { return ! login.equals("");    }

  public void    setDetas(String detas)       { this.detas = detas;       }
  public String  getDetas()                   { return detas;             }

  public Boolean testNone()     
      { return  submit.equals("")&&register.equals("")&&login.equals(""); }

}