Code for updating database using hibernate framework in java

Written by Ankur Goel

Here is a simple hibernate program to update the table in the mysql. You can makeyour first code as given below and set the xml file accordingly. I have made the code run in the netbeans so the formatting is done accordingly.
This program will try to connect to the mysql database with the username and password given the xml file.

Include the following
·    Hibernate framework
·    Commons-lang-2.4.jar
·    Mysql-connector-java-5.1.5-bin.jar

Make a package hibernate1

Save this file as Main.java

package hibernate1;

import org.hibernate.*;

import org.hibernate.cfg.*;


public class Main {

    

    public static void main(String[] args) {
        // TODO code application logic here

        Session session = null;

    try{
      // This step will read hibernate.cfg.xml

        //Session sess=HibernateUtil.currentSession();

              SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
       session =sessionFactory.openSession();
        //Create new instance of Contact and set


         System.out.println("Inserting Record");
        Contact contact = new Contact();
        long a=1;
        contact.setId("5");
        contact.setFirstName("Deepak1");
        contact.setLastName("Kumar");
        //contact.setEmail("deepak");
        System.out.println(contact.getFirstName());
        Transaction tr = session.beginTransaction();
      //Contact ins = (Contact)session.get(Contact.class, "1");
      //ins.setFirstName("Jivan Dhara");
      
      //ins.setInvestementDate(new Date());
      //session.update(ins);
      session.save(contact);
      
      tr.commit();
      session.close();
        //session.save(contact);
        System.out.println("Done");
        //session.flush();
      //session.close();
    }catch(Exception e){
      //System.out.println(e.getMessage());
      e.printStackTrace();
    }finally{
      // Actual contact insertion will happen at this step
      

      }

  }
    }

Now make a xml file outside the package directory and save it as  hibernate.cfg.xml

"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">



      org.gjt.mm.mysql.Driver
      jdbc:mysql://localhost:3306/test
      root
      admin
      10
      true
      org.hibernate.dialect.MySQLDialect
      update
     
     



Now make a Contact.java


package hibernate1;


public class Contact {

  private String firstName;
  private String lastName;
 
  private String id;

 
  public String getFirstName() {
    return firstName;
  }

 
  public String getLastName() {
    return lastName;
  }

 
  public void setFirstName(String string) {
    firstName = string;
  }

 
  public void setLastName(String string) {
    lastName = string;
  }

 
  public String getId() {
    return id;
  }

 
  public void setId(String l) {
    id = l;
  }
}
Now make a corresponding xml file for Contact and save in the same directory as Contact.java
Save the xml file as Contact.hbm.xml

"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">


 
  
  
 

 
    
 
 
   
 
 
 

---

Add this page to your favorite Social Bookmarking websites

Comments

B

i

u

Quote

Code

List

List item

URL

Name *
Code   
ChronoComments by Joomla Professional Solutions

Submit Comment