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
| public Client getClient(String nom) throws SQLException{
Cursor c = db.query(CLIENTS_TABLE, new String[]{
CLIENTS_NAME, CLIENTS_TELEPHONE_FIXE, CLIENTS_TELEPHONE_MOBILE,
CLIENTS_ADRESSE_NUMERO, CLIENTS_ADRESSE_VOIE, CLIENTS_ADRESSE_COMPLEMENT,
CLIENTS_ADRESSE_CP, CLIENTS_ADRESSE_VILLE, CLIENTS_MAIL},
CLIENTS_NAME +"='"+ nom+"'", null,null,null,null);
return transformcursorToClient(c);
}
private Client transformcursorToClient(Cursor c) {
if(c.getCount()==0)
return null;
Client client = new Client();
client.setNom_Entreprise(c.getString(0));
client.setTelephone_Fixe(c.getString(1));
client.setTelephone_Mobile(c.getString(2));
client.setAdresse_Numero(c.getString(3));
client.setAdresse_Voie(c.getString(4));
client.setAdresse_Complement(c.getString(5));
client.setAdresse_Cp(c.getString(6));
client.setAdresse_Ville(c.getString(7));
client.setMail(c.getString(8));
c.close();
return client;
} |
