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's registration system.
Documents for the course in Microsoft Word
| Week | Date | Topic |
|
|
Sep 13 | Introduction to the Webserver and HTML forms |
|
|
Sep 20 | Access database. SQL: Select ... Where |
|
|
Sep 27 | Using the Webserver and Html forms to get data from a database. XHTML |
|
|
Oct 11 | Installing and configuring the Apache Tomcat server. The Web Application Deployment Descriptor |
|
|
Oct 18 | Introduction to XML. SQL Insert |
|
|
Oct 25 | Java Server Pages (JSP) and Java Beans SQL Delete |
|
|
Nov 1 |
Database design, More JSP |
|
|
Nov 8 | Cascading Style Sheets (CSS) More SQL: Metadata, Alter, Create. MySQL database |
|
|
Nov 15 | Additional Html Forms Using the Session object to track users |
|
|
Nov 22 | Javascript, Adding security: usernames and passwords Connection Sharing and Pooling |
|
|
Nov 29 | XML: Document Type Definitions (DTDs) Schema, XSLT |
|
|
Dec 6 | XML: Parsers, SAX and DOM |
|
|
Dec 13 | Presentations |
|
Dec 20 12:50-2:30 |
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.