JPA and Hibernate - Fetch Data using JPQL

 package edu.raj.learn;

import java.util.List;

import jakarta.persistence.EntityManager;

import jakarta.persistence.EntityManagerFactory;

import jakarta.persistence.Persistence;

public class FetchData {

public static void main(String[] args) {

// Create EntityManagerFactory and EntityManager

EntityManagerFactory emf = Persistence.createEntityManagerFactory("my-pu");

EntityManager em = emf.createEntityManager();

// Start a transaction

em.getTransaction().begin();

// JPQL query to fetch all Employee entities

String jpql = "SELECT e FROM Employee e";

List<Employee> employees = em.createQuery(jpql, Employee.class).getResultList();

// Print the list of employees

for (Employee emp : employees) {

System.out.println(emp.getName() + " - " + emp.getDepartment());

}

// Commit transaction

em.getTransaction().commit();

// Close the EntityManager

em.close();

emf.close();

}

}