CIS 5930-04 – Spring 2001
Introduction
SQL
Relations
General Relations
SQL Tables
Creating a Table
Column Types
SQL*Plus
Inserting a Row
The SELECT command
Displaying Chosen Columns
Displaying Chosen Rows
A Second Table
Selecting from Multiple Tables
Joins
References Between Tables
Primary Keys and Foreign Keys
Integrity Checks
Other Useful Commands
Conditions
JDBC
A Simple Example
Remarks
Running ShowStudents
Classes in the Example
The Driver Manager
Making a Connection
Database URLs
The Connection Interface
The Statement Interface
The ResultSet Interface
Example: Web Front End to SQL
A First Screen
The SQLConnect servlet
The SQLCommand servlet
Printing the Forms
Handling Queries
Result Set Metadata
The SQLQuery servlet
Generating the Response
Action Statements
Submitting a Command
The Response
An Elementary “3-tier” Application
A Student Database
Creating the Table
Java “Script” to Create Table
Adding the Entries
The Servlets
Selection Page
Overview of Select servlet
Initializing the Session
The DBSession class
Viewing and Modifying Record
Overview of the View servlet
Querying the Database
Updating the Database
Overview of the Update Servlet
Extracting Session Data
Updating the Row
Building an “Undo” Command
An Undo Button
Email: dbc@csit.fsu.edu
Home Page: http://aspen.csit.fsu.edu/it1spring01