CNT 4714 Code Examples

Note: Before the following will execute you will need to run keytool to set up a keystore and certificate for the SSL
Also, these two classes are in package: securitystuff/jsse.

SSL Server Class - page 100

SSL Client Class - page 103

A multi-threaded,networked client/server example

Multithreaded TicTacToe Server

Test Class for TicTacToe Server

Client side for client/server TicTacToe

Test Class for TicTacToe Client

JDBC

SQL script for creating the bike database used in many of the MySQL and JDBC Examples

Simple JDBC Example - page 20

DisplayBikes Application - page 27

ResultSetTableModel class - page 33

DisplayQueryResults Application - page 40

Displaying database information using PreparedStatement - page 52

JDBC RowSet example - page 62

SERVLETS
Part 1: NOTE: You need to create this entire webapp from scratch using the lecture notes as a basis.

Part 2:

NOTE: All of these files are assumed to be part of a web application named "CNT4714".

index.html - "home page" for servlets

web.xml configuration file for CNT4714 webapp

User Friendly Welcome Servlet (welcome2) - HTML file

User Friendly Welcome Servlet - Java file

Welcome Servlet Using a Post Method (welcome3) - HTML file

Welcome Servlet Using a Post Method - Java file

Current Date/Time Servlet - Java file

ReDirection Servlet - HTML file

ReDirection Servlet - Java file

RepeatVisitor: Cookie Demonstration Servlet - HTML file

RepeatVisitor Servlet - Java file

CookieTest: Session and Persistent Cookie Demonstration Servlet - HTML file

CookieTest Servlet - Java file

CookieUtilities class is used by ClientAccessCounts class below - Java file

ClientAccessCounts Servlet - Java file (this one is not accessible from the index page - execute it directly with http://localhost:8080/CNT4714/cookieaccess)

ShowSession: Session Cookie Demonstration Servlet - HTML file

ShowSession Servlet - Java file

Part 3:

Servlet that returns an Excel spreadsheet - Java file

ImageContent: Servlet that returns both images and text - HTML file ***be sure to set the files properly for this to work!

ImageContent Servlet - Java file

Image of Eddy Merckx bike for ImageContent servlet

Image of Sprint Kart for ImageContent servlet

Color Survey MySQL Script

Color Survey (3-tier application) - HTML file

Survey Servlet - Java file

JSP
Part 1:

Loan.java (required for ComputeLoan2.jsp)

Part 2:

Be sure to set up the proper directory structure for the packages in these examples. See the notes for details.

picturerotator.jsp

Rotator JavaBean File

SQL Script to create guestbook database

GuestBean.java JavaBean File

GuestDataBean.java JavaBean File

guestBookLogin.jsp

guestBookView.jsp

guestBookErrorPage.jsp

PHP
NOTE: All of these file should be loaded into your htdocs folder in your Apache server.

Images for use with the form.html application and others - (rename to "images" and locate in htdocs directory) - image1.jpg is the background image - put in htdocs

Basic php script with function call

Basic php script without function call

Displays PHP server variable values - change it around to display other superglobal values

Client side form

Server side php script for handling the form

Expression.php for regular expression test

Client side secure entry screen

Server side php script to handle password

Client side data entry for database query

Server side php script to handle database access (NOTE: rename/resave with .php extension only)

Client side form to enter cookie values

Server side php script to handle the cookie

Server side php script to read cookie values

SQL script to create mailinglist DB

Client side database entry form

Server side php script to access database

Last updated: July 15, 2014 Return to CNT 4714 home page