Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Hibernate HQL Update Statement to update database table

 
 

Share on Google+Share on Google+

HQL Update Statement to update database table

Advertisement
Update query in HQL is used to update rows in the given database tables. This article illustrates how to used the UPDATE statement in Hibernate.

HQL Update Statement to update database table

HQL's update query statement is used to update the values of database rows. Though HQL is similar to SQL but instead of running on tables it directly works with Hiberante persistent objects and their properties. Hibernate query language (HQL) also supports WHERE, SELECT, INNER JOIN, GROUP BY Statements except UPDATE, INSERT and DELETE Statements to perform various useful operations on database tables.

In this article we are testing an example to update the values of database table. See the example below...

Example of UPDATE Clause in Hibernate:

package roseindia.tutorial.hibernate;

import java.util.Date;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class UpdateExample {
  /**
 * @param args
 */
  public static void main(String[] args) {
  // TODO Auto-generated method stub
  Session sess = null;
  try {
  SessionFactory fact = new Configuration()
.configure().buildSessionFactory();
  sess = fact.openSession();
  Transaction tr = sess.beginTransaction();
  Insurance ins = (Insurance)sess.get
(Insurance.class, new Long(1));
  ins.setInsuranceName("Jivan Dhara");
  ins.setInvestementAmount(20000);
  ins.setInvestementDate(new Date());
  sess.update(ins);
  tr.commit();
  sess.close();
  System.out.println("Update successfully!");
  }
  catch(Exception e){
  System.out.println(e.getMessage());
  }
  }
}

Output of UPDATE Statement:

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.

Hibernate: select insurance0_.ID as ID0_0_, insurance0_.insurance_name as insurance2_0_0_, insurance0_.invested_amount as invested3_0_0_, insurance0_.investement_date as investem4_0_0_ from insurance insurance0_ where insurance0_.ID=?

Hibernate: update insurance set insurance_name=?, invested_amount=?, investement_date=? where ID=?

Update successfully!
Advertisement

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: October 2, 2013

Related Tutorials

Discuss: HQL Update Statement to update database table  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com