Mohammad Tanvir Alam

Mohammad Tanvir Alam

Graduate Student

Department of Computer Science

Rutgers, the State University of New Jersey

TA: Principles of Database Management Systems (cs336), Summer 2006

Recitation: Tuesday 8:45 PM - 10:00 PM, Lucy Stone Hall, A142

Recitation: Thursday 8:45 PM - 10:00 PM, Lucy Stone Hall, A142

Office: Hill 408

Office Hours: Tuesday 2:00 - 4:00 PM

Phone: 445-2002
Email: moalam@cs

Information

Project Demo is due on 16th August,Wednesday. Project Schedule

Trigger Creation example (MySql) by Brendan

Project requirement has been revised.

Oracle server has been fixed. Please replace the older connection string (inside getMets.java) with the following:

String url ="jdbc:oracle:thin:@" + "(DESCRIPTION=" + "(ADDRESS_LIST=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=abbott.rutgers.edu)(PORT=1521)))" + "(CONNECT_DATA=(SERVICE_NAME=student.rutgers.edu)))";

Or you can keep working with MySQL in your own machine.You cannot work on lab machines because it does not have MySQL. If you want to work in lab machine, work with Oracle.

Software Installation If eclipse cannot create a tomcat project please follow the steps to configure tomcat:
1. Go to window Menu->preference
2. select tomcat in preference dialog
3. set tomcat home with the tomcat directory ( for me it is C:\apache-tomcat-5.5.17)

Make the Cereal Account If you don't have it

Oracle Account Setup: Please go to the link and unlock your account using eden/remus id

Java Tutorial

HTML Tutorial

Servelet and JSP documentation (Chapter 11 and 12)

Project Prototype using Servlet Please try to understand getMets.java. At line 28 and 29 change the username and password to your own oracle username and password. Also you need to setup your database tables accordingly.

Project Requirement

Working with JSP and MySQL The document describes how to work with JSP together with MySQL. You can also make your servlet working with MySQL by just changing the connection string as given in the example JSP file.

MySQL document MySql Reference
MySql Tutorial
Use the following command to run a batch of query from a file:
...mysql\bin> mysql -u root -p < c:\query.txt

Login example with JSP and MySQL The example demonstrates a login example using JSP and MySQL. The example uses multiple JSP pages to show the behaviour of navigation.

Previous Courses

Software Engineering (cs431), Sprint 2006

Principles of Database Management Systems (cs336), Fall 2005


Software Installation	If eclipse cannot create a tomcat project please follow the steps to configure tomcat: 1. Go to window Menu->preference 2. select tomcat in preference dialog 3. set tomcat home with the tomcat directory ( for me it is C:\apache-tomcat-5.5.17)
Make the Cereal Account	If you don't have it
Oracle Account Setup:	Please go to the link and unlock your account using eden/remus id
Java Tutorial
HTML Tutorial
Servelet and JSP documentation (Chapter 11 and 12)
Project Prototype using Servlet	Please try to understand getMets.java. At line 28 and 29 change the username and password to your own oracle username and password. Also you need to setup your database tables accordingly.
Project Requirement
Working with JSP and MySQL	The document describes how to work with JSP together with MySQL. You can also make your servlet working with MySQL by just changing the connection string as given in the example JSP file.
MySQL document	MySql Reference MySql Tutorial Use the following command to run a batch of query from a file: ...mysql\bin> mysql -u root -p < c:\query.txt
Login example with JSP and MySQL	The example demonstrates a login example using JSP and MySQL. The example uses multiple JSP pages to show the behaviour of navigation.