Java How to Program, Early Objects, 11th Edition

29.3 Querying a Database with JPA

In this section, we demonstrate how to create the books database’s JPA entity classes, then use JPA and those classes to connect to the books database, query it and display the results of the query. As you’ll see, NetBeans provides tools that simplify accessing data via JPA.

This section’s example performs a simple query that retrieves the books database’s Authors table. We then use lambdas and streams to display the table’s contents. The steps you’ll perform are:

• Create a Java DB database and populate it from the books.sql file provided with this chapter’s examples.

• Create the Java project.

• Add the JPA reference implementation’s libraries to the project.

• Add the Java DB library to the project so that the ...