package foo;
import java.util.*;
import java.sql.*;
public class FormBean {
private String email;
private String userName;
private String password1;
private String password2;
private String notify;
private Hashtable errors;
public boolean insertData(String host, String dbname, String user, String password){
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
java.sql.Connection ocon = java.sql.DriverManager.getConnection(
"jdbc:mysql://"+host+"/"+dbname+"?user="+user+"&password="+password+"");
Statement stmtt = ocon.createStatement();
String query = "insert into users (email,username,notify,password) values ('"+email+"','"+userName+"','"+notify+"','"+password1+"');";
stmtt.executeUpdate(query);
return true;
} catch(Exception e){
//System.out.println("Connection ratée: "+e);
errors.put("mysql","Connection ratée: "+e);
return false;
}
}
public boolean validate() {
// TODO
// Inserer les données dans la table users, base de donnée testdb de MySQL
// Verifier qu'il n'existe pas une entrée pour l'username en question
//
boolean allOk=true;
if (email.equals("") || (email.indexOf('@') == -1)) {
errors.put("email","Please enter a valid email address");
email="";
allOk=false;
}
if (userName.equals("")) {
errors.put("userName","Please enter a username");
userName="";
allOk=false;
}
if (password1.equals("") ) {
errors.put("password1","Please enter a valid password");
password1="";
allOk=false;
}
if (!password1.equals("") && (password2.equals("") ||
!password1.equals(password2))) {
errors.put("password2","Please confirm your password");
password2="";
allOk=false;
}
return allOk;
}
public String getErrorMsg(String s) {
String errorMsg =(String)errors.get(s.trim());
return (errorMsg == null) ? "":errorMsg;
}
public FormBean() {
email="";
userName="";
password1="";
password2="";
notify="";
errors = new Hashtable();
}
public String getEmail() {
return email;
}
public String getUserName() {
return userName;
}
public String getPassword1() {
return password1;
}
public String getPassword2() {
return password2;
}
public String getNotify() {
return notify;
}
public String isRbSelected(String s) {
return (notify.equals(s))? "checked" : "";
}
public void setEmail(String eml) {
email=eml;
}
public void setUserName(String u) {
userName=u;
}
public void setPassword1(String p1) {
password1=p1;
}
public void setPassword2(String p2) {
password2=p2;
}
public void setErrors(String key, String msg) {
errors.put(key,msg);
}
public void setNotify(String n) {
notify=n;
}
}