Computer Science 396S                                                                           Syllabus for Fall 2003

Dr. Carol E. Wolf                                                                                    Office 163 William St. 221

Website: http://csis.pace.edu/~wolf                                                           E-mail: cwolf@pace.edu

Office Hours: Tuesdays and Thursdays 1:00-3:00, Wednesdays 11:00-12:00

Prerequites: CS 241 and CS 232

Students in CS 396S, Servlets and Databases, will create Java servlets that receive data from a client's web page and store it in a database.  They will study advanced Java programming techniques and SQL programming.  They will create web applications such as an order system or an organization registration system.

SpreadSheet with Grades

Assignment 1 

Assignment 2

Assignment 3 HTML Forms

Assignment 4

Assignment 5

Assignment 6

Assignment 7

Connection Pools

Week

Date

Topic

 

1

Sep 10

Introduction to the simple server example

 

2

Sep 17

Sockets and the code for the simple server

 

3

Sep 24

HTML Forms

 

4

Oct 1

SQL and databases

 

5

Oct 8

SQL

 

6

Oct 15

Java servlets

 Apache Tomcat server

7

Oct 22

More on Java servlets

 

8

Oct 29

Using SQL in a servlet

 

9

Nov 5

Servlets, SQL and databases

 

10

Nov 12

dhtml and xml

 

11

Nov 19

web.xml

 

12

Dec 3

JSP – Java Server Pages

 

13

Dec 10

Presentations

 

 

Dec 17

Presentations

 

 

See http://www.w3schools.com for useful tutorials on some of this material.

 

http://www.novocode.com/doc/servlet-essentials/ has information about Java servlets.

 

Documents for downloading