Java How to Program, Early Objects, 11th Edition

24 Accessing Databases with JDBC

Objectives

In this chapter you’ll:

• Learn relational database concepts.

• Use Structured Query Language (SQL) to retrieve data from and manipulate data in a database.

• Use the JDBC™ API’s classes and interfaces to manipulate databases.

• Use JDBC’s automatic JDBC driver discovery.

• Embed a Swing GUI control into a JavaFX scene graph via a SwingNode.

• Use Swing’s JTable and a TableModel to populate a JTable with a ResultSet’s data.

• Sort and filter a JTable’s contents.

• Use the RowSet interface from package javax.sql to simplify connecting to and interacting with databases.

• Create precompiled SQL statements with parameters via PreparedStatements.

• Learn how transaction processing makes database applications ...