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
|
@WebMethod(operationName = "Affichage")
public ArrayList AffichageParametres(@WebParam(name = "login")
String login) {
ArrayList log = new ArrayList();
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con =
(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/bdhexabyte",
"root", "");
PreparedStatement st =
con.prepareStatement
("SELECT C.nom, C.zip, C.ville, C.cin, C.email, Cat.nom, Ld.debit, RS.nom "+
" FROM com_srv5 CS, client C, hde_light_debits Ld, categories_hde Cat,ref_srv_hde RS " +
"WHERE CS.id_client = C.id"+
"AND CS.id_categories_hde = Cat.id"+
"AND CS.id_adsl_light_debits = Ld.id"+
" AND Cat.id_ref_srv_hde = RS.id "+
"AND CS.login like ? ");
st.setString(1, login);
ResultSet rs = st.executeQuery() ;
while (rs.next())
{ log.add(rs.getString("C.nom"));
log.add(rs.getInt("C.zip"));
log.add(rs.getString("C.ville"));
log.add(rs.getInt("C.cin"));
log.add(rs.getString("Cat.nom"));
log.add(rs.getString("Ld.debit"));
log.add(rs.getString("RS.nom"));
}
}
catch(Exception e)
{
e.printStackTrace();
}
return log;
}
} |
Partager