JPA

The JPA interface allows for easy manipulation of relational databases or persistence data.

JPQL is the query language used in JPA to interact with JPA entity objects. It doesn't interact directly with database tables.

Entity class

Create an entity class for the database table that we wil be interacting with through Java code:

Select and add the desired table:

Specify or create a package for the entity class:

And finish. This will create the entity class Productssearches.java.

Session bean

To interact with the database we need to create a session bean:

Select and add the target entity class:

And finish. Two classes will be created: AbstractFacade.java and ProductssearchesFacade.java.