JDBC demonstration courseware using Servlets and Java Server Pages

ABSTRACT

This paper describes the design and functionality of courseware developed to demonstrate the JDBC API. The courseware is used in an advanced undergraduate database course that emphasizes the use of Web access to database systems. The JDBC courseware is written using Java Servlets and Java Server Pages, allowing the user to view the metadata associated with a database, to view and browse the information in a database according to the database metadata, and to query and/or manipulate data using SQL statements. The advantage of the courseware is that it demonstrates the main functionality of the JDBC API in an application-independent manner. The courseware can access any ODBC-compliant database, emphasizing the generality of the JDBC API and helping students understand how JDBC can be used to query the metadata of the database as well as the database contents.

REFERENCES

• 1: Suzanne Wagner Dietrich, Understanding Relational Database Query Languages, Prentice Hall Professional Technical Reference, 2001
• 2: Suzanne W. Dietrich , Dan Suceava , Chakrapani Cherukuri , Susan D. Urban, A reusable graphical user interface for manipulating object-oriented databases using Java and XML, Proceedings of the thirty-second SIGCSE technical symposium on Computer Science Education, p.362-366, February 2001, Charlotte, North Carolina, United States
• 3: Erich Gamma , Richard Helm , Ralph Johnson , John Vlissides, Design patterns: elements of reusable object-oriented software, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1995
• 4: Graham Hamilton , Rick Cattell , Maydene Fisher, Jdbc Database Access with Java: A Tutorial and Annotated Reference, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1997
• 5: Microsoft Corporation, Open Database Connectivity, http://www.microsoft.com/data/odbc/default.htm
• 6: Sun Microsystems, Inc., JDBC™ Data Access API, http://java.sun.com/products/jdbc/ (for java.sql package summary see http://java.sun.com/j2se/1.4/docs/api/java/sql/package-summary.html)
• 7: Sun Microsystems, Inc., Java™ Servlet API Specification, Version 2.2, http://java.sun.com/products/servlet/2.2/
• 8: Sun Microsystems, Inc., Java Server Pages™ Specification 1.2, http://java.sun.com/products/jsp/
• 9: Susan D. Urban , Suzanne W. Dietrich, Integrating the practical use of a database product into a theoretical curriculum, Proceedings of the twenty-eighth SIGCSE technical symposium on Computer science education, p.121-125, February 27-March 01, 1997, San Jose, California, United States
• 10: Susan D. Urban , Suzanne W. Dietrich, Advanced database concepts for undergraduates: experience with teaching a second course, Proceedings of the thirty-second SIGCSE technical symposium on Computer Science Education, p.357-361, February 2001, Charlotte, North Carolina, United States
• 11: World Wide Web Consortium (W3C)'s XML web page, 2001. http://www.w3.org/XML/