Homework 2

Servlet and JDBC Programming

Create a Web browser-based application that calculates the price of a given number of shares (stock) of a company listed on the DOW 30 index. The company may be given by its DOW 30 ticker symbol. You must use the unit stock price values from a MySQL database called stocks, available on uml.cs.uga.edu. The user name and password are given on uml in the directory ~kochut/csx050/Stocks.txt.

Your application should have a simple HTML form where the user should be able to enter the company ticker symbol and the requested number of shares. Your application should retrieve the unit share price for the company from the database, calculate the total cost of the shares, and report the result back to the user.

Your application must utilize a Java servlet and a simple HTML form. The application WAR archive must have a name of the form firstname_lastname_stocks.war. In addition, you must deploy your application (the WAR file) to our JBoss Application Server on uml by copying it to the directory /opt/jboss/server/default/deploy/hmwk2. Remember to make it readable to all.

Submit your complete application to the user csx050 on odin.cs.uga.edu. Include the Java sources, the Web application directory structure, and the final (deployed) WAR archive file, and a README file describing how to compile your program and create the WAR archive.