Java For Dummies, 7th Edition

Chapter 17

Using Java Database Connectivity

IN THIS CHAPTER

Connecting to a database

Inserting values into a database

Making queries to a database

Whenever I teach Java to professional programmers, I always hear the same old thing: “We don’t need to make attractive-looking layouts. No glitzy GUIs for us. We need to access databases. Yup, just [shut up and] show us how to write Java programs that talk to databases.”

So here it is, folks — the real deal!

The Java Database Connectivity^* (JDBC) classes provide common access to most database management systems. Just get a driver for your favorite vendor's system, customize one line of code in each of this chapter's examples, and you're ready to go.

Creating a Database and a Table

The crux of JDBC is contained in two packages: java.sql and javax.sql, which are both in the Java API. This chapter’s examples use the classes in java.sql. The first example is shown in Listing 17-1.

LISTING 17-1: Creating a Database and a Table

import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;public class CreateTable { public static void main(String args[]) { final String CONNECTION = "jdbc:derby:AccountDatabase;create=true"; ...