Using JDBC to Create Database Objects

By James W. Cooper
2003-05-24

Connecting to a Database

All of the database objects and methods are in the java.sql package, and you must import java.sql.* into any programs that use JDBC. To connect to an ODBC database, you must first load the JDBC-ODBC bridge driver



Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");



String url = "jdbc:odbc:Grocery prices";

Connection con   = DriverManager.getConnection(url);



jdbc:subprotocol:subname



jdbc:bark//doggie/elliott



jdbc:bark//doggie/elliot;UID=GoodDog;PWD=woof

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

Related Tutorials:
» All about JAXP, Part 1
» Make Database Queries Without the Database
» Load List Values for Improved Efficiency
» 2 Ways To Implement Session Tracking
» A Simple Way to Read an XML File in Java
» Develop Aspect-Oriented Java Applications with Eclipse and AJDT