<%@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 = "a_publie"; MM_editColumn = "editor_id"; MM_recordId = "" + request.getParameter("MM_recordId") + ""; MM_editRedirectUrl = "javascript:window.close()"; // 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 editor__MMColParam = "1"; if (request.getParameter("editor_id") !=null) {editor__MMColParam = (String)request.getParameter("editor_id");} %> <% Driver Drivereditor = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Conneditor = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementeditor = Conneditor.prepareStatement("SELECT * FROM a_publie WHERE editor_id = " + editor__MMColParam + ""); ResultSet editor = Statementeditor.executeQuery(); boolean editor_isEmpty = !editor.next(); boolean editor_hasData = !editor_isEmpty; Object editor_data; int editor_numRows = 0; %> <html> <head> <title>Supprime editor</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link rel="stylesheet" href="lmstk.css" type="text/css"> </head> <body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <table width="100%" border="0"> <tr> <td bgcolor="#4A494A"><!-- #BeginLibraryItem "/Library/lmstk.lbi" --><map name="lmstkMap" id="lmstkMap"> <area shape="rect" coords="13,63,56,80" href="http://www.tgds.net/lmstk/" /> <area shape="rect" coords="63,63,166,80" href="about.html" /> <area shape="rect" coords="174,62,242,81" href="http://sourceforge.net/projects/lmstk/" /> <area shape="rect" coords="250,62,296,80" href="http://sourceforge.net/forum/?group_id=62137" /> <area shape="rect" coords="305,62,357,80" href="mailto:tgrant@tgds.net" /> </map> <!-- #BeginLibraryItem "/Library/lmstk.lbi" --><img src="images/lmstk.png" alt="lmstoolkit" name="lmstk" width="760" height="82" border="0" usemap="#lmstkMap" id="lmstk" /><!-- #EndLibraryItem --><!-- #EndLibraryItem --></td> </tr> <tr> <td><br> <h2 align="left">Delete editor</h2> <form name="form1" method="POST" action="<%=MM_editAction%>"> <table width="550" border="0" cellspacing="0" cellpadding="0" align="center"> <tr> <td><%=(((editor_data = editor.getObject("book_id"))==null || editor.wasNull())?"":editor_data)%></td> <td> </td> <td><%=(((editor_data = editor.getObject("editor_id"))==null || editor.wasNull())?"":editor_data)%></td> <td> <input type="submit" name="Submit" value="OK"> </td> </tr> </table> <input type="hidden" name="MM_delete" value="true"> <input type="hidden" name="MM_recordId" value="<%=(((editor_data = editor.getObject("editor_id"))==null || editor.wasNull())?"":editor_data)%>"> </form> <p> </p> </td> </tr> <tr> <td><!-- #BeginLibraryItem "/Library/admin_bottom.lbi" -->© <a href="mailto:tgrant@tgds.net">Tony Grant</a>/tgds.net 2002<!-- #EndLibraryItem --></td> </tr> </table> <p> </p> <p> </p> </body> </html> <% editor.close(); Conneditor.close(); %>