Ethnobotany Ver 1.0 Readme

The Ethnobotany site is developed using Java Serve Pages and is powered by MySQL.
All the calls to database are handled by JavaBeans while the JSP handles most outputs.

System requirements:

• A JSP container, supporting JSP 1.1 and JavaBeans;
• JDBC MySQL connector;
• A MySQL database called museum, with two tables in it: admin and ethnobot ;
• A MySQL account with INSERT, DELETE, SELECT, UPDATE privileges on museum.* ;

Files:

• the root directory contains all the JSPs;
• /images contains all the stylesheets and images needed for JSPs;
• /photos contains the ethnobotany photos;
• /WEB-INF/classes/museum contains all the JavaBeans.

To Install:

• Modify the SQLManager class in the museum package in the WEB-INF/classes/ directory
  • the SQLManager class uses the JDBC driver named "com.mysql.jdbc.Driver",
    if the system runs the old driver called "org.gjt.mm.mysql", please change the sqlDriver variable;
  • please modify the sqlTable, sqlUserName and sqlPassword variables in the default constructor SQLManager();
• Run CreateTable.sql to create database and tables;
• Run CreateRecord.sql to create records.

The application works in the following way:

• Anonymous user can only browse and search in the database;
• Administrator can insert, delete, modify entries, depending on the privileges assigned by Super User.
• Super User can add Super Users, add / remove Administrators, assign privileges to Administrators.
• Super User has all the privileges.
• Administrators / Super Users need to log on, if verification is successful, their privileges will be stored in the session object,
  which will expire when they log off or the browser is closed;
• Photos are not stored in the database, but the URL;
• Photos need to be manually uploaded to /photos directory to insert; online uploading is not supported in this version.;

If you have any questions, please contact me: s_qian@sfu.ca

Song Qian
March 01, 2004