CMSC424 Fall 2004 - TA's Corner

Homeworks, Quizzes and Exams

• Appeal policy
  The marks will be finalized two weeks after we return your coursework. Therefore, you should launch an appeal within two weeks if you find any error or have any question.

• Statistics for phw01
• Statistics for quiz 1
• Statistics for phw02 with comments (test cases with answers)
• Statistics for midterm
• Statistics for phw03
• Statistics for quiz 2

Information & Hints

• Account information
• Programming hints
• Apache and CGI hints

Examples

• SQL examples
• More SQL examples
  • deferrable constraint
  • create type
  • conditional predicates
  • instead of trigger
  • drop tables
• makefile example
• Shellscript example
• CGI examples (you much read them inside cs domain)
  • query
  • javatime
  • javaargs
  • javaform
  • index (Perl script)
  • source codes (gz file, available outside cs domain)
  • A html file with W3C validation icon (validate script (source), Validator.java)
• PHW03(Fall 2003) Sample

• Oracle Pro*C/C++ example
• Oracle JDBC example
• Oracle JDBC2 example (using DataSource) (requires classes12.zip)

• PostgreSQL C example
• PostgreSQL C++ example
• PostgreSQL JDBC example (requires pg73jdbc3.jar)
• PostgreSQL JDBC2 example (using DataSource) (requires pg73jdbc3.jar)

Useful Links

• Java^TM 2 SDK, Standard Edition Documentation
  • JDBC^TM API Documentation
• The Apache HTTP Server Project
  • Configuration Files
• W3C MarkUp Validation Service

• PostgreSQL
  • PostgreSQL 7.3 Documentation
  • libpq - C Library
  • libpq++ - C++ Binding Library
  • JDBC Interface
  • Connection Pools And DataSources

• Oracle
  • Oracle8 SQL Reference Release 8.0
  • SQL*Plus Quick Reference
  • Pro*C/C++ Precompiler Programmer's Guide
  • Oracle8 JDBC Drivers
  • Using Java (JDBC) To Work with LOBs
  • Oracle8i JDBC Developer's Guide and Reference - Data Sources