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();
%> |
Partager