| 12
 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