Wednesday 18 January 2023

Multiple data enter into database using hibernate

Employee.java

package dataent;

public class Employee {  
private int id;  
private String firstName,lastName;  
 
public int getId() {  
   return id;  
}  
public void setId(int id) {  
   this.id = id;  
}  
public String getFirstName() {  
   return firstName;  
}  
public void setFirstName(String firstName) {  
   this.firstName = firstName;  
}  
public String getLastName() {  
   return lastName;  
}  
public void setLastName(String lastName) {  
   this.lastName = lastName;  
}  
 
 
}  


StoreData.java


package dataent;

import java.util.Scanner;
import org.hibernate.Session;  
import org.hibernate.SessionFactory;  
import org.hibernate.Transaction;  
import org.hibernate.cfg.Configuration;  
  
public class StoreData {  
public static void main(String[] args) 
{
        
    Configuration cfg=new Configuration();  
    cfg.configure("hibernate.cfg.xml");
      
    
    SessionFactory factory=cfg.buildSessionFactory();  
      
    
    Session session=factory.openSession();  
      
    Transaction t=null;
     
     int i; 
     Employee e1=new Employee();
    
    for(i=1;i<=10;i++)
    {
    t=session.beginTransaction(); 
    e1=new Employee();
        e1.setId(i);
        System.out.println("Enter first name");
        Scanner sc=new Scanner(System.in);
        String fn=sc.next();
        System.out.println("Enter last name");
        Scanner sc1=new Scanner(System.in);
        String ln=sc1.next();
        e1.setFirstName(fn);  
        e1.setLastName(ln);
        

        session.persist(e1);
        t.commit();         
    }
    session.close();  
      
    System.out.println("successfully saved");  
      
}  
}  


employee.hbm.xml


<?xml version='1.0' encoding='UTF-8'?>  
<!DOCTYPE hibernate-mapping PUBLIC  
 "-//Hibernate/Hibernate Mapping DTD 3.0//EN"  
 "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">  
  
 <hibernate-mapping>  
  <class name="dataent.Employee" table="data1000">  
    <id name="id">  
     <generator class="assigned"></generator>  
    </id>  
            
    <property name="firstName"></property>  
    <property name="lastName"></property>  
            
  </class>  
            
 </hibernate-mapping>


hibernate.cfg.xml


<?xml version='1.0' encoding='UTF-8'?>  
<!DOCTYPE hibernate-configuration PUBLIC  
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"  
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">  
  
<hibernate-configuration>  
  
    <session-factory>  
        <property name="hbm2ddl.auto">update</property>  
        <property name="dialect">org.hibernate.dialect.OracleDialect</property>  
        <property name="connection.url">jdbc:oracle:thin:@localhost:1521:xe</property>  
        <property name="connection.username">hibernate</property>  
        <property name="connection.password">java</property>  
        <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>  
    <mapping resource="employee.hbm.xml"/>  
    </session-factory>  
  
</hibernate-configuration>  

No comments:

Post a Comment