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
| public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
HttpSession session = request.getSession();
conn(session);
PersonneForm formulaire = (PersonneForm) form;
Personne personne = new Personne(formulaire.getNom(), formulaire
.getPrenom(), formulaire.getDateNaissance(), formulaire
.getAdresse(), formulaire.getTelephone());
return mapping.findForward("success");
}
public void conn(HttpSession session) {
try {
Class.forName(pilote);
Connection connexion = DriverManager.getConnection(
"jdbc:mysql://localhost/personne", "root", "");
Statement instruction = connexion.createStatement();
String requete = "Select * from personne";
ResultSet resultSet;
resultSet = instruction.executeQuery(requete);
while (resultSet.next()) {
listdn.add(resultSet.getString("nom"));
System.out.println(resultSet.getString("nom"));
System.out.println(resultSet.getString("prenom"));
}
session.setAttribute("listdn",listdn);
instruction.close();
connexion.close();
} catch (Exception e) {
if (logger.isDebugEnabled()) {
logger.debug("echec pilote : " + e.toString());
}
}
} |
Partager