Java Tutorial/Hibernate/Update

Материал из Java эксперт
Перейти к: навигация, поиск

HSQL Update With Parameters

File: Main.java



   <source lang="java">

import java.util.ArrayList; import java.util.Date; import java.util.List; import org.hibernate.Query; import org.hibernate.Session; public class Main {

 public static void main(String[] args) throws Exception {
   HibernateUtil hibernateUtil = new HibernateUtil();
   hibernateUtil
       .executeSQLCommand("create table survey (id int,name varchar, purchasedate date);");
   Session session = hibernateUtil.getSession();
   Survey survey = new Survey();
   survey.setName("Survey");
   survey.setPurchaseDate(new Date());
   session.save(survey);
   
   survey = new Survey();
   survey.setName("Survey1");
   survey.setPurchaseDate(new Date());    
   session.save(survey);
   
   session.flush();
   
   String hql = "update Survey set name = :newName where name = :name";
   Query query = session.createQuery(hql);
   query.setString("name","Survey");
   query.setString("newName","Corp");
   int rowCount = query.executeUpdate();
   System.out.println("Rows affected: " + rowCount);
   
   session.close();
   hibernateUtil.checkData("select * from survey");
 }

}</source>





Update entity in a Session

File: Main.java



   <source lang="java">

import java.util.Iterator; import java.util.List; import org.hibernate.Session; public class Main {

 public static void main(String[] args) throws Exception {
   HibernateUtil hibernateUtil = new HibernateUtil();
   hibernateUtil
       .executeSQLCommand("create table CD(id varchar,title varchar,artist varchar,purchaseDate date,cost decimal(6,2))");
   Session session = hibernateUtil.getSession();
   CD cd = new CD();
   cd.setArtist("artist");
   cd.setTitle("title");
   
   String id = (String)session.save(cd);
   System.out.println(id);
   session.flush();
   cd.setTitle("title1");
   session.update(cd);
   session.flush();
   session.close();
   hibernateUtil.checkData("select * from CD");
 }

}</source>