mon erreur est : javax.servlet.ServletException: java.sql.SQLException
bonjour,
je reçois cet erreur lors de mon exécution et je ne trouve toujours pas une solution
et voila le code source de la page d'index:
index.jsp:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
| <form method="post" action="response3.jsp">
<p><input type="hidden" name="rememberme" value="0" /></p>
<fieldset>
<p><label for="username_2" class="top">User:</label><br />
<input type="text" name="username_2" id="username_2" tabindex="1" class="field" onkeypress="return webLoginEnter(document.loginfrm.password);" value="" /></p>
<p><label for="password_2" class="top">Password:</label><br />
<input type="password" name="password_2" id="password_2" tabindex="2" class="field" onkeypress="return webLoginEnter(document.loginfrm.cmdweblogin);" value="" /></p>
<p><input type="checkbox" name="checkbox" id="checkbox_2" class="checkbox" tabindex="3" size="1" value="" onclick="webLoginCheckRemember()" /><label for="checkbox_1" class="right">Remember me</label></p>
<p><input type="submit" name="cmdweblogin" class="button" value="LOGIN" /></p>
<p><a href="#" onclick="webLoginShowForm(2);return false;" id="forgotpsswd_2">Password forgotten?</a></p>
</fieldset>
</form> |
et la page de réponse:
response3.jsp:
Code:
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
| <%--
Document : response3
Created on : 10 juin 2011, 12:25:00
Author : BiLLeL
--%>
<%@ page import ="java.sql.*" %>
<%@ page import ="javax.sql.*" %>
<jsp:useBean id="Etudiant" scope="request" class="etudiant.Etudiant"/>
<%
String id=request.getParameter("username_2");
session.putValue("username_2",id);
String pass=request.getParameter("password_2");
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mcd","root","*****");
Statement st= con.createStatement();
ResultSet rs=st.executeQuery("select * from admin where id='"+id+"'");
if(rs.next())
{
if(rs.getString(2).equals(pass))
{
rs.close();
request.getRequestDispatcher("index2.jsp").forward(request, response);
}
else
{
out.println("Invalid password try again");
}
}
rs.close();
ResultSet rsx=st.executeQuery("select * from etud where id_etud='"+id+"'");
Etudiant.setNom(rsx.getString(3));
if(rsx.next())
{
if(rsx.getString(2).equals(pass))
{
rsx.close();
request.getRequestDispatcher("etudiant.jsp").forward(request, response);
}
else
{
out.println("Invalid password try again");
}
}
rsx.close();
%> |
et la page etudiant
etudiant.jsp:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| <%@ page import ="java.sql.*" %>
<%@ page import ="javax.sql.*" %>
<jsp:useBean id="Etudiant" scope="request" class="etudiant.Etudiant"/>
<%
if (request.getParameter("username_2")!= null)
{
out.print("Bienvenue "+ Etudiant.getNom());
}
else
response.sendRedirect("index.jsp");
%> |
et la classe Etudiant:
Code:
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
| /*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package etudiant;
/**
*
* @author BiLLeL
*/
public class Etudiant {
private String nom,prenom;
public String getNom() {
return nom;
}
public String getPrenom() {
return prenom;
}
public void setNom(String n) {
this.nom=n;
}
/**
* Insert the method's description here.
* Creation date: (26/12/2005 00:25:38)
*/
public void setPrenom(String p) {
this.prenom=p;
}
} |
Merci de vos réponses :)
