Java Servlet and JSP Web Application 1

Functional Specification

  1. To provide an up to date inventory item list;
  2. To allow users to add a new inventory item;
  3. To allow users to delete an existing inventory item;
  4. To allow users to edit an existing inventory item;

Development Environment

  1. Oracle Netbean IDE 7.1 with J2EE;
  2. Oracle Glassfish 3.1.1 Open Source Application Server;
  3. MySQL DBMS 5.1.49-Iubuntu8.1 and JDBC jar file: mysql-connector-java-5.1.13-bin.jar .

Database Schema

(adapted from book Professional Java Servlet 2.3 by Apress 2004 ISBN (pbk): 1-861005-61-X)

    CREATE DATABASE inventory;
    USE inventory;

    CREATE TABLE item (
      id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
      name VARCHAR(30) NOT NULL,
      description VARCHAR(30) NOT NULL,
      price DOUBLE NOT NULL,
      stock INTEGER NOT NULL);

    INSERT INTO item (name, description, price, stock)
      VALUES ('Straw Hat', 'The best in town', 78.99, 9012);
    INSERT INTO item (name, description, price, stock)
      VALUES ('Polo Shirt', 'The latest fashion', 49.99, 99);

About henry416
I am a computer technology explorer and an university student based on Toronto. If you have any question, please feel free to discuss and comment here

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s