<%@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--%>
<%
Driver Driverinventaire = (Driver)Class.forName(MM_library_DRIVER).newInstance();
Connection Conninventaire = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD);
PreparedStatement Statementinventaire = Conninventaire.prepareStatement("SELECT MAX(book_id) FROM books");
ResultSet inventaire = Statementinventaire.executeQuery();
boolean inventaire_isEmpty = !inventaire.next();
boolean inventaire_hasData = !inventaire_isEmpty;
Object inventaire_data;
int inventaire_numRows = 0;
%>
<%
// *** Recordset Stats, Move To Record, and Go To Record: declare stats variables
int inventaire_first = 1;
int inventaire_last = 1;
int inventaire_total = -1;
if (inventaire_isEmpty) {
inventaire_total = inventaire_first = inventaire_last = 0;
}
//set the number of rows displayed on this page
if (inventaire_numRows == 0) {
inventaire_numRows = 1;
}
%>
<%
// *** Recordset Stats: if we don't know the record count, manually count them
if (inventaire_total == -1) {
// count the total records by iterating through the recordset
for (inventaire_total = 1; inventaire.next(); inventaire_total++);
// reset the cursor to the beginning
inventaire.close();
inventaire = Statementinventaire.executeQuery();
inventaire_hasData = inventaire.next();
// set the number of rows displayed on this page
if (inventaire_numRows < 0 || inventaire_numRows > inventaire_total) {
inventaire_numRows = inventaire_total;
}
// set the first and last displayed record
inventaire_first = Math.min(inventaire_first, inventaire_total);
inventaire_last = Math.min(inventaire_first + inventaire_numRows - 1, inventaire_total);
}
%>
<html>
<head>
<title>Rechercher un Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="lmstk.css" rel="stylesheet" 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><br> <table width="760" border="0" cellpadding="3" align="center">
<tr>
<td colspan="2"> <h2>Update file</h2></td>
</tr>
<tr>
<td>Find by shelf number</td>
<td> <form name="isbn" method="post" action="list_docu.jsp">
<input type="text" name="numberTxt" size="32">
<input type="submit" name="Submit4" value="Find">
</form></td>
</tr>
<tr>
<td>Find by file number (last file n° shown)</td>
<td> <form name="form1" method="post" action="update_doc.jsp">
<input type="text" name="book_id" value="<%=(((inventaire_data = inventaire.getObject("max"))==null || inventaire.wasNull())?"":inventaire_data)%>">
<input type="submit" name="Submit" value="Find">
</form></td>
</tr>
<tr>
<td colspan="2"> <div align="center"></div></td>
</tr>
</table></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>
<%
inventaire.close();
Conninventaire.close();
%>