| # | Timeline | Topics | Readings | Examples |
| 1. | Week 1 | Installation | install.html | |
| Exercise: Install your personal web site. | ||||
| 2. | Week 1-2 | HTML | Ch. 2 | tutorial |
| Exercise: Design a personal/industry application and collect/display data using URL, Text, Images, Lists, Forms, Tables, Textfields, Buttons, Checkboxes, Radio Buttons, Textareas. | ||||
| 3. | Week 3 | JavaScript | Ch. 19 | HTML/JavaScript->JDBC->MySQL |
| Supplier Data Entry Demo supplier.html | ||||
| Supplier Report Demo report.html | ||||
| SQL2 Demo SQL2.html | ||||
| Exercise: Study JavaScript Types, Variables, Expressions, Statements, Functions, Objects, Arrays. Use JavaScript to check validity of data in your application. | ||||
| 4. | Week 4 | SQL Databases | admin.txt | |
| recreate SuppDB.dd SuppDB.data SuppDB.query | ||||
| Exercise: Study Tables, Keys, DDL, SQL Insert/Update/Delete/Select, MySQL. Design a database for your application, create DDL and insert example data using MySQL. | ||||
| 5. | Week 5 | JDBC | Ch. 15.9 | DataBase.java DataBaseApplet.java |
| Exercise: Study Connection, Statement, Execute, Result Sets, Metadata, JavaScript's API to JDBC. In your application, use JavaScript's API to JDBC to query/update your database and to display data elements and reports in your HTML forms. | ||||
| 6. | Week 6-7 | Applets | Ch. 12, 13 | Applet->JDBC->MySQL |
| Java Widget Documentation | ||||
| Demo 1: Absolute Positioning (No Layout Manager) | ||||
| SQL1 Applet Demo SQL1applet.java SQL1.html | ||||
| Demo 2: GridBagLayout Manager | ||||
| Recipe Planner Demo (Partial) PlannerApplet.java | ||||
| Exercise: Write an Applet which collects and reports on information for your application using combinations of Layout Manager, Textfields, Buttons, Checkboxes, Radio Buttons, Menus, Listboxes, Textareas. | ||||
| 7. | Week 8-9 | CGI Programming in C | Ch. 17, 18 | HTML->C CGI->MySQL |
| SQL4 Demo SQL4.c | ||||
| cgi-util.c include/cgi-util.h Makefile | ||||
| C CGI String Manipulation | ||||
| myccgi.html myprog.c Makefile1 | ||||
| Exercise: Study Forms, Submit Buttons, GET and POST data, API to MySQL. Write a CGI program in C to use GET/POST form input data, to access the database, and to write HTML output reports for your application. | ||||
| 8. | Week 10 | Advanced HTML | Ch. 4, 5 | tutorial |
| Exercise: Modify your application to use Frames, Cascading Style Sheets. | ||||
| 9. | Week 10 | Cookies | Ch. 16.6, 18.12 | Cookie Demo cookie.html |
| Exercise: Study Store/Get cookies using JavaScript, modify your application to track some data via cookies. | ||||
| Exam: Given an application, write HTML, JavaScript, SQL, CGI. | ||||