<%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*"%> <%@ include file="Connections/library.jsp" %> <% String documentation__varDoc = "1"; if (request.getParameter("document_id") !=null) {documentation__varDoc = (String)request.getParameter("document_id") ;} %> <% Driver Driverdocumentation = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Conndocumentation = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementdocumentation = Conndocumentation.prepareStatement("SELECT * FROM livres WHERE livres.document_id = '" + documentation__varDoc + "'"); ResultSet documentation = Statementdocumentation.executeQuery(); boolean documentation_isEmpty = !documentation.next(); boolean documentation_hasData = !documentation_isEmpty; Object documentation_data; int documentation_numRows = 0; %> <% String names_auteurs__varDoc = "1"; if (request.getParameter("document_id") !=null) {names_auteurs__varDoc = (String)request.getParameter("document_id") ;} %> <% Driver Drivernames_auteurs = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Connnames_auteurs = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementnames_auteurs = Connnames_auteurs.prepareStatement("SELECT nom, prenom, auteur.auteur_id, auteur_de.document_id, livres.document_id FROM auteur, auteur_de, livres WHERE livres.document_id = auteur_de.document_id and auteur_de.auteur_id = auteur.auteur_id and livres.document_id = ('" + names_auteurs__varDoc + "') ORDER BY nom"); ResultSet names_auteurs = Statementnames_auteurs.executeQuery(); boolean names_auteurs_isEmpty = !names_auteurs.next(); boolean names_auteurs_hasData = !names_auteurs_isEmpty; Object names_auteurs_data; int names_auteurs_numRows = 0; %> <% String name_artiste__varDoc = "1"; if (request.getParameter("document_id") !=null) {name_artiste__varDoc = (String)request.getParameter("document_id") ;} %> <% Driver Drivername_artiste = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Connname_artiste = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementname_artiste = Connname_artiste.prepareStatement("SELECT artiste.artiste_id, nom, prenom, refere_a.artiste_id, refere_a.document_id, livres.document_id FROM artiste, refere_a, livres WHERE livres.document_id = refere_a.document_id and refere_a.artiste_id = artiste.artiste_id and livres.document_id = ('" + name_artiste__varDoc + "') ORDER BY nom"); ResultSet name_artiste = Statementname_artiste.executeQuery(); boolean name_artiste_isEmpty = !name_artiste.next(); boolean name_artiste_hasData = !name_artiste_isEmpty; Object name_artiste_data; int name_artiste_numRows = 0; %> <% String editeur__varDoc = "1"; if (request.getParameter("document_id") !=null) {editeur__varDoc = (String)request.getParameter("document_id") ;} %> <% Driver Driverediteur = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Connediteur = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementediteur = Connediteur.prepareStatement("SELECT a_publie.document_id, editeur.editeur_id, nom_editeur, livres.document_id FROM a_publie, editeur, livres WHERE livres.document_id = a_publie.document_id and a_publie.editeur_id = editeur.editeur_id and livres.document_id = ('" + editeur__varDoc + "')"); ResultSet editeur = Statementediteur.executeQuery(); boolean editeur_isEmpty = !editeur.next(); boolean editeur_hasData = !editeur_isEmpty; Object editeur_data; int editeur_numRows = 0; %> <% String emprunt__varDoc = "1"; if (request.getParameter("document_id") !=null) {emprunt__varDoc = (String)request.getParameter("document_id");} %> <% Driver Driveremprunt = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Connemprunt = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementemprunt = Connemprunt.prepareStatement("SELECT emprunt_id, emprunt.document_id, sorti FROM emprunt WHERE emprunt.document_id = '" + emprunt__varDoc + "' AND emprunt.sorti = 't'"); ResultSet emprunt = Statementemprunt.executeQuery(); boolean emprunt_isEmpty = !emprunt.next(); boolean emprunt_hasData = !emprunt_isEmpty; Object emprunt_data; int emprunt_numRows = 0; %> <% int Repeat2__numRows = -1; int Repeat2__index = 0; names_auteurs_numRows += Repeat2__numRows; %> <% int Repeat1__numRows = -1; int Repeat1__index = 0; name_artiste_numRows += Repeat1__numRows; %> <% // *** Recordset Stats, Move To Record, and Go To Record: declare stats variables int documentation_first = 1; int documentation_last = 1; int documentation_total = -1; if (documentation_isEmpty) { documentation_total = documentation_first = documentation_last = 0; } //set the number of rows displayed on this page if (documentation_numRows == 0) { documentation_numRows = 1; } %> <% String MM_paramName = ""; %> <% // *** Move To Record and Go To Record: declare variables ResultSet MM_rs = documentation; int MM_rsCount = documentation_total; int MM_size = documentation_numRows; String MM_uniqueCol = "document_id"; MM_paramName = "document_id"; 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; documentation_hasData && (i < MM_offset || MM_offset == -1); i++) { documentation_hasData = MM_rs.next(); } if (!documentation_hasData) MM_offset = i; // set MM_offset to the last possible record } %> <% // *** Move To Specific Record: handle detail parameter if (MM_paramIsDefined && MM_rsCount != 0) { // get the value of the parameter String param = request.getParameter(MM_paramName); // find the record with the unique column value equal to the parameter value String colVal; while (documentation_hasData) { colVal = ((MM_rs.getObject(MM_uniqueCol)!=null)?MM_rs.getObject(MM_uniqueCol).toString():""); if (colVal.equals(param)) break; documentation_hasData = MM_rs.next(); MM_offset++; } // if not found, set the number of records and reset the cursor if (!documentation_hasData) { if (MM_rsCount < 0) MM_rsCount = MM_offset; if (MM_size < 0 || MM_size > MM_rsCount) MM_size = MM_rsCount; MM_offset = 0; // reset the cursor to the beginning documentation.close(); documentation = Statementdocumentation.executeQuery(); documentation_hasData = documentation.next(); MM_rs = documentation; } } %> <% // *** 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; documentation_hasData && (MM_size < 0 || i < MM_offset + MM_size); i++) { documentation_hasData = MM_rs.next(); } // if we walked off the end of the recordset, set MM_rsCount and MM_size if (!documentation_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 (!documentation_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 documentation.close(); documentation = Statementdocumentation.executeQuery(); documentation_hasData = documentation.next(); MM_rs = documentation; // move the cursor to the selected record for (i=0; documentation_hasData && i < MM_offset; i++) { documentation_hasData = MM_rs.next(); } } %> <% // *** Move To Record: update recordset stats // set the first and last displayed record documentation_first = MM_offset + 1; documentation_last = MM_offset + MM_size; if (MM_rsCount != -1) { documentation_first = Math.min(documentation_first, MM_rsCount); documentation_last = Math.min(documentation_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
No inventaire : <%=(((documentation_data = documentation.getObject("noinventaire"))==null || documentation.wasNull())?"":documentation_data)%>
Fiche : <%=(((documentation_data = documentation.getObject("document_id"))==null || documentation.wasNull())?"":documentation_data)%>

<%=(((documentation_data = documentation.getObject("typedocument"))==null || documentation.wasNull())?"":documentation_data)%>
Titre : <%=(((documentation_data = documentation.getObject("titre"))==null || documentation.wasNull())?"":documentation_data)%>
Sous titre : <%=(((documentation_data = documentation.getObject("titreexposition"))==null || documentation.wasNull())?"":documentation_data)%>
Artiste(s) : <% while ((name_artiste_hasData)&&(Repeat1__numRows-- != 0)) { %> <% if (!name_artiste_isEmpty ) { %> <% } /* end !name_artiste_isEmpty */ %> <% Repeat1__index++; name_artiste_hasData = name_artiste.next(); } %>
<%=(((name_artiste_data = name_artiste.getObject("nom"))==null || name_artiste.wasNull())?"":name_artiste_data)%> <%=(((name_artiste_data = name_artiste.getObject("prenom"))==null || name_artiste.wasNull())?"":name_artiste_data)%>
Auteur(s) : <% while ((names_auteurs_hasData)&&(Repeat2__numRows-- != 0)) { %> <% if (!names_auteurs_isEmpty ) { %> <% } /* end !names_auteurs_isEmpty */ %> <% Repeat2__index++; names_auteurs_hasData = names_auteurs.next(); } %>
<%=(((names_auteurs_data = names_auteurs.getObject("nom"))==null || names_auteurs.wasNull())?"":names_auteurs_data)%> <%=(((names_auteurs_data = names_auteurs.getObject("prenom"))==null || names_auteurs.wasNull())?"":names_auteurs_data)%>
Editeur :
<% if (!editeur_isEmpty ) { %> <%=(((editeur_data = editeur.getObject("nom_editeur"))==null || editeur.wasNull())?"":editeur_data)%> <% } /* end !editeur_isEmpty */ %>
Lieu : <%=(((documentation_data = documentation.getObject("lieupublication"))==null || documentation.wasNull())?"":documentation_data)%> Date : <%=(((documentation_data = documentation.getObject("datepublication"))==null || documentation.wasNull())?"":documentation_data)%>
Pages : <%=(((documentation_data = documentation.getObject("nbpages"))==null || documentation.wasNull())?"":documentation_data)%> Pages illust. : <%=(((documentation_data = documentation.getObject("nbpagesillustr"))==null || documentation.wasNull())?"":documentation_data)%> N&B : <%=(((documentation_data = documentation.getObject("nbpagesnb"))==null || documentation.wasNull())?"":documentation_data)%> Couleur : <%=(((documentation_data = documentation.getObject("nbpagescoul"))==null || documentation.wasNull())?"":documentation_data)%>
ISBN : <%=(((documentation_data = documentation.getObject("noisbn"))==null || documentation.wasNull())?"":documentation_data)%> <%=(((documentation_data = documentation.getObject("modeacquisition"))==null || documentation.wasNull())?"":documentation_data)%> Nombre ex. : <%=(((documentation_data = documentation.getObject("nombreexemplaires"))==null || documentation.wasNull())?"":documentation_data)%> Langue : <%=(((documentation_data = documentation.getObject("lang"))==null || documentation.wasNull())?"":documentation_data)%>
Résumé :
<% if (!emprunt_isEmpty ) { %>
type="checkbox" name="checkbox" value="checkbox"> livre en pret
<% } /* end !emprunt_isEmpty */ %>
<%=(((documentation_data = documentation.getObject("date_fiche"))==null || documentation.wasNull())?"":documentation_data)%> retour rechercher encore

 
<% documentation.close(); Conndocumentation.close(); %> <% names_auteurs.close(); Connnames_auteurs.close(); %> <% name_artiste.close(); Connname_artiste.close(); %> <% editeur.close(); Connediteur.close(); %> <% emprunt.close(); Connemprunt.close(); %>