<%@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);
}
%>
Rechercher un Document
