1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146
| /************************************************************
************** Classe Client *****************************
************************************************************/
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.util.*;
import java.util.Date;
public class Client implements java.io.Serializable {
/************************************************************
************** Attributs *********************************
************************************************************/
private String nom;
private String motDePasse;
private String prenom;
private String age;
private String pays;
private String adresse;
private String codePostal;
private String ville;
private String mail;
private String sexe;
private String nomVar[]={"mail","nom", "prenom", "age" , "pays","adresse","codePostal","ville","sexe"};
/************************************************************
************** constructeurs*******************************
************************************************************/
public Client(String Parametres){
String[] ParamUtilisable = Parametres.split(",");
this.mail=ParamUtilisable[0];this.nom=ParamUtilisable[1];this.prenom=ParamUtilisable[2];this.age=ParamUtilisable[3];this.sexe=ParamUtilisable[4];this.pays=ParamUtilisable[5];this.ville=ParamUtilisable[6];this.adresse=ParamUtilisable[7];this.codePostal=ParamUtilisable[8];this.motDePasse=ParamUtilisable[9];
}
public Client(String mail,String nom,String prenom,String age,String sexe,String pays,String adresse,String ville,String codePostal,String motDPasse)
{this.motDePasse=motDePasse;this.nom=nom;this.prenom=prenom;this.age=age;this.adresse=adresse;this.codePostal=codePostal;this.ville=ville;this.mail=mail;this.sexe=sexe;this.pays=pays;}
/************************************************************
************** getter/setter*******************************
************************************************************/
public String getNom(){return this.nom;}
public void setNom(String a){ this.nom=a;}
public String getSex(){return this.sexe;}
public void setSexe(String a){this.sexe=a;}
public String getMotDePasse(){return this.motDePasse;}
public void setMotDePasse(String a){ this.motDePasse=a;}
public String getPrenom(){return this.prenom;}
public void setPrenom(String a){this.prenom=a;}
public String getAge(){return this.age;}
public void setAge(String a){ this.age=a;}
public String getAdresse(){return this.adresse;}
public void setAdresse(String a){this.adresse=a;}
public String getPays(){return this.pays;}
public void setPays(String pays){this.pays=pays;}
public String getCP(){return this.codePostal;}
public void setCP(String b){this.codePostal=b;}
public String getVille(){return this.ville;}
public void setVille(String a){this.ville=a;}
public String getMail(){return this.mail;}
public void setMail(String newMail){this.mail=newMail;}
/************************************************************
*************** METHODES *********************************
************************************************************/
public void insertBase(Connection cnx) throws SQLException{
java.sql.Statement req= cnx.createStatement();
String requete="INSERT INTO Client VALUES('";
StringBuilder sb = new StringBuilder(requete);
sb.append(this.mail+"','");sb.append(this.nom+"','");sb.append(this.prenom+"','");sb.append(this.age+"','");sb.append(this.sexe+"','");sb.append(this.pays+"','");sb.append(this.ville+"','");sb.append(this.adresse+"','");sb.append(this.codePostal+"','");sb.append(this.motDePasse+"'\"");
req.executeUpdate(sb.toString());
req.close();}
public void updateBase(Connection cnx)throws SQLException{
java.sql.Statement req= cnx.createStatement();
req.executeUpdate("UPDATE Client SET Nom='this.nom' Prenom='this.prenom' Age='this.age' Sexe='this.sexe' Pays='this.pays' Ville='this.ville' Adresse='this.adresse' CP='this.codePostal' WHERE Mail=this.mail");
req.close();}
/**************************************************************************
Connecte une client , renvoie true si la connexion est établie false sinon
****************************************************************************/
public boolean Connect(Connection cnx,String ValueMail,String motpasse)throws SQLException{
java.sql.Statement req= cnx.createStatement();
ResultSet rs=req.executeQuery("SELECT password FROM Client WHERE mail='ValueMail'");
if( (rs.getString("password")).equals(motpasse)){
req.close();
return true;
}else{req.close();
return false;}
}
public void courantUpdate(){
}
/**************************************************************************
Methode à verifier ou trouver une astuce
* @throws SQLException
**************************************************************************/
public void LoadParameter(Connection cnx,String ValueMail) throws SQLException{
java.sql.Statement req= cnx.createStatement();
ResultSet rs =req.executeQuery("SELECT * FROM client WHERE 'mail=ValueMail'");
setMail(rs.getString("mail"));
setNom(rs.getString("nom"));
setPrenom(rs.getString("prenom"));
setAge(rs.getString("age"));
setSexe(rs.getString("sexe"));
setPays(rs.getString("Pays"));
setVille(rs.getString("ville"));
setAdresse(rs.getString("adresse"));
setCP(rs.getString("codePostal"));
req.close();
/*String[] rs = new String[8];
Personne instanceClient = new Client();
for(int i=0; i<nomVar.length; i++)
{
BeanUtils.setProperty(instance,nomVar[i],executeQuery("SELECT "+nomVar[i]"FROM Client WHERE mail.equals('ValueMail')");
}*/
}
public boolean ExistBase(Connection cnx,String ValueMail)throws SQLException{
java.sql.Statement req= cnx.createStatement();
ResultSet rs=req.executeQuery("SELECT mail FROM Client WHERE mail='ValueMail'");
if( (rs.getString("mail")).equals(ValueMail)){
req.close();
return true;
}else{req.close();
return false;}
}
} |
Partager