<%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*"%> <%--Copyright (C) 2002 Tony Grant This file is part of lmstoolkit lmstoolkit is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version. lmstoolkit is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with lmstoolkit; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA--%> <%@ include file="Connections/library.jsp" %> <% // *** Restrict Access To Page: Grant or deny access to this page String MM_authorizedUsers="1"; String MM_authFailedURL="go_away.html"; boolean MM_grantAccess=false; if (session.getValue("MM_Username") != null && !session.getValue("MM_Username").equals("")) { if (false || (session.getValue("MM_UserAuthorization")=="") || (MM_authorizedUsers.indexOf((String)session.getValue("MM_UserAuthorization")) >=0)) { MM_grantAccess = true; } } if (!MM_grantAccess) { String MM_qsChar = "?"; if (MM_authFailedURL.indexOf("?") >= 0) MM_qsChar = "&"; String MM_referrer = request.getRequestURI(); if (request.getQueryString() != null) MM_referrer = MM_referrer + "?" + request.getQueryString(); MM_authFailedURL = MM_authFailedURL + MM_qsChar + "accessdenied=" + java.net.URLEncoder.encode(MM_referrer); response.sendRedirect(response.encodeRedirectURL(MM_authFailedURL)); return; } %> <% Driver Driversorti = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Connsorti = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementsorti = Connsorti.prepareStatement("SELECT count(*) FROM loan WHERE sorti = 't'"); ResultSet sorti = Statementsorti.executeQuery(); boolean sorti_isEmpty = !sorti.next(); boolean sorti_hasData = !sorti_isEmpty; Object sorti_data; int sorti_numRows = 0; %> <% Driver Driveren_retard = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Connen_retard = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementen_retard = Connen_retard.prepareStatement("SELECT loan.borrower_id, books.book_id, dateentree, name, first_name, tel, email, noinventaire, books.titre FROM loan,borrower, books WHERE loan.book_id = books.book_id AND loan.borrower_id = borrower.borrower_id AND current_date > dateretour AND sorti = 't'"); ResultSet en_retard = Statementen_retard.executeQuery(); boolean en_retard_isEmpty = !en_retard.next(); boolean en_retard_hasData = !en_retard_isEmpty; Object en_retard_data; int en_retard_numRows = 0; %> <% Driver Driverloan = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Connloan = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementloan = Connloan.prepareStatement("SELECT sorti, loan_id, borrower_id, loan.book_id, datesortie, dateentree, noinventaire FROM loan, books WHERE loan.book_id = books.book_id AND sorti = 't'"); ResultSet loan = Statementloan.executeQuery(); boolean loan_isEmpty = !loan.next(); boolean loan_hasData = !loan_isEmpty; Object loan_data; int loan_numRows = 0; %> <% Driver Drivercompte_retard = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Conncompte_retard = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementcompte_retard = Conncompte_retard.prepareStatement("SELECT count(*) FROM loan WHERE current_date > dateretour AND sorti = 't'"); ResultSet compte_retard = Statementcompte_retard.executeQuery(); boolean compte_retard_isEmpty = !compte_retard.next(); boolean compte_retard_hasData = !compte_retard_isEmpty; Object compte_retard_data; int compte_retard_numRows = 0; %> <% int Repeat1__numRows = -1; int Repeat1__index = 0; en_retard_numRows += Repeat1__numRows; %> <% String MM_paramName = ""; %> <% // *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters String MM_keepBoth,MM_keepURL="",MM_keepForm="",MM_keepNone=""; String[] MM_removeList = { "index", MM_paramName }; // create the MM_keepURL string if (request.getQueryString() != null) { MM_keepURL = '&' + request.getQueryString(); for (int i=0; i < MM_removeList.length && MM_removeList[i].length() != 0; i++) { int start = MM_keepURL.indexOf(MM_removeList[i]) - 1; if (start >= 0 && MM_keepURL.charAt(start) == '&' && MM_keepURL.charAt(start + MM_removeList[i].length() + 1) == '=') { int stop = MM_keepURL.indexOf('&', start + 1); if (stop == -1) stop = MM_keepURL.length(); MM_keepURL = MM_keepURL.substring(0,start) + MM_keepURL.substring(stop); } } } // add the Form variables to the MM_keepForm string if (request.getParameterNames().hasMoreElements()) { java.util.Enumeration items = request.getParameterNames(); while (items.hasMoreElements()) { String nextItem = (String)items.nextElement(); boolean found = false; for (int i=0; !found && i < MM_removeList.length; i++) { if (MM_removeList[i].equals(nextItem)) found = true; } if (!found && MM_keepURL.indexOf('&' + nextItem + '=') == -1) { MM_keepForm = MM_keepForm + '&' + nextItem + '=' + java.net.URLEncoder.encode(request.getParameter(nextItem)); } } } // create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL + MM_keepForm; if (MM_keepBoth.length() > 0) MM_keepBoth = MM_keepBoth.substring(1); if (MM_keepURL.length() > 0) MM_keepURL = MM_keepURL.substring(1); if (MM_keepForm.length() > 0) MM_keepForm = MM_keepForm.substring(1); %> Accès à la base
lmstoolkit

Documents:

 new document file

change/erase file

new loan
Documents on loan: <%=(((sorti_data = sorti.getObject("count"))==null || sorti.wasNull())?"":sorti_data)%> (returns )
Overdue documents: <%=(((compte_retard_data = compte_retard.getObject("count"))==null || compte_retard.wasNull())?"":compte_retard_data)%>
   

<% while ((en_retard_hasData)&&(Repeat1__numRows-- != 0)) { %> <% if (!en_retard_isEmpty ) { %> <% } /* end !en_retard_isEmpty */ %> <% Repeat1__index++; en_retard_hasData = en_retard.next(); } %>
<%=(((en_retard_data = en_retard.getObject("dateentree"))==null || en_retard.wasNull())?"":en_retard_data)%> <%=(((en_retard_data = en_retard.getObject("noinventaire"))==null || en_retard.wasNull())?"":en_retard_data)%> <%=(((en_retard_data = en_retard.getObject("titre"))==null || en_retard.wasNull())?"":en_retard_data)%> <%=(((en_retard_data = en_retard.getObject("first_name"))==null || en_retard.wasNull())?"":en_retard_data)%> <%=(((en_retard_data = en_retard.getObject("name"))==null || en_retard.wasNull())?"":en_retard_data)%> <%=(((en_retard_data = en_retard.getObject("telperso"))==null || en_retard.wasNull())?"":en_retard_data)%> <%=(((en_retard_data = en_retard.getObject("emailperso"))==null || en_retard.wasNull())?"":en_retard_data)%>
© Tony Grant/tgds.net 2002

 

  

<% sorti.close(); Connsorti.close(); %> <% en_retard.close(); Connen_retard.close(); %> <% loan.close(); Connloan.close(); %> <% compte_retard.close(); Conncompte_retard.close(); %>