<%@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; %> <% // *** Insert Record: set variables if (request.getParameter("MM_insert") != null && request.getParameter("MM_insert").toString().equals("form1")) { MM_editDriver = MM_library_DRIVER; MM_editConnection = MM_library_STRING; MM_editUserName = MM_library_USERNAME; MM_editPassword = MM_library_PASSWORD; MM_editTable = "livres"; MM_editRedirectUrl = ""; String MM_fieldsStr = "document_id|value|noinventaire|value|nombreexemplaires|value|noisbn|value|typedocument|value|titre|value|titreexposition|value|lieupublication|value|datepublication|value|nbpages|value|nbpagesillustr|value|nbpagesnb|value|nbpagescoul|value|thematique|value|modeacquisition|value|pageslibrary|value|resume|value|date_fiche|value|langue|value"; String MM_columnsStr = "document_id|none,none,NULL|noinventaire|',none,''|nombreexemplaires|none,none,NULL|noisbn|',none,''|typedocument|',none,''|titre|',none,''|titreexposition|',none,''|lieupublication|',none,''|datepublication|none,none,NULL|nbpages|none,none,NULL|nbpagesillustr|none,none,NULL|nbpagesnb|none,none,NULL|nbpagescoul|none,none,NULL|thematique|',none,''|modeacquisition|',none,''|pageslibrary|',none,''|resume|',none,''|date_fiche|none,none,NULL|lang|',none,''"; // 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(); } } %> <% // *** Insert Record: construct a sql insert statement and execute it if (request.getParameter("MM_insert") != null) { // create the insert sql statement StringBuffer MM_tableValues = new StringBuffer(), MM_dbValues = new StringBuffer(); 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_tableValues.append((i!=0)?",":"").append(MM_columns[i]); MM_dbValues.append((i!=0)?",":"").append(formVal); } MM_editQuery = new StringBuffer("insert into " + MM_editTable); MM_editQuery.append(" (").append(MM_tableValues.toString()).append(") values ("); MM_editQuery.append(MM_dbValues.toString()).append(")"); 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)); } } } %> <% Driver Driverlivres = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Connlivres = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementlivres = Connlivres.prepareStatement("SELECT * FROM livres"); ResultSet livres = Statementlivres.executeQuery(); boolean livres_isEmpty = !livres.next(); boolean livres_hasData = !livres_isEmpty; Object livres_data; int livres_numRows = 0; %> Creer doc

  Saisie d'un document

  
No inventaire :
Nombre d'exemplaires :
ISBN :
Type document :
Titre :
Ss Titre / exposition :
Lieu publication :
Date publication :
Pages :
Pages illustrées
N&B :
Couleur :
Thématique :
Acquisition :
Pages library :
Résumé :
Date de saisie : Automatique
Langue :
 
 
 


<% livres.close(); Connlivres.close(); %>