Article

JDBC demonstration courseware using Servlets and Java Server Pages

Authors:

Suzanne W. Dietrich,

Susan D. Urban,

Ion KyriakidesAuthors Info & Claims

SIGCSE '02: Proceedings of the 33rd SIGCSE technical symposium on Computer science education

Pages 266 - 270

https://doi.org/10.1145/563340.563444

Published: 27 February 2002 Publication History

Get Access

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]

Dietrich, S. W., Understanding Relational Database Query Languages, Prentice Hall, 2001.

Digital Library

Google Scholar

[2]

Dietrich, S. W., Suceava, D., Cherukuri, C. and Urban, S. D. "A Reusable Graphical User Interface for Manipulating Object-Oriented Databases using Java and XML", Proceedings of ACM SIGCSE 2001, Charlotte, North Carolina, February 21-26, 2001, 362-366.

Digital Library

Google Scholar

[3]

Gamma, E., Helm, R., Johnson, R., and Vlissides, V., Design Patterns Elements of Reusable Object-Oriented Software, Addison Wesley, 1995.

Digital Library

Google Scholar

[4]

Hamilton, G., Cattell, R., and Fisher, M. JDBC™ Database Access with Java™ A Tutorial and Annotated Reference, Addison Wesley, 1997.

Digital Library

Google Scholar

[5]

Microsoft Corporation, Open Database Connectivity, http://www.microsoft.com/data/odbc/default.htm

Google Scholar

[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)

Google Scholar

[7]

Sun Microsystems, Inc., Java™ Servlet API Specification, Version 2.2, http://java.sun.com/products/servlet/2.2/

Google Scholar

[8]

Sun Microsystems, Inc., Java Server Pages™ Specification 1.2, http://java.sun.com/products/jsp/

Google Scholar

[9]

Urban, S. D. and Dietrich, S. W., Integrating the Practical Use of a Database Product into a Theoretical Curriculum, Proceedings of the 28th ACM SIGCSE Technical Symposium on Computer Science Education, San Jose, California, February 27 - March 1, 1997, pp. 121-125

Digital Library

Google Scholar

[10]

Urban, S. D. and Dietrich, S. W., "Advanced Database Concepts for Undergraduates: Experience with Teaching a Second Course", Proceedings of ACM SIGCSE 2001, Charlotte, North Carolina, February 21-26, 2001, 357-361.

Digital Library

Google Scholar

[11]

World Wide Web Consortium (W3C)'s XML web page, 2001. http://www.w3.org/XML/

Google Scholar

Cited By

View all

Choi WKim J(2011)Development of the RESTful JPIC SDK for the Application Using Public InformationProceedings of the 2011 IEEE Ninth International Symposium on Parallel and Distributed Processing with Applications Workshops10.1109/ISPAW.2011.78(352-360)Online publication date: 26-May-2011
https://dl.acm.org/doi/10.1109/ISPAW.2011.78
Abidin SAhmad SYafooz W(2010)Towards flexible database conversion with automatic restructuringProceedings of the 14th WSEAS international conference on Computers: part of the 14th WSEAS CSCC multiconference - Volume I10.5555/1981573.1981630(314-319)Online publication date: 23-Jul-2010
https://dl.acm.org/doi/10.5555/1981573.1981630
Holliday MWang J(2009)A multimedia database project and the evolution of the database courseProceedings of the 39th IEEE international conference on Frontiers in education conference10.5555/1733663.1733919(1092-1097)Online publication date: 18-Oct-2009
https://dl.acm.org/doi/10.5555/1733663.1733919
Show More Cited By

JDBC demonstration courseware using Servlets and Java Server Pages
1. Social and professional topics
  1. Professional topics
    1. Computing education
      1. Computing education programs

Recommendations

JDBC demonstration courseware using Servlets and Java Server Pages
Inroads: paving the way towards excellence in computing education

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 ...
Special Edition Using Java Server Pages and Servlets
Jdbc: Database Programming with J2ee with Cdrom

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

SIGCSE '02: Proceedings of the 33rd SIGCSE technical symposium on Computer science education

February 2002

471 pages

ISBN:1581134738

DOI:10.1145/563340

Conference Chairs:
Judith Gersting
University of Hawaii at Hilo
,
Henry M. Walker
Grinnell College
,
Program Chair:
Scott Grissom
Grand Valley State University

ACM SIGCSE Bulletin Volume 34, Issue 1
Inroads: paving the way towards excellence in computing education
March 2002
417 pages
ISSN:0097-8418
DOI:10.1145/563517
Issue’s Table of Contents

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 27 February 2002

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Conference

SIGCSE02

Sponsor:

SIGCSE

SIGCSE02: The 33rd Technical Symposium on Computer Science Education

February 27 - March 3, 2002

Kentucky, Cincinnati

Acceptance Rates

SIGCSE '02 Paper Acceptance Rate 73 of 234 submissions, 31%;

Overall Acceptance Rate 1,595 of 4,542 submissions, 35%

Upcoming Conference

SIGCSE TS 2025

Sponsor:
sigcse

The 56th ACM Technical Symposium on Computer Science Education

February 26 - March 1, 2025

Pittsburgh , PA , USA

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

10
Total Citations
View Citations
1,303
Total Downloads

Downloads (Last 12 months)1
Downloads (Last 6 weeks)0

Reflects downloads up to 30 Dec 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Choi WKim J(2011)Development of the RESTful JPIC SDK for the Application Using Public InformationProceedings of the 2011 IEEE Ninth International Symposium on Parallel and Distributed Processing with Applications Workshops10.1109/ISPAW.2011.78(352-360)Online publication date: 26-May-2011
https://dl.acm.org/doi/10.1109/ISPAW.2011.78
Abidin SAhmad SYafooz W(2010)Towards flexible database conversion with automatic restructuringProceedings of the 14th WSEAS international conference on Computers: part of the 14th WSEAS CSCC multiconference - Volume I10.5555/1981573.1981630(314-319)Online publication date: 23-Jul-2010
https://dl.acm.org/doi/10.5555/1981573.1981630
Holliday MWang J(2009)A multimedia database project and the evolution of the database courseProceedings of the 39th IEEE international conference on Frontiers in education conference10.5555/1733663.1733919(1092-1097)Online publication date: 18-Oct-2009
https://dl.acm.org/doi/10.5555/1733663.1733919
Holliday MWang J(2009)A multimedia database project and the evolution of the database course2009 39th IEEE Frontiers in Education Conference10.1109/FIE.2009.5350687(1-6)Online publication date: Oct-2009
https://doi.org/10.1109/FIE.2009.5350687
Allenstein BYost AWagner PMorrison J(2008)A query simulation system to illustrate database query executionACM SIGCSE Bulletin10.1145/1352322.135230140:1(493-497)Online publication date: 12-Mar-2008
https://dl.acm.org/doi/10.1145/1352322.1352301
Allenstein BYost AWagner PMorrison JDougherty JRodger SFitzgerald SGuzdial M(2008)A query simulation system to illustrate database query executionProceedings of the 39th SIGCSE technical symposium on Computer science education10.1145/1352135.1352301(493-497)Online publication date: 12-Mar-2008
https://dl.acm.org/doi/10.1145/1352135.1352301
Urban SDietrich S(2003)Using UML class diagrams for a comparative analysis of relational, object-oriented, and object-relational database mappingsACM SIGCSE Bulletin10.1145/792548.61192335:1(21-25)Online publication date: 11-Jan-2003
https://dl.acm.org/doi/10.1145/792548.611923
Ramakrishnan SNwosu E(2003)DBMS courseACM SIGCSE Bulletin10.1145/792548.61192235:1(16-20)Online publication date: 11-Jan-2003
https://dl.acm.org/doi/10.1145/792548.611922
Urban SDietrich SGrissom SKnox DJoyce DDann W(2003)Using UML class diagrams for a comparative analysis of relational, object-oriented, and object-relational database mappingsProceedings of the 34th SIGCSE technical symposium on Computer science education10.1145/611892.611923(21-25)Online publication date: 19-Feb-2003
https://dl.acm.org/doi/10.1145/611892.611923
Ramakrishnan SNwosu EGrissom SKnox DJoyce DDann W(2003)DBMS courseProceedings of the 34th SIGCSE technical symposium on Computer science education10.1145/611892.611922(16-20)Online publication date: 19-Feb-2003
https://dl.acm.org/doi/10.1145/611892.611922

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Recommendations

JDBC demonstration courseware using Servlets and Java Server Pages

Special Edition Using Java Server Pages and Servlets

Jdbc: Database Programming with J2ee with Cdrom