COSC 2206 - Internet Tools
Instructor: R. S. Grewal, F380A

Prerequisites

  1. Only computer science and E-Business students are eligible.
  2. Completion of first year of computer science program (COSC 1046/1047)
  3. Knowledge of basic HTML is useful
  4. You must have your own PC running Win XP Professional

Recommended Textbook

The following book is useful as a reference but is not required.

Internet & World Wide Web, How to Program, Third Edition
Deitel et al
Prentice-Hall, 2004

Course Outline

A primary goal of this course is to show you how to set up a PC as a server for developing web software which is then uploaded to a production web server (unix). The emphasis is on server-side programming and database connectivity.
  1. Overview of Course
  2. Installation of Java SDK 1.4.2 (you should already have it)
  3. Review of HTML
  4. HTML tables and forms
  5. XHTML
  6. Cascading Style Sheets CSS
  7. Installing and configuring Apache 1.3.29 web server for Win XP
  8. Testing the Apache installation using HTML
  9. Uploading web site from development server (your PC) to course server (itools on Unix)
  10. Installing and configuring PHP as an Apache module on Win XP
  11. Testing the PHP installation with some simple PHP scripts
  12. Client/Server HTTP protocol
  13. The PHP programming language
  14. Using PHP for simple web programming (no databases)
  15. Overview of SQL
  16. Installation and configuration of the MySQL relational database server
  17. Using the MySql command line client
  18. Installing and configuring the MyCC GUI client for MySql
  19. Using PHP to develop web database interfaces to MySQL
  20. Installation and configuration of the Tomcat web server (Java servlet container)
  21. Testing tomcat installation with simple servlets and JSP
  22. Installing the JDBC driver for MySql on Win XP
  23. Testing the JDBC driver
  24. Using JDBC to connect Java programs with MySQL databases
  25. Java Servlets
  26. Java servlets using JDBC to connect to MySql
  27. Java Server Pages (JSP)
Assignments Project presentation schedule
-->

Course Organization

Everyone will be given an account on itools.cs.laurentian.ca, the course web and server and database server(Unix), and a database on the MySql server.
  1. Project: 50%
  2. Assignments, labs, class participation: 50%
Your portfolio, assignments and project, must be submitted on or before the last class of Week 11.

Final Portfolio Submission

Submit it in a 3 ring binder in the following format:

Software Installation Guides

A CD is available from the department containing all software and installation guides. These guides are also given here to reflect corrections if necessary.
Java SDK 1.4.2 and Documentation
Apache 1.3.29
PHP 4.3.8
MySQL 4.0.16 and MyCC
Tomcat 5.0.25
JDBC driver for MySQL

Notes, slides, examples, scripts

HTML

HTML review and examples
Online slides (ppt)
Online slides (pdf)
Zip file of everything

CSS

CSS review and examples
Online slides (ppt)
Online slides (pdf)
Zip file of everything

JavaScript

Javascript review and examples
Core javascript slides (ppt)
Core javascript slides (pdf)
Client side javascript slides (ppt)
Client side javascript slides (pdf)
Zip file of everything

MySql

MySql slides (ppt)
MySql slides (pdf)
Zip file of everything

HTTP

HTTP-CGI slides (ppt)
HTTP-CGI slides (pdf)
Zip file of everything 		 

PHP slides (language, webapps, mysql, bookstore)

download zip file of ppt slides, pdf slides and scripts

PHP in htdocs (latest version of php scripts)

Zip file for php folder in htdocs

common database connection script

db_connect.php.txt. Put this script in your includes directory as specified in php.ini and change the user name and password to your own values. Aslo rename the file from db_connect.php.txt to db_connect.php.

Java servlets (part 1, simple examples)

servlets1.ppt (powerpoint slides)
servlets1.pdf (pdf version)

Java servlets (part 2, cookies and sessions)

servlets2.ppt (powerpoint slides)
servlets2.pdf (pdf version)

JDBC with MySql

jdbc.ppt (powerpoint slides)
jdbc.pdf (pdf version)

JSP (Java Server Pages)

jsp.ppt (powerpoint slides)
jsp.pdf (pdf version)

War file for test application

test.war

Put this file in your webapps directory and restart tomcat. Then your will have a directory called test that is developed in the tomcat install instructions and the jdbc install instructions. Now remove the test.war file from your webapps directory.

War file for c2206 application

c2206.war

Put this file in your webapps directory and restart tomcat. Then your will have a directory called c2206 inside your webapps that is our course web application. Now remove the c2206.war file from your webapps directory.

War file for Sun's bookstore application

bookstore.war

A demonstration of a bookstore/shopping cart application using a session to store the shopping cart. It's not a real database application (uses internal book data) but it does illustrate some important ideas.