Java Reference
In-Depth Information
Discussion
Though DB and friends have their place, most of the modern database action is in relational
databases, and accordingly, Java database action is in JDBC. So the bulk of this chapter is
devoted to JDBC.
I assume that you know a little bit about SQL, the universal language used to control rela-
tional databases. SQL has queries like “SELECT * from userdb,” which means to select all
columns (the *) from all rows (entries) in a database table named
userdb
(all rows are selec-
ted because the SELECT statement has no “where” clause). SQL also has updates like
INSERT, DELETE, CREATE, and DROP. If you need more information on SQL or relation-
al databases, many good books can introduce you to the topic in more detail.
JDBC has two Levels, JDBC 1 and JDBC 2. Level 1 is included in all JDBC implementation
and drivers; Level 2 is optional and requires a Level 2 driver. This chapter concentrates on
common features, primarily Level 1.
