Using JDBC to Create Database Objects
By James W. Cooper2003-05-24
What Is JDBC?
|
|
JDBC is a set of initials that once stood for "Java DataBase Connectivity," but it is now a trademarked symbol on its own. It is an object-oriented wrapping and redesign of ODBC API that is much easier to learn and to use and that really does allow you both to write vendor-independent code to query and to manipulate databases. While it is object-oriented, as all Java APIs must be, it is not a very high level set of objects, and we will be developing some higher-level approaches in the course of the remainder of this chapter.
Most database vendors other than Microsoft have embraced JDBC and provide JDBC drivers for their databases; this makes it quite easy for you to really write almost completely database-independent code. In addition, JavaSoft and Intersolv have developed a product called the JDBC-ODBC Bridge, which allows you to connect to databases for which no direct JDBC driver yet exists. All of the databases which support JDBC must at a minimum support the SQL-92 standard. This makes for a great degree of portability across databases and platforms.
Tutorial Pages:
» What is a Database?
» Getting Data out of Databases
» Kinds of Databases
» ODBC
» What Is JDBC?
» Installing and Using JDBC
» Types of JDBC Drivers
» Two-Tier and Three-Tier Models
» Writing JDBC Code to Access Databases
» Registering Your Database with ODBC
» Connecting to a Database
» Accessing the Database
» The ResultSet
» ResultSetMetaData
» DatabaseMetaData
» Getting Information on Tables
» Executing SQL Queries, Printing out ResultSets, A Simple JDBC Program
» Building Higher Level JDBC Objects
» Building a Database Object, A Visual Database Program
» Executing a Query
» The Query Result Dialog
» Example Files
» Summary
First published by IBM DeveloperWorks
|
