<%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*"%>
<%@ include file="Connections/library.jsp" %>
<%
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(document_id) FROM livres");
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
