1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, ClassNotFoundException, SQLException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
String cLogin = request.getParameter("Login");
String cPassword = request.getParameter("Password");
String cnx="Select * from Utilisateur_abonne where identifiant_abonnement ='"+cLogin +"'"+ " and mot_de_passe='"+cPassword+"'";
try {
Class.forName("org.apache.derby.jdbc.ClientDriver");
Connection ma_connexion= DriverManager.getConnection("jdbc:derby//localhost:3306/Baseparking");
Statement mon_statement=(Statement) ma_connexion.createStatement();
ResultSet mon_resultat = mon_statement.executeQuery(cnx);
if (mon_resultat.next()){
System.out.println("Vous êtes connectés");
}
} catch(Exception ex){
System.out.println("Ereur "+ex);
}
} |
Partager