| Lecture Number | Date | Topic | Notes |
|---|---|---|---|
| 01 | 9/24/09, Th | Class Overview; DB Connectivity |
notes01-intro.ppt, notes02-odbc.ppt |
| 02 | 9/29/09, Tu | JDBC Tuning | notes03-jdbc-tuning.ppt |
| 03 | 10/1/09, Th | Web-app Architectures | notes04-webapp.ppt, Project 2 |
| 04 | 10/6/09, Tu | Java Servlets and Session Handling | java-servlets-session.pdf, java-servlets-session.ppt |
| 05 | 10/8/09, Th | Discussion about project 2 | Open a Window using Javascript; Connection Pooling; MySQL Connection Pooling Configuration |
| 06 | 10/15/09, Th | In-class quiz 1 | |
| 07 | 10/20/09, Tu | Ruby on Rails | RoR Getting Started |
| 08 | 10/22/09, Th | Ruby on Rails and Project 3 | Project 3 |
| 09 | 10/27/09, Tu | A tutorial of Ruby on Rails | Using RoR to build a forum |
| 10/11 | 10/29/09, Th and 11/3/09, Tu | Additional discussion of the RoR Forum tutorial, user authentication | Authentication and Session Handling |
| 12 | 11/5/09, Th | Project 4, Extending SQL Functionality and User Management |
Stored
Procedures and Functions in MySQL (5.1). notes05-extend-db.ppt. |
| 13 | 11/10/09, Tu | Project 4 extra credits; User Management | Edit Distance; MySQL User Management; Syntax of Account Management Statements. |
| 14 | 11/12/09, Th | DBA, User Management | notes06-users.ppt. |
| 15 | 11/19/09, Th | XML, Project 5 (Part 1) | notes07-xml.ppt. |
| For any problems, questions or suggestions about this page, please contact cs122b-help + AT + ics.uci.edu. | rev. Thursday, November 19, 2009 - 12:05:30 |