Using JDBC to Create Database Objects

By James W. Cooper
2003-05-24

Two-Tier and Three-Tier Models

When the database and the application which interrogates it are on the same machine and there is no server code interposed, we refer to the resulting program as a two-tier model. One tier is the application and the other is the database. This is usually the case in JDBC-ODBC bridge systems.

When there is an application or applet that calls a server that in turn calls the database, we call this a three-tier model. This is usually the case when there is a program called a "server" that you make your calls to.

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