bonjour
j'ai le mem problem que vous
quand j'execute mon application voila l'erreur qui s'affiche
type Rapport d'état
message /exemplecrm/Cnx
description La ressource demandée (/exemplecrm/Cnx) n'est pas disponible.
voilà le code que j'execute:
l'interface en jsp:
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Authentification</title>
</head>
<body><center>
<form action="Cnx" method="post">
<table>
<tr>
<td width="141">Login :</td>
<td width="156"><input type="text" name="log"></td>
</tr>
<tr>
<td>mot de passe :</td>
<td><input type="password" name="pas"></td>
</tr>
<tr>
<td colspan="2"><center><input type="submit" name="ok" value="Connecter"></center></td>
</tr>
</table>
</form></center>
</body>
</html>
servlet:
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
@SuppressWarnings("serial")
public class Cnx extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
public Cnx() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request,response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
try{
String rep=null;
String log=(String) request.getAttribute("log");
String pas=(String) request.getAttribute("pas");
Connection cnx=null;
Connexion.ChargerPilote();
cnx=DriverManager.getConnection(Connexion.Connection_String);
Statement st=cnx.createStatement();
ResultSet rs=st.executeQuery("select password from authentification where login = " + log);
while(rs.next()){
rep=rs.getString("password");
}
if(rep.equals(pas))response.sendRedirect("Acceuil.jsp");
else response.sendRedirect("Login.jsp");
}catch(Exception ex){
ex.printStackTrace();
}
}
}
alors qui peux nous aidez ;)
