<%@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--%> <% String name__MMColParam = "1"; if (request.getParameter("name") !=null) {name__MMColParam = (String)request.getParameter("name");} %> <% Driver Drivername = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection Connname = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); PreparedStatement Statementname = Connname.prepareStatement("SELECT borrower_id, name, first_name FROM borrower WHERE name = '" + name__MMColParam + "'"); ResultSet name = Statementname.executeQuery(); boolean name_isEmpty = !name.next(); boolean name_hasData = !name_isEmpty; Object name_data; int name_numRows = 0; %> <% int Repeat1__numRows = -1; int Repeat1__index = 0; name_numRows += Repeat1__numRows; %> <% while ((name_hasData)&&(Repeat1__numRows-- != 0)) { %> <% Repeat1__index++; name_hasData = name.next(); } %>

<%=(((name_data = name.getObject("individu_id"))==null || name.wasNull())?"":name_data)%>

<%=(((name_data = name.getObject("name"))==null || name.wasNull())?"":name_data)%>

<%=(((name_data = name.getObject("first_name"))==null || name.wasNull())?"":name_data)%>

<% name.close(); Connname.close(); %>