%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %> <%@ 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--%> <% // *** Validate request to log in to this site. String MM_LoginAction = request.getRequestURI(); if (request.getQueryString() != null && request.getQueryString().length() > 0) MM_LoginAction += "?" + request.getQueryString(); String MM_valUsername=request.getParameter("login"); if (MM_valUsername != null) { String MM_fldUserAuthorization="id"; String MM_redirectLoginSuccess="docindex.jsp"; String MM_redirectLoginFailed="error.html"; String MM_redirectLogin=MM_redirectLoginFailed; Driver MM_driverUser = (Driver)Class.forName(MM_library_DRIVER).newInstance(); Connection MM_connUser = DriverManager.getConnection(MM_library_STRING,MM_library_USERNAME,MM_library_PASSWORD); String MM_pSQL = "SELECT login, pass"; if (!MM_fldUserAuthorization.equals("")) MM_pSQL += "," + MM_fldUserAuthorization; MM_pSQL += " FROM password WHERE login=\'" + MM_valUsername.replace('\'', ' ') + "\' AND pass=\'" + request.getParameter("pass").toString().replace('\'', ' ') + "\'"; PreparedStatement MM_statementUser = MM_connUser.prepareStatement(MM_pSQL); ResultSet MM_rsUser = MM_statementUser.executeQuery(); boolean MM_rsUser_isNotEmpty = MM_rsUser.next(); if (MM_rsUser_isNotEmpty) { // username and password match - this is a valid user session.putValue("MM_Username", MM_valUsername); if (!MM_fldUserAuthorization.equals("")) { session.putValue("MM_UserAuthorization", MM_rsUser.getString(MM_fldUserAuthorization).trim()); } else { session.putValue("MM_UserAuthorization", ""); } if ((request.getParameter("accessdenied") != null) && false) { MM_redirectLoginSuccess = request.getParameter("accessdenied"); } MM_redirectLogin=MM_redirectLoginSuccess; } MM_rsUser.close(); MM_connUser.close(); response.sendRedirect(response.encodeRedirectURL(MM_redirectLogin)); return; } %>
A turnkey solution for art center and museum libraries. It is currently being developed for other types of libraries. The keyword is "Toolkit". The software is designed to be modular from the ground up. For example: MARC support can be implemented via Marc4J. By using Marc4J and XML it is possible to convert the data in the database to and from various MARC formats with MARCXML as an intermediate step. This being specific to each libraries individual needs, we leave it up to you to implement MARC support as you see fit. The product is based on open source software. It is provided as open source software licenced under the GPL. If you use it please consider a donation to help pay for continued development and web hosting fees. We can provide an invoice should your accountant need one.Other solutions include:
Click on the download link on the top of this page to go
to the files which are hosted by
A couple of forums are available on the sourceforge project page as well: help for assistance in installing the application and a general forum for feature requests and comments. The demonstration catalogueThis is a real catalogue of books and magazines on contemporary art, most in french. Try searching by the name of a famous artist such as Dali, Picasso or Warhol for example.
© Tony Grant/tgds.net 2002 | Privacy |