<%@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--%> <%! public static String sqlEscape(String str) { if(str==null) return(null); StringBuffer strBuf = new StringBuffer(); for(int i=0; i <% String titre__varTitle = "%"; if (request.getParameter("optionTxt") !=null) {titre__varTitle = (String)request.getParameter("optionTxt");} %> <% String titre__varRech = "%"; if (request.getParameter("recherche") !=null) {titre__varRech = (String)request.getParameter("recherche");} %> <% Driver Drivertitre = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Conntitre = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementtitre = Conntitre.prepareStatement("SELECT DISTINCT ON(books.book_id) noinventaire, titre, lieupublication, datepublication, typedocument, refers_to.book_id, refers_to.artist_id, name, first_name FROM refers_to, artist, books, a_publie, auteur_de, editor WHERE refers_to.book_id = books.book_id AND refers_to.artist_id = artist.artist_id AND a_publie.book_id = books.book_id AND a_publie.editor_id = editor.editor_id AND auteur_de.book_id = books.book_id AND auteur_de.auteur_id = auteur.auteur_id AND (" + titre__varRech + ") ILIKE ('%" + titre__varTitle + "%') ORDER BY books.book_id, datepublication DESC"); ResultSet titre = Statementtitre.executeQuery(); boolean titre_isEmpty = !titre.next(); boolean titre_hasData = !titre_isEmpty; Object titre_data; int titre_numRows = 0; %> <% int Repeat1__numRows = -1; int Repeat1__index = 0; titre_numRows += Repeat1__numRows; %> <% // *** Recordset Stats, Move To Record, and Go To Record: declare stats variables int titre_first = 1; int titre_last = 1; int titre_total = -1; if (titre_isEmpty) { titre_total = titre_first = titre_last = 0; } //set the number of rows displayed on this page if (titre_numRows == 0) { titre_numRows = 1; } %> <% // *** Recordset Stats: if we don't know the record count, manually count them if (titre_total == -1) { // count the total records by iterating through the recordset for (titre_total = 1; titre.next(); titre_total++); // reset the cursor to the beginning titre.close(); titre = Statementtitre.executeQuery(); titre_hasData = titre.next(); // set the number of rows displayed on this page if (titre_numRows < 0 || titre_numRows > titre_total) { titre_numRows = titre_total; } // set the first and last displayed record titre_first = Math.min(titre_first, titre_total); titre_last = Math.min(titre_first + titre_numRows - 1, titre_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
lmstoolkit

 

Documents trouvés pour : <%= ((request.getParameter("optionTxt")!=null)?request.getParameter("optionTxt"):"") %>

Documents <% if (!titre_isEmpty ) { %> <%=(titre_first)%> <% } /* end !titre_isEmpty */ %> à <% if (!titre_isEmpty ) { %> <%=(titre_last)%> <% } /* end !titre_isEmpty */ %> de <% if (!titre_isEmpty ) { %> <%=(titre_total)%> <% } /* end !titre_isEmpty */ %>

<% while ((titre_hasData)&&(Repeat1__numRows-- != 0)) { %> <% if (!titre_isEmpty ) { %> <% } /* end !titre_isEmpty */ %> <% Repeat1__index++; titre_hasData = titre.next(); } %>
<%=(((titre_data = titre.getObject("typedocument"))==null || titre.wasNull())?"":titre_data)%> "><%=(((titre_data = titre.getObject("noinventaire"))==null || titre.wasNull())?"":titre_data)%> <%=(((titre_data = titre.getObject("titre"))==null || titre.wasNull())?"":titre_data)%> <%=(((titre_data = titre.getObject("lieupublication"))==null || titre.wasNull())?"":titre_data)%> <%=(((titre_data = titre.getObject("datepublication"))==null || titre.wasNull())?"":titre_data)%>

rechercher encore
© Tony Grant/tgds.net 2002
<% titre.close(); Conntitre.close(); %>