<%@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 auteur__varText = "%"; if (sqlEscape(request.getParameter("auteurTxt")) !=null) {auteur__varText = (String)(sqlEscape(request.getParameter("auteurTxt"))) ;} %> <% Driver Driverauteur = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Connauteur = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementauteur = Connauteur.prepareStatement("SELECT books.book_id, auteur_de.auteur_id, noinventaire, books.titre, lieupublication, datepublication, auteur.name, auteur.first_name, typedocument FROM books, auteur_de, auteur WHERE books.book_id = auteur_de.book_id and auteur_de.auteur_id = auteur.auteur_id and auteur.name ILIKE '" + auteur__varText + "%' ORDER BY datepublication DESC"); ResultSet auteur = Statementauteur.executeQuery(); boolean auteur_isEmpty = !auteur.next(); boolean auteur_hasData = !auteur_isEmpty; Object auteur_data; int auteur_numRows = 0; %> <% int Repeat1__numRows = 20; int Repeat1__index = 0; auteur_numRows += Repeat1__numRows; %> <% // *** Recordset Stats, Move To Record, and Go To Record: declare stats variables int auteur_first = 1; int auteur_last = 1; int auteur_total = -1; if (auteur_isEmpty) { auteur_total = auteur_first = auteur_last = 0; } //set the number of rows displayed on this page if (auteur_numRows == 0) { auteur_numRows = 1; } %> <% // *** Recordset Stats: if we don't know the record count, manually count them if (auteur_total == -1) { // count the total records by iterating through the recordset for (auteur_total = 1; auteur.next(); auteur_total++); // reset the cursor to the beginning auteur.close(); auteur = Statementauteur.executeQuery(); auteur_hasData = auteur.next(); // set the number of rows displayed on this page if (auteur_numRows < 0 || auteur_numRows > auteur_total) { auteur_numRows = auteur_total; } // set the first and last displayed record auteur_first = Math.min(auteur_first, auteur_total); auteur_last = Math.min(auteur_first + auteur_numRows - 1, auteur_total); } %> <% String MM_paramName = ""; %> <% // *** Move To Record and Go To Record: declare variables ResultSet MM_rs = auteur; int MM_rsCount = auteur_total; int MM_size = auteur_numRows; String MM_uniqueCol = ""; MM_paramName = ""; int MM_offset = 0; boolean MM_atTotal = false; boolean MM_paramIsDefined = (MM_paramName.length() != 0 && request.getParameter(MM_paramName) != null); %> <% // *** Move To Record: handle 'index' or 'offset' parameter if (!MM_paramIsDefined && MM_rsCount != 0) { //use index parameter if defined, otherwise use offset parameter String r = request.getParameter("index"); if (r==null) r = request.getParameter("offset"); if (r!=null) MM_offset = Integer.parseInt(r); // if we have a record count, check if we are past the end of the recordset if (MM_rsCount != -1) { if (MM_offset >= MM_rsCount || MM_offset == -1) { // past end or move last if (MM_rsCount % MM_size != 0) // last page not a full repeat region MM_offset = MM_rsCount - MM_rsCount % MM_size; else MM_offset = MM_rsCount - MM_size; } } //move the cursor to the selected record int i; for (i=0; auteur_hasData && (i < MM_offset || MM_offset == -1); i++) { auteur_hasData = MM_rs.next(); } if (!auteur_hasData) MM_offset = i; // set MM_offset to the last possible record } %> <% // *** Move To Record: if we dont know the record count, check the display range if (MM_rsCount == -1) { // walk to the end of the display range for this page int i; for (i=MM_offset; auteur_hasData && (MM_size < 0 || i < MM_offset + MM_size); i++) { auteur_hasData = MM_rs.next(); } // if we walked off the end of the recordset, set MM_rsCount and MM_size if (!auteur_hasData) { MM_rsCount = i; if (MM_size < 0 || MM_size > MM_rsCount) MM_size = MM_rsCount; } // if we walked off the end, set the offset based on page size if (!auteur_hasData && !MM_paramIsDefined) { if (MM_offset > MM_rsCount - MM_size || MM_offset == -1) { //check if past end or last if (MM_rsCount % MM_size != 0) //last page has less records than MM_size MM_offset = MM_rsCount - MM_rsCount % MM_size; else MM_offset = MM_rsCount - MM_size; } } // reset the cursor to the beginning auteur.close(); auteur = Statementauteur.executeQuery(); auteur_hasData = auteur.next(); MM_rs = auteur; // move the cursor to the selected record for (i=0; auteur_hasData && i < MM_offset; i++) { auteur_hasData = MM_rs.next(); } } %> <% // *** Move To Record: update recordset stats // set the first and last displayed record auteur_first = MM_offset + 1; auteur_last = MM_offset + MM_size; if (MM_rsCount != -1) { auteur_first = Math.min(auteur_first, MM_rsCount); auteur_last = Math.min(auteur_last, MM_rsCount); } // set the boolean used by hide region to check if we are on the last record MM_atTotal = (MM_rsCount != -1 && MM_offset + MM_size >= MM_rsCount); %> <% // *** 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); %> <% // *** Move To Record: set the strings for the first, last, next, and previous links String MM_moveFirst,MM_moveLast,MM_moveNext,MM_movePrev; { String MM_keepMove = MM_keepBoth; // keep both Form and URL parameters for moves String MM_moveParam = "index="; // if the page has a repeated region, remove 'offset' from the maintained parameters if (MM_size > 1) { MM_moveParam = "offset="; int start = MM_keepMove.indexOf(MM_moveParam); if (start != -1 && (start == 0 || MM_keepMove.charAt(start-1) == '&')) { int stop = MM_keepMove.indexOf('&', start); if (start == 0 && stop != -1) stop++; if (stop == -1) stop = MM_keepMove.length(); if (start > 0) start--; MM_keepMove = MM_keepMove.substring(0,start) + MM_keepMove.substring(stop); } } // set the strings for the move to links StringBuffer urlStr = new StringBuffer(request.getRequestURI()).append('?').append(MM_keepMove); if (MM_keepMove.length() > 0) urlStr.append('&'); urlStr.append(MM_moveParam); MM_moveFirst = urlStr + "0"; MM_moveLast = urlStr + "-1"; MM_moveNext = urlStr + Integer.toString(MM_offset+MM_size); MM_movePrev = urlStr + Integer.toString(Math.max(MM_offset-MM_size,0)); } %> Resultat de votre recherche
lmstoolkit

Books written by: <%= ((request.getParameter("auteurTxt")!=null)?request.getParameter("auteurTxt"):"") %>

Documents <%=(auteur_first)%> to <%=(auteur_last)%> of<%=(auteur_total)%>

<% if (MM_offset !=0) { %> First <% } /* end MM_offset != 0 */ %> <% if (MM_offset !=0) { %> Previous <% } /* end MM_offset != 0 */ %> <% if (!MM_atTotal) { %> Next <% } /* end !MM_atTotal */ %> <% if (!MM_atTotal) { %> Last <% } /* end !MM_atTotal */ %>
<% while ((auteur_hasData)&&(Repeat1__numRows-- != 0)) { %> <% Repeat1__index++; auteur_hasData = auteur.next(); } %>
<%=(((auteur_data = auteur.getObject("typedocument"))==null || auteur.wasNull())?"":auteur_data)%> "><%=(((auteur_data = auteur.getObject("noinventaire"))==null || auteur.wasNull())?"":auteur_data)%> <%=(((auteur_data = auteur.getObject("first_name"))==null || auteur.wasNull())?"":auteur_data)%> <%=(((auteur_data = auteur.getObject("name"))==null || auteur.wasNull())?"":auteur_data)%> <%=(((auteur_data = auteur.getObject("titre"))==null || auteur.wasNull())?"":auteur_data)%> <%=(((auteur_data = auteur.getObject("lieupublication"))==null || auteur.wasNull())?"":auteur_data)%> <%=(((auteur_data = auteur.getObject("datepublication"))==null || auteur.wasNull())?"":auteur_data)%>
<% if (MM_offset !=0) { %> First <% } /* end MM_offset != 0 */ %> <% if (MM_offset !=0) { %> Previous <% } /* end MM_offset != 0 */ %> <% if (!MM_atTotal) { %> Next <% } /* end !MM_atTotal */ %> <% if (!MM_atTotal) { %> Last <% } /* end !MM_atTotal */ %>

Search again

 
© Tony Grant/tgds.net 2002
<% auteur.close(); Connauteur.close(); %>