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();

Output

The output will be as follows:

Hibernate: select employee0_.id as id0_1_, employee0_.department as department0_1_, employee0_.firstName as firstName0_1_, employee0_.salary as salary0_1_, department1_.id as id1_0_, department1_.deptName as deptName1_0_...