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