You are here: Home / Topics / How to get Database data using Hibernate? Explained by Impl class

How to get Database data using Hibernate? Explained by Impl class

Filed under: Java on 2024-03-11 21:27:10

Before viewing this example. Go and learn  (Hibernate Configuration using java file)

package com.mysite.firstJavaDbApp.serviceImpl;

import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

import com.mysite.firstJavaDbApp.beans.Employee;
import com.mysite.firstJavaDbApp.config.HibernateDbConfig;
import com.mysite.firstJavaDbApp.service.HibernateEmployeeService;

public class HibernateEmployeeServiceImpl implements HibernateEmployeeService {

private SessionFactory sessionFactory;

public HibernateEmployeeServiceImpl() {
 sessionFactory = HibernateDbConfig.getInstance().getSessionFactory();
}

@Override
public Boolean saveEmployee(Employee employee) {
 Session session = sessionFactory.openSession();
 Transaction tx = session.beginTransaction();
 try {
  session.persist(employee);
  tx.commit();
  return true;
 } catch (Exception e) {
  e.printStackTrace();
 }

 return false;
}

@Override
public Employee getEmployeeById(Long employeeId) {
 Session session = sessionFactory.openSession();
 Transaction tx = session.beginTransaction();
 Employee emp = null;
 try {
  emp = session.find(Employee.class, employeeId);
 } catch (Exception e) {
  e.printStackTrace();
 }
 return emp;
}

@Override
public List<Employee> getAllEmployees() {
 String query = "select * from employee";
 Session session = sessionFactory.openSession();
 Transaction tx = session.beginTransaction();
 List<Employee> employees = session.createNativeQuery(query, Employee.class).getResultList();
 return employees;
}

}
 

About Author:
J
Java Developer     View Profile
Hi, I am using MCQ Buddy. I love to share content on this website.