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"; ...
Get Java For Dummies, 7th Edition now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.