Java Server Side
JSP, Servlets and MySQL




Dale R. "Zai" Fox, Ph.D.



Office Hours: 5:00 - 6:00 PM  Wednesday
other hours by appointment





I have been working hard to develop a "unified view" of server side scripting.  This means I am developing an approach to teaching PHP, JSP or ASP that maximizes the amount of common content across the languages.  I have found that with some serious work I have been able to do quite a bit in this direction.  But it also means that the last I knew there are no good books on JSP.

The truth is the books on JSP tend to be either terribly sophisticated conceptually, requiring the developer to build a lot of their own classes, or they tend to have entirely simplistic examples.  I have been working to give realistic examples that impart knowledge and conceptualizations that can traverse the different server side scripting languages.

I once tried to teach this course from the following book.

Steelman & Murach, Java Servlets and JSPs, Murach Publishing.

But I found its examples were terribly simplistic and not at all realistic.

I am still searching for other books and have found a book that I consider to be written by someone that is doing practical JSP with MySQL.

Turner, MySQL and JSP Web Applications, SAMS Publishing.

But his approaches do not port all that well across middleware approaches.  But he intelligently develops his own classes/beans to be used.  I consider it to be the best practical and reasonable source written in the fairly standard Java genre.

General Content:

The first part of the course will focus on more advanced issues associated with GUI development.

The primary focus of the course will be on Servlets and JSPs.  We will also work with the JDBC in order to connect to databases in our efforts.

I will largely develop some templates that illustrate the major issues.


- 75% of your grade will be based on homework assignments. All of the problems need be turned in individually.  On the other hand, you are expected to work together to develop your solutions.   Each homework assignment will be graded on a 100 point scale. They will be due at the beginning of the class period on the day they are due. If you turn a homework assignment in late within a day of the due date you will lose 5 points. If you turn it in late within 3 days of the due date you will lose 10 points. Anything turned in later than 3 days but still within a week will result in an automatic loss of 15 points. Finally, anything more than a week late will result in an automatic loss of 25 points.

- 25% of your grade will be based on developing a project to do some computer system performance evaluation.

You will want to e-mail your solutions to me by the date and time they are due. Any written discussion should be placed in a Word file and attached/inserted. You will also attach/insert things such as forms and projects to your e-mail.


Weekly Topic Coverage

Week 1

Work through Installing Tomcat (Chapter 2 of Steelman and Murach)

Making Use of

Some Background on JSP Pages
Making Use of Built In Date/Time Methods

Week 2

Forms and Form Processing
A Bit About Form Processing
Some Background on Forms in HTML
Getting Information from Forms in JSPs

The Request Object/Class
Some Ancillary Issues

Week 3

A Bit About Threads
A Form and Processing Script that has Thread Flaws
A Form and Adjusted Processing Script that Deals with the Threads

A Bit About Servlets
Threads and the Servlets Generated by JSPs
A Couple Very Simple Generated Servlets

Week 4

A Bit About Sticky Forms
A Sticky Form with Error Checking and Text Boxes Only
A Sticky Form with Formatting and Input Validation
A Sticky Form That Uses All the Form Controls

Homework 2

Week 5

Creating User Defined Methods
Converting Fahrenheit to Celsius
Formatting the Output of the Temperature Conversion
Raising an Integer to an Integer Power
Finding the Factorial and Combinations

Week 6

A Bit About Session Variables
Session Variables

Using Time to Demonstrate Session Persistence

Developing Session Level Security for a Website

Week 7

Java Database Connectivity (JDBC)
Four Main JDBC Classes

A User Registration Website
A User Registration Website
Some MySQL Background
Creating the Underlying Tables
The HomePage for the User Registration Site

Week 8

Adding Users
Displaying Users
Deleting Users
Modifying Users

Homework 3

Week 9

The Admin Browser for the User Registration Website

Moving Through the Data

Finding a Record

Deleting a User

Week 10

Adding a User

Modifying a User

Implementing Admin Browser Security

Week 11

Java Beans?

Week 12





Return to Dale R. "Zy" Fox's Courses Page

Return to Dale R. "Zy" Fox's Home Page