CS500                                         Java Program and Web Design Review
Summer I, 2007

1.  Web Programming with CGI/Perl
a) HTTP and CGI basics
b) CGI Programming with Perl:
     - Forms and CGI
     - Validate inputs with JavaScript
     - CGI.pm
c) Advanced CGI Programming with Perl:
     - Sending email using sendmail
     - Data Persistence using Text files
     - Maintaining State (Query Strings and Extra Path Info/Hidden Fields/Client-side Cookies)
     - Search the Web server
d) Web Security basics

2.  Web Programming with PHP & MySQL
a) PHP programming basics
b) MySQL basics
c) Web Database application with PHP and MySQL:
     - Web GUI pages with PHP Scripts
     - Querying MySQL database using PHP
     - Insert/Delete/Update MySQL database using PHP
     - PHP session management
     - Form-Based Authentication using PHP
     - Reporting using PHP

3. Java Programming
a) Java Application and Java Applet
b) Java GUI components (JLabel, JTextfields, JButton, JCheckBox, JRadioButton,
JList, JTextArea, JTable, JPanel, JTabbedPane)
c) Java TCP/IP programming
d) Java JDBC
e) Client/Server computing using Java TCP/IP sockets and JDBC database access
- Establishing a Java Application Server using Stream ServerSocket and Socket
- Establishing a JDBC connection from the Java Application Server to the MySQL database
- Establishing a Java Application GUI Client using Stream Socket
- Client-Application Server communication using TCP connection-oriented service.
- Application Server-MySQL communication using JDBC