In JPA, we can easily insert data into database through entities. The EntityManager provides persist() method to insert records.
JPA Entity Insertion Example
Here, we will insert the record of students.
This example contains the following steps: -
1. Create an entity class named as StudentEntity.java under com.javahubpoint.jpa.student package that contains attributes s_id, s_name, s_age.
StudentEntity.java
package com.javahubpoint.jpa.student;
import javax.persistence.*;
@Entity
@Table(name="student")
public class StudentEntity {
@Id
private int s_id;
private String s_name;
private int s_age;
public StudentEntity(int s_id, String s_name, int s_age) {
super();
this.s_id = s_id;
this.s_name = s_name;
this.s_age = s_age;
}
public StudentEntity() {
super();
}
public int getS_id() {
return s_id;
}
public void setS_id(int s_id) {
this.s_id = s_id;
}
public String getS_name() {
return s_name;
}
public void setS_name(String s_name) {
this.s_name = s_name;
}
public int getS_age() {
return s_age;
}
public void setS_age(int s_age) {
this.s_age = s_age;
}
}
2. Now, map the entity class and other databases configuration in Persistence.xml file.
Persistence.xml
<persistence-unit name="Student_details">
<class>com.javahubpoint.jpa.student.StudentEntity</class>
<properties>
<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/>
<property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/studentdata"/>
<property name="javax.persistence.jdbc.user" value="root"/>
<property name="javax.persistence.jdbc.password" value=""/>
<property name="eclipselink.logging.level" value="SEVERE"/>
<property name="eclipselink.ddl-generation" value="create-or-extend-tables"/>
</properties>
</persistence>
3. Create a persistence class named as PersistStudent.java under com.javahubpoint.jpa.persist package to persist the entity object with data.
PersistStudent.java
package com.javahubpoint.jpa.persist;
import javax.persistence.*;
public class PersistStudent {
public static void main(String args[])
{
EntityManagerFactory emf=Persistence.createEntityManagerFactory("Student_details");
EntityManager em=emf.createEntityManager();
em.getTransaction().begin();
StudentEntity s1=new StudentEntity();
s1.setS_id(101);
s1.setS_name("Gaurav");
s1.setS_age(24);
StudentEntity s2=new StudentEntity();
s2.setS_id(102);
s2.setS_name("Ronit");
s2.setS_age(22);
StudentEntity s3=new StudentEntity();
s3.setS_id(103);
s3.setS_name("Rahul");
s3.setS_age(26);
em.persist(s1);
em.persist(s2);
em.persist(s3);
em.getTransaction().commit();
emf.close();
em.close();
}
}
Output:
After the execution of the program, the student table is generated under MySQL workbench. This table contains the student details. To fetch data, run select * from student query in MySQL.
