Java Hibernate Cookbook

Removing an object from the database

Now, we take a look at how to remove a record from the database.

How to do it…

Here, we are trying to remove an employee object having id equals 1.

The SQL query executed to achieve the same result is as follows:

DELETE FROM employee WHERE id=1;

Now, let's take a look at how to do the same using hibernate.

Code

Enter the following code to delete an object of the employee type, where id is 1:

SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
Session session = sessionFactory.openSession();

session.getTransaction().begin();
Employee employee = (Employee) session.get(Employee.class, new Long(1));
session.delete(employee);
session.getTransaction().commit();

session.close(); 
HibernateUtil.shutdown();