O'Reilly logo

Java For Dummies, 7th Edition by Barry A. Burd

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 17

Using Java Database Connectivity

IN THIS CHAPTER

check Connecting to a database

check Inserting values into a database

check 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"; ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required