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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
| <html>
<head>
<title>Verification de login</title>
</head>
<body>
<script language="JavaScript">
function ValidForm(form){
if (form.login.value.length == 0)
{
alert("Veuillez entrer le login !");
form.login.focus();
return false;
}
if (form.password.value.length == 0)
{
alert("Veuillez entrer le mot de passe !");
form.password.focus();
return false;
}
return true;
}
</script>
<%// Connection au serveur%>
<%@ page language="java" session="true" import="java.sql.*" %>
<jsp:include page="images/style_login.html"> </jsp:include>
<%@ include file="DbBean.jsp"%>
<%
ResultSet rs = null;
String msg = null;
String vlogin = null;
String vpwd = null;
String msg_retour = null;
if ((request.getParameter("login") != null) && (request.getParameter("password") != null)){
vlogin= request.getParameter("login");
vpwd= request.getParameter("password");
msg_retour = request.getParameter("msg_retour");
// Déclaration de la requête
String sql = "SELECT li_login,li_password FROM ress_hum WHERE li_login = '"+vlogin+"' AND li_password = '"+vpwd+ "';";
// Connection à la base de données
try{
db.connect();
}catch (ClassNotFoundException e) {
throw new ServletException("Pilotes de la base non disponibles", e);
}catch (SQLException e) {
throw new ServletException("URL erronée", e);
}
// Execution de la requête
try{
rs = db.execSQL(sql);
} catch (SQLException e) {
throw new ServletException("Requête erronée", e);
}
}
%>
<FORM METHOD=POST ACTION="indexs.jsp" NAME="form" onSubmit="return ValidForm(this);">
<TABLE BORDER="0" >
<TR><TD class="t16bb">Login : </TD><TD><INPUT NAME="login" TYPE=TEXT <%if (vlogin != null) {%> VALUE="<%=vlogin%>" <%}%>></TD></TR>
<TR><TD>Mot de passe : </TD><TD><INPUT NAME="password" TYPE="password" ></TD></TR>
<%
//Initialiser le variable msg
msg = "Autorisation refusée";
if ((vlogin != null) && (vpwd != null)){
// Tester le resultat de la requête
try{
if (rs.next()) {
// Verification de login et mot de passe
if ((vlogin.trim().equals(rs.getString(1).trim())) && (vpwd.trim().equals(rs.getString(2).trim()))){
session.setAttribute( "nom", vlogin );
msg = "";
%><jsp:forward page="Connection.jsp" /><%
}
}
rs.close();
db.close();
}catch (SQLException e) {
throw new ServletException("Erreur de base de données", e);
}
}
%>
<INPUT TYPE=hidden NAME="msg_retour" VALUE="<%=msg%>">
<TR><TD><INPUT TYPE=SUBMIT VALUE="submit" class="button_submit"></TD><TD> </TD></TR>
</TABLE>
<%if (msg_retour != null) {%>
<BR><BR><H3><%=msg_retour%></H3>
<%}%>
</FORM>
<jsp:include page="images/style_foot.html"> </jsp:include> |
