Java Reference
In-Depth Information
JDBC
According to most authorities, JDBC stands for “Java Database Connectivity.” It allows
you to insert SQL commands in your Java code. In order to use Java's JDBC you need to
have JDBC and a database system compatible with JDBC installed. JDBC is available
from Sun. Various Microsoft and Oracle database systems are among the many commer-
cially available database systems that are compatible with JDBC. Typically, you need to
download and install a JDBC driver for your database system.
Conceptually JDBC is simple: You establish a connection to a database system
(either on your computer or over the Internet) and execute SQL commands, and you
do this all within your Java code. The details are not trivial, but hopefully you now
know enough about JDBC to know whether you wish to study it further.
Display 19.7
Relational Database Tables
Names
AUTHOR
AUTHOR_ID
URL
Adams, Douglas
1
http:// ...
Simmons, Dan
2
http:// ...
Stephenson, Neal
3
http:// ...
Titles
TITLE
ISBN
Snow Crash
0-553-38095-8
Endymion
0-553-57294-6
The Hitchhiker's Guide to the
0-671-46149-4
Galaxy
The Rise of Endymion
0-553-57298-9
BooksAuthors
ISBN
AUTHOR_ID
0-553-38095-8
3
0-553-57294-6
2
0-671-46149-4
1
0-553-57298-9
2
