About This Short Course
The Sun Developer Network presents a Short Course on JDBC technology written by jGuru (formerly named the MageLang Institute).
jGuru has been a regular contributor to the JDC since 1996 and is dedicated to promoting the growth of the Java technology community through evangelism, education, and software. You can find out more about their activities, including community-driven FAQs and online learning, at jGuru.com.
Please send comments about the course to email@example.com.
This module introduces the fundamental concepts of JDBC and gives you a working knowledge of the major elements of the core JDBC 2.0 API. The course is standards-based and uses best practices to demonstrate How-Tos useful to the field developer.
After completing this module you will understand:
By the end of this module you will be able to:
A familiarity with object-oriented programming concepts in general and the Java programming language in particular is expected. If you are not familiar with these capabilities, see:
The exercises in the JDBC tutorial require you to understand, modify, and build Java programs at approximately the intermediate level, although complete solutions are always given. In addition, the reader should have at least a minimal understanding of Relational Database Management Systems (RDBMS) and Structured Query Language (SQL). The SQL Primer and Resources sections of the Appendices contain information, links, and book references to help provide this background.
Cloudscape, a 100% Pure Java SQL DBMS available in the Java 2 Platform, Enterprise Edition (J2EE) download, is used to support most of the exercises in the course. With minor modifications, the exercises run against any database with a JDBC Compliant driver. If you do not have a readily available DBMS, please see the Appendices topics Cloudscape Installation and Setup and Starting and Stopping Cloudscape.
JDBC is one of the few areas of the Java programming language that depends on external implementations and vendor-specific products. While the course focuses on standard JDBC, this is a fact of life that cannot be escaped. For that reason, you will occasionally notice comments directed towards a particular DBMS used in the discussion. These will generally be prefaced with the following symbols:
This is Cloudscape specific information.
This information is specific to IBM's DB2. In the course:
Cloudscape is a trademark of Informix. DB2 is a trademark of IBM.
Use or non-use of a particular DMBS, tool, or product in this course does not imply any sort of recommendation for or denigration of the particular product. For further information on the database choices made for this course, read Searching for a Database, Autumn, 2000 at jGuru.
About the Author
Joe Sam Shirah is the owner of Autumn Software and a principal at conceptGO, both of which provide consulting, development, outsourcing, training, testing, and other services as well as software products. Joe Sam is a past recipient of the Java Community Award, and has been the jGuru manager for the JDBC, Internationalization, and Java400 FAQs.
Special thanks to Java guru John Zukowski for editing the course, contributing the SQL Primer section, and providing the JSP-related portions of the Using JDBC with JavaServer Pages topic.
Start the Short Course
Copyright 1996-2000 jGuru.com. All Rights Reserved.
Have a question about programming? Use Java Online Support.
Oracle is reviewing the Sun product roadmap and will provide guidance to customers in accordance with Oracle's standard product communication policies. Any resulting features and timing of release of such features as determined by Oracle's review of roadmaps, are at the sole discretion of Oracle. All product roadmap information, whether communicated by Sun Microsystems or by Oracle, does not represent a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. It is intended for information purposes only, and may not be incorporated into any contract.