<%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*"%> <%@ include file="Connections/library.jsp" %> <% // *** Edit Operations: declare variables // set the form action variable String MM_editAction = request.getRequestURI(); if (request.getQueryString() != null && request.getQueryString().length() > 0) { MM_editAction += "?" + request.getQueryString(); } // connection information String MM_editDriver = null, MM_editConnection = null, MM_editUserName = null, MM_editPassword = null; // redirect information String MM_editRedirectUrl = null; // query string to execute StringBuffer MM_editQuery = null; // boolean to abort record edit boolean MM_abortEdit = false; // table information String MM_editTable = null, MM_editColumn = null, MM_recordId = null; // form field information String[] MM_fields = null, MM_columns = null; %> <% // *** Update Record: set variables if (request.getParameter("MM_update") != null && request.getParameter("MM_recordId") != null) { MM_editDriver = MM_library_DRIVER; MM_editConnection = MM_library_STRING; MM_editUserName = MM_library_USERNAME; MM_editPassword = MM_library_PASSWORD; MM_editTable = "retour"; MM_editColumn = "document_id"; MM_recordId = "" + request.getParameter("MM_recordId") + ""; MM_editRedirectUrl = ""; String MM_fieldsStr = "sorti|value|dateentree|value"; String MM_columnsStr = "sorti|',none,''|dateentree|',none,NULL"; // create the MM_fields and MM_columns arrays java.util.StringTokenizer tokens = new java.util.StringTokenizer(MM_fieldsStr,"|"); MM_fields = new String[tokens.countTokens()]; for (int i=0; tokens.hasMoreTokens(); i++) MM_fields[i] = tokens.nextToken(); tokens = new java.util.StringTokenizer(MM_columnsStr,"|"); MM_columns = new String[tokens.countTokens()]; for (int i=0; tokens.hasMoreTokens(); i++) MM_columns[i] = tokens.nextToken(); // set the form values for (int i=0; i+1 < MM_fields.length; i+=2) { MM_fields[i+1] = ((request.getParameter(MM_fields[i])!=null)?(String)request.getParameter(MM_fields[i]):""); } // append the query string to the redirect URL if (MM_editRedirectUrl.length() != 0 && request.getQueryString() != null) { MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + request.getQueryString(); } } %> <% // *** Update Record: construct a sql update statement and execute it if (request.getParameter("MM_update") != null && request.getParameter("MM_recordId") != null) { // create the update sql statement MM_editQuery = new StringBuffer("update ").append(MM_editTable).append(" set "); for (int i=0; i+1 < MM_fields.length; i+=2) { String formVal = MM_fields[i+1]; String elem; java.util.StringTokenizer tokens = new java.util.StringTokenizer(MM_columns[i+1],","); String delim = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:""; String altVal = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:""; String emptyVal = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:""; if (formVal.length() == 0) { formVal = emptyVal; } else { if (altVal.length() != 0) { formVal = altVal; } else if (delim.compareTo("'") == 0) { // escape quotes StringBuffer escQuotes = new StringBuffer(formVal); for (int j=0; j < escQuotes.length(); j++) if (escQuotes.charAt(j) == '\'') escQuotes.insert(j++,'\''); formVal = "'" + escQuotes + "'"; } else { formVal = delim + formVal + delim; } } MM_editQuery.append((i!=0)?",":"").append(MM_columns[i]).append(" = ").append(formVal); } MM_editQuery.append(" where ").append(MM_editColumn).append(" = ").append(MM_recordId); if (!MM_abortEdit) { // finish the sql and execute it Driver MM_driver = (Driver)Class.forName(MM_editDriver).newInstance(); Connection MM_connection = DriverManager.getConnection(MM_editConnection,MM_editUserName,MM_editPassword); PreparedStatement MM_editStatement = MM_connection.prepareStatement(MM_editQuery.toString()); MM_editStatement.executeUpdate(); MM_connection.close(); // redirect with URL parameters if (MM_editRedirectUrl.length() != 0) { response.sendRedirect(response.encodeRedirectURL(MM_editRedirectUrl)); } } } %> <% String retour__varDoc = "1"; if (request.getParameter("document_id") !=null) {retour__varDoc = (String)request.getParameter("document_id") ;} %> <% Driver Driverretour = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Connretour = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementretour = Connretour.prepareStatement("SELECT retour_id, retoureur_id, retour.document_id, datesortie, dateretour, titre, sorti FROM retour, livres WHERE livres.document_id = retour.document_id AND retour.document_id = '" + retour__varDoc + "' AND sorti = 't'"); ResultSet retour = Statementretour.executeQuery(); boolean retour_isEmpty = !retour.next(); boolean retour_hasData = !retour_isEmpty; Object retour_data; int retour_numRows = 0; %> Retour
No d'retour : <% if (!retour_isEmpty ) { %> "> <% } /* end !retour_isEmpty */ %>
Document : <% if (!retour_isEmpty ) { %> <%=(((retour_data = retour.getObject("document_id"))==null || retour.wasNull())?"":retour_data)%> <% } /* end !retour_isEmpty */ %>
  <% if (!retour_isEmpty ) { %> <%=(((retour_data = retour.getObject("datesortie"))==null || retour.wasNull())?"":retour_data)%> <% } /* end !retour_isEmpty */ %>
  <% if (!retour_isEmpty ) { %> <%=(((retour_data = retour.getObject("titre"))==null || retour.wasNull())?"":retour_data)%> <% } /* end !retour_isEmpty */ %>
:
<% if (!retour_isEmpty ) { %> "> <% } /* end !retour_isEmpty */ %>
<% retour.close(); Connretour.close(); %>