<%@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--%>
<%
String auteur__varDoc = "1000";
if (request.getParameter("book_id") !=null) {auteur__varDoc = (String)request.getParameter("book_id") ;}
%>
<%
Driver Driverauteur = (Driver)Class.forName(MM_library_DRIVER).newInstance();
Connection Connauteur = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD);
PreparedStatement Statementauteur = Connauteur.prepareStatement("SELECT auteur.auteur_id, name, first_name, noinventaire FROM auteur_de, auteur, books WHERE auteur.auteur_id = auteur_de.auteur_id AND books.book_id = auteur_de.book_id AND auteur_de.book_id = '" + auteur__varDoc + "'");
ResultSet auteur = Statementauteur.executeQuery();
boolean auteur_isEmpty = !auteur.next();
boolean auteur_hasData = !auteur_isEmpty;
Object auteur_data;
int auteur_numRows = 0;
%>
<%
int Repeat1__numRows = -1;
int Repeat1__index = 0;
auteur_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);
%>
<html>
<head>
<title>Supprime auteur</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="760" 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><h2 align="left"><font color="#999999"><br>
Delete author from <%=(((auteur_data = auteur.getObject("noinventaire"))==null || auteur.wasNull())?"":auteur_data)%></font></h2>
<table width="550" border="0" cellspacing="0" cellpadding="0" align="center">
<% while ((auteur_hasData)&&(Repeat1__numRows-- != 0)) { %>
<tr>
<td><a href="confirm_del.jsp?<%= MM_keepNone + ((MM_keepNone!="")?"&":"") + "auteur_id=" + (((auteur_data = auteur.getObject("auteur_id"))==null || auteur.wasNull())?"":auteur_data) %>"><%=(((auteur_data = auteur.getObject("auteur_id"))==null || auteur.wasNull())?"":auteur_data)%></a></td>
<td><%=(((auteur_data = auteur.getObject("first_name"))==null || auteur.wasNull())?"":auteur_data)%></td>
<td><%=(((auteur_data = auteur.getObject("name"))==null || auteur.wasNull())?"":auteur_data)%></td>
</tr>
<%
Repeat1__index++;
auteur_hasData = auteur.next();
}
%>
</table>
<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>
</body>
</html>
<%
auteur.close();
Connauteur.close();
%>