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
| <%@ page language="java" import="java.sql.*" %>
<%@ include file="Connections/maBase.jsp" %>
<%
String Auth__MMColParam = "1";
if (request.getParameter("id") !=null) {Auth__MMColParam = (String)request.getParameter("id");}
%>
<%
Driver DriverAuth = (Driver)Class.forName(MM_maBase_DRIVER).newInstance();
Connection ConnAuth = DriverManager.getConnection(MM_maBase_STRING,MM_maBase_USERNAME,MM_maBase_PASSWORD);
PreparedStatement StatementAuth = ConnAuth.prepareStatement("SELECT * FROM ticket WHERE ticket = " + Auth__MMColParam + "");
ResultSet Auth = StatementAuth.executeQuery();
boolean Auth_isEmpty = !Auth.next();
boolean Auth_hasData = !Auth_isEmpty;
Object Auth_data;
int Auth_numRows = 0;
%><head>
<title>Mediatheque</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<html>
<p><br>
<%=(Auth__MMColParam)%></p>
<% if (!Auth_isEmpty ) { %>
<%@ page info="Default Start Page for all Web browsers" import="java.io.*,java.lang.*,java.util.*" errorPage="Error.jsp" %>
<%
Cookie cookie = new Cookie("monAppli.CookieChecker", "sessionCookie");
cookie.setMaxAge(-1);
response.addCookie(cookie);
%>
<%@ include file="DetectBrowser.jsp" %>
<%//=(sURL)%>
<%
//response.sendRedirect(sURL);
request.getRequestDispatcher(sURL).forward(request, response);
%>
<% } /* end !Auth_isEmpty */ %>
<% if (Auth_isEmpty ) { %>
<p>Accueil - Pas d'Authentification !!</p>
<% } /* end Auth_isEmpty */ %>
</html>
<%
Auth.close();
StatementAuth.close();
ConnAuth.close();
%> |
