24 Accessing Databases with
JDBC
Objectives
In this chapter you’ll:
■Learn relational database
concepts.
into a JavaFX scene graph via a
SwingNode.
■Use Swing’s JTable and a
TableModel to populate a
JTable with a ResultSet’s
Self-Review Exercise 2
Self-Review Exercise
24.1 Fill in the blanks in each of the following statements:
a) The international standard database language is .
b) A table in a database consists of and .
c) Statement objects return SQL query results as objects.
d) The uniquely identifies each row in a table.
e) SQL keyword is followed by the selection criteria that specify the rows to
select in a query.
f) SQL keywords specify the order in which rows are sorted in a query.
g) Merging rows from multiple database tables is called the tables.
h) A(n) is an organized collection of data.
i) A(n) is a set of columns whose values match the primary-key values of an-
other table.
j) method is used to obtain a Connection to a database.
k) Interface helps manage the connection between a Java program and a database.
l) A(n) object is used to submit a query to a database.
m) Unlike a ResultSet object, and objects are scrollable and updat-
able by default.
n) , a disconnected RowSet, caches the data of a ResultSet in memory.
Exercises
NOTE: Solutions to the programming exercises are located in the ch24solutions folder.
Each exercise has its own folder named ex24_## where ## is a two-digit number representing
the exercise number. For example, Exercise 24.3’s solution is located in the folder ex24_03.
© 2018 Pearson Education, Inc., 330 Hudson Street, NY NY 10013. All rights reserved.