<%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*"%> <%@ include file="../Connections/library.jsp" %> <% String isbn__varInvent = "%"; if (request.getParameter("numberTxt") !=null) {isbn__varInvent = (String)request.getParameter("numberTxt") ;} %> <% Driver Driverisbn = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Connisbn = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementisbn = Connisbn.prepareStatement("SELECT noinventaire, titre, lieupublication, datepublication, noisbn, book_id, typedocument FROM books WHERE noinventaire ILIKE '%" + isbn__varInvent + "%' OR noisbn ILIKE '%" + isbn__varInvent + "%' ORDER BY datepublication DESC"); ResultSet isbn = Statementisbn.executeQuery(); boolean isbn_isEmpty = !isbn.next(); boolean isbn_hasData = !isbn_isEmpty; Object isbn_data; int isbn_numRows = 0; %> <% int Repeat1__numRows = -1; int Repeat1__index = 0; isbn_numRows += Repeat1__numRows; %> <% // *** Recordset Stats, Move To Record, and Go To Record: declare stats variables int isbn_first = 1; int isbn_last = 1; int isbn_total = -1; if (isbn_isEmpty) { isbn_total = isbn_first = isbn_last = 0; } //set the number of rows displayed on this page if (isbn_numRows == 0) { isbn_numRows = 1; } %> <% // *** Recordset Stats: if we don't know the record count, manually count them if (isbn_total == -1) { // count the total records by iterating through the recordset for (isbn_total = 1; isbn.next(); isbn_total++); // reset the cursor to the beginning isbn.close(); isbn = Statementisbn.executeQuery(); isbn_hasData = isbn.next(); // set the number of rows displayed on this page if (isbn_numRows < 0 || isbn_numRows > isbn_total) { isbn_numRows = isbn_total; } // set the first and last displayed record isbn_first = Math.min(isbn_first, isbn_total); isbn_last = Math.min(isbn_first + isbn_numRows - 1, isbn_total); } %> <% 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); %> Resultat de votre recherche

doc_art :

un logiciel de gestion de books ou de bibliothèque des centres d'art, galeries et musées.

Documents trouvés :

Documents <%=(isbn_first)%> à <%=(isbn_last)%> de <%=(isbn_total)%>

<% while ((isbn_hasData)&&(Repeat1__numRows-- != 0)) { %> <% Repeat1__index++; isbn_hasData = isbn.next(); } %>

<%=(((isbn_data = isbn.getObject("typedocument"))==null || isbn.wasNull())?"":isbn_data)%> "><%=(((isbn_data = isbn.getObject("noinventaire"))==null || isbn.wasNull())?"":isbn_data)%>

<%=(((isbn_data = isbn.getObject("titre"))==null || isbn.wasNull())?"":isbn_data)%>

<%=(((isbn_data = isbn.getObject("lieupublication"))==null || isbn.wasNull())?"":isbn_data)%>

<%=(((isbn_data = isbn.getObject("datepublication"))==null || isbn.wasNull())?"":isbn_data)%>

Rechercher encore :

<% isbn.close(); Connisbn.close(); %>