In this section, you will learn how to delete data from database.

JPA delete data

     

In this section, you will learn how to delete data from database. You follow the  following steps:

Create a "JPADelete" class file.



Put the following text in "JPADelete.java" file.



JPADelete.java

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

package roseindia;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.EntityTransaction;
import javax.persistence.Persistence;
import javax.persistence.Query;

/**
*
* @author Administrator
*/
public class JPADelete {
public static void main(String arg[]){
EntityManagerFactory emf=Persistence.createEntityManagerFactory("netjpa");
EntityManager em=emf.createEntityManager();
try{
E




					ntityTransaction entr=em.getTransaction();
entr.begin();
Query query=em.createQuery("DELETE FROM Student st WHERE st.id= ?1");
query.setParameter(1, 1);
int deleteRecord=query.executeUpdate();
entr.commit();
System.out.println(deleteRecord+" are deleted.");
}
catch(Exception ex){
System.out.println(ex.getMessage());
}
finally{
em.close();
}
}
}

Run it and get the following output.



Go in MySQL and check it.

Related Tags for JPA delete data:

More Tutorials from this section

• Add Jar in JPA project
• Creating and running the JPA CRUD application
• Creating and running the JPA CRUD application
• Creating files in jpa project
• Developing JPA CURD Application with Eclipse
• JPA read data from database example
• JPA Crud
• Developing JPA CURD Application with NetBeans
• JPA delete data
• JPA delete data
• JPA update data
• JPA update data Example
• JPA delete data
• JPA read data from database example
• JPA update data
• JPA update data
• Select your project and right click on the it
• JPA delete query - EJB
• JPA delete data
• JPA delete data