Web Databases Using JSP and MySQL




Dale R. "Zai" Fox


Office Hours: 2:00 - 2:50 PM Monday, Wednesday
5:30 - 6:30 PM Wednesday, Thursday
or by appointment






Turner, MySQL and JSP Web Applications, SAMS.

General Content:

The first part of the course will focus on some of the Java background you should have in order to work with JSPs.

The primary focus of the course will be on Servlets and JSPs as middleware for web database application development.  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

Some Java Background to Prepare for JSP

Week 2

Some More Java Background to Prepare for JSP

Week 3

Making Use of jasperations.net

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

Week 4

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 5

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 6

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 7

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 8

A Bit About Session Variables
Session Variables

Using Time to Demonstrate Session Persistence

Developing Session Level Security for a Website

Week 9

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 10

Adding Users
Displaying Users
Deleting Users
Modifying Users

Homework 3

Week 11

The Admin Browser for the User Registration Website

Moving Through the Data

Finding a Record

Deleting a User

Week 12

Adding a User

Modifying a User

Implementing Admin Browser Security

Homework 4

Week 13


Week 14





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

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