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;}
}
} |
