Instructor: Professor William J. Wolfe
wwolfe@cse.cudenver.edu
(303) 556-4314 (appointments)
(303) 556-2358 (messages)
CLASS RECORD (please check for accuracy)
Texts: (Check with the campus bookstore for the exact titles of each of these texts)
1. OPTIONAL: The Practice of Programming by Brian W. Kernighan and Rob Pike
2. OPTIONAL: Writing Solid Code by Steve Maguire
3. REQUIRED: The Mythical Man-Month
4. REQUIRED: Software Project Survival Guide by S. McConnell
5. REQUIRED: HTML 4 (SEE BOOKSTORE FOR COMPLETE REFERENCE)
6. REQUIRED: WEB ENGINEERING (SEE BOOKSTORE FOR COMPLETE REFERENCE)
|
|
|
|
|
| 1 | read preface, and chapters 1 & 2 in The Practice of Programming | nothing |
|
| 2 | read chapters 3 & 4 (TPP) | nothing |
|
| 3 | read chapters 5 & 6 (TPP) | nothing |
|
| 4 |
read chapters 1 - 8 of Software Project Survival Guide Identify a Project Idea** |
hand in: "Requirements/Prototype Document" on Sept. 21, 1999 |
|
| 5 | read chapter 9 (SWPSG) | hand in: "QA Plan" on Sept. 28, 1999 |
|
| 6 | read chatper 10 (SWPSG) | hand in: "Software Architecture Document" on Oct 12, 1999. |
|
| 7 | read chapter 11 (SWPSG) | hand in: "Project Schedule" on Oct 19, 1999. |
|
| 8-16 |
read chapters 12 - 17 (SWPSG) detailed design, construct code, test, stage 1 release, stage 2 release, design reviews. |
|
|
**Project Guidelines:
A web page development project that includes access to a live database.
A working example of such a project can be found at the Impulse Preferred Travel site.
1. Rollover Images: a javascript example that toggles between 2 images when the mouse is over/out of the image.
Notes:
a. view the source code with your browser to get a copy of the HTML/JavaScript.
b. if you copy the code you will have to provide the path to your own images etc.
c. it worked in Netscape (3.0) but it did not work in Internet Explorer 3.0. I am hoping, but have not tested, it will work in the most recent versions of these browsers (versions 4.x or higher).
d. notice that the images are preloaded (cached) so the rollover should be relatively fast.
2. CGI example (using compiled C++), gets the value of "environment" variables and puts them in an HTML page --- courtesy of Paul Bille.
Paul's csc4508 web site provides the source code (C++) as well. Note: this links you to the page that Paul created for this class, so it contains several things of interest ---- so scroll down for the "getenv.cgi" stuff. Also: While there, take the time to Register*, so that we have an up to date list of class members (I am going to ask Paul to include a field for registering your project name, and group members).
*Note: Students are not required to register, nor should they divulge any private information.
3. ASP/sql Example: shows how ASP code (vbScript) uses server objects to open a connection to a sql-server database. Also shows how to submit a query and use the results.
4. About Agents: a link to the course notes I made up for a graduate course on the topic. Includes some interesting Java examples (see: assignments) for building a web crawler (the java code is slightly out of date, but not too hard to upgrade).
5. CGI Example (using Perl): This example comes from the code written by Dr. Jody Paul for the CS Department Web pages. It shows how a Perl program (csepage.cgi) can use the CGI protocol to access other files while constructing an HTML page as output. When executed it looks in the "environment variables" to set the value of "whichpage" and uses that to create the appropriate HTML page for output to the Browser. It reads in various files that have sections of HTML code that are placed in different locations in the outgoing HTML page. For example, the Perl program opens and reads in a file called "UCDBanner" and then uses it to construct the appearance of the top of the page. Notice that "UCDBanner" is just a section of HTML code (and not a page by itself).
6. Access to Oracle on Carbon:
a. after logging onto Carbon, enter:
setenv PATH ${PATH}:$ORACLE_HOME/bin
b. then enter:
sqlplus
this prompts you for a username and password
username: CSC45081 (????????)
password: SS# (????????)
if you get passed this then you are "in" Oracle.
7. Access to Oracle from a Perl program:
....... (Perl Program)...
USE DBI # This is the "data base interface" (assumed to be loaded with Perl)
$dbname = 'your_database_name';
$user = 'your_oracle_username';
$password = 'your_oracle_password';
$dbd = 'Oracle'; # This is the "data base driver" for Oracle (assumed to be
# loaded on Carbon)
$dbh = DBI->connect($dbname, $user, $password, $dbd);
$dbh ->do ........
# Now you start using sql commands such as CREATE
# TABLE, SELECT etc.
8. Rick Osborne provided an example of a perl program that accesses Oracle -- it is a great turorial except that it "hangs" at the "disconnect" step (the CINS people are looking into this). If you copy the code you can run it from the Unix shell (from the usual prompt) and you will see it access Oracle, create and modify a table, and then attempt to disconnect, at which time it will hang -- you then need to "kill" the process (to kill the process enter ps, and get the number of the process, and then kill that number etc).
Testing Javascript for Rollover Images