<%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*"%> <%@ include file="Connections/library.jsp" %> <%--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--%> <% // *** 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; %> <% // *** Delete Record: construct a sql delete statement and execute it if (request.getParameter("MM_delete") != 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 = "books"; MM_editColumn = "book_id"; MM_recordId = "" + request.getParameter("MM_recordId") + ""; MM_editRedirectUrl = "bang.html"; // append the query string to the redirect URL if (MM_editRedirectUrl.length() != 0 && request.getQueryString() != null) { MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + request.getQueryString(); } } %> <% // *** Delete Record: construct a sql delete statement and execute it if (request.getParameter("MM_delete") != null && request.getParameter("MM_recordId") != null) { // create the delete sql statement MM_editQuery = new StringBuffer("delete from ").append(MM_editTable); 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 doc__MMColParam = "1"; if (request.getParameter("book_id") !=null) {doc__MMColParam = (String)request.getParameter("book_id");} %> <% Driver Driverdoc = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Conndoc = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementdoc = Conndoc.prepareStatement("SELECT * FROM books WHERE book_id = " + doc__MMColParam + ""); ResultSet doc = Statementdoc.executeQuery(); boolean doc_isEmpty = !doc.next(); boolean doc_hasData = !doc_isEmpty; Object doc_data; int doc_numRows = 0; %> Suprimer document


<% if (!doc_isEmpty ) { %> "> <% } /* end !doc_isEmpty */ %>
<% if (!doc_isEmpty ) { %> <%=(((doc_data = doc.getObject("book_id"))==null || doc.wasNull())?"":doc_data)%> <% } /* end !doc_isEmpty */ %> <% if (!doc_isEmpty ) { %> <%=(((doc_data = doc.getObject("noinventaire"))==null || doc.wasNull())?"":doc_data)%> <% } /* end !doc_isEmpty */ %> <% if (!doc_isEmpty ) { %> <%=(((doc_data = doc.getObject("titre"))==null || doc.wasNull())?"":doc_data)%> <% } /* end !doc_isEmpty */ %>
<% doc.close(); Conndoc.close(); %>