TA Corner for CMSC 424 (Fall 2006)
Project Information
- Link to the class forum (Keep yourself updated about the technical issues faced by others and their solutions, so that you don’t waste too much time on the same problem)
- The steps to be followed after Phase0 and Phase1 (and their suggested time durations):
- Review the sample E-R model put up on the class forum. Compare it with your E-R diagram. If your E-R diagram is inconsistent with the sample, meet me. Also review the comments and suggestions given by me. (week 1)
- Install Tomcat. Tomcat is a Java Servlet container and web server. A web server dishes out web pages in response to requests from a user sitting at a web browser. (week 1)
- Decide on a programming language for the project. The 2 options you have are JSP or Ruby. (week 1)
- Create an interface between your programming language and the Oracle database. (week 1)
- An example using
thin-client Java interface for Oracle
To compile:
javac -cp $ORACLE_HOME/jdbc/lib/ojdbc14.jar Example1.java
To run:
java -cp $ORACLE_HOME/jdbc/lib/ojdbc14.jar:. Example1
o Make your first web server application (week 1)
o A simple guide to get started with JSP. (Be clear of the directory structures, config file modification..etc)
o
Advanced Form Processing
in JSP
· Now that you know how to deploy your application and also how to create an interface between the application and the database, start working on the actual data. Create the tables, populate them with data, and write queries for the tasks mentioned in the description. Also, start working on the “location updates” part. Look at the references below for help regarding parsing XML documents. (week 2)
· Work on the front-end part of the project. This is the part which interacts directly with the user (Web forms). You will have to explore a few of the options provided by the programming language you have chosen for building web forms.. Examples related to this will be put up shortly. (week 3)
· Integrate the front end and the database. Test your web application for any inconsistencies, data validations etc. (week 4)
· Try to fix the problems that you found in your application in the previous phase. If time permits try enhancements and advanced options. Prepare the phase2 report. Get ready for the demo! (week 5)
Reference
- Oracle Faq
- JDBC tutorial
- JDBC faq
- JSP2.0 tutorial: 1, 2
- Java Servlet tutorial
- XML Parsing in java: http://java.sun.com/webservices/jaxp/dist/1.1/docs/tutorial/dom/index.html
Note:
- If you find some new resource, tutorial or help page that is useful, and think it might help others, e-mail me the link. I will try to put that up in this webpage.
- The steps and their suggested timelines here are my inference from a similar project that I had completed during my undergraduate Database course. If you feel that you can do better without following these steps, you are free to do so.
- For any clarifications regarding the material put up here contact me at sharath[at]cs.umd.edu