方法一：
package dao;
import book.Alter;
import book.Bookuserinformation;
import book.HibernateUtil;
import java.util.List;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.RequestScoped;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.Transaction;
/**
*
* @author Administrator
*/
@ManagedBean
@RequestScoped
public class modify {
public String executeUpdate3()throws HibernateException{
Session session=HibernateUtil.getSessionFactory().openSession();
Transaction tr=session.beginTransaction();
Alter s=new Alter();
String userid=s.getUserid().toString();
String sql = "select * from BOOKUSERINFORMATION where userid=?";
Query query=session.createSQLQuery(sql);
query.setString(0,userid);
List<Bookuserinformation> bookuserinformations=(List<Bookuserinformation>)query.list();
if(!bookuserinformations.isEmpty())
{
String sql1="update Bookuserinformation set firstname=?,lastname=? ,password=?,emailid=? where userid=?";
SQLQuery sqlquery=session.createSQLQuery(sql1);
sqlquery.setString(0, s.getFirstname().toString());
sqlquery.setString(1, s.getLastname().toString());
sqlquery.setString(2, s.getPassword().toString());
sqlquery.setString(2, s.getEmailID().toString());
sqlquery.setString(3, userid);
tr.commit();
return "Success1";
}
else
{
return "Updata";
}
}
}
方法二：
package dao;
import book.Bookuserinformation;
import book.HibernateUtil;
import org.hibernate.Session;
import org.hibernate.Transaction;
public class bookuserinfDao {
public bookuserinfDao(){
}
/*public void executeUpdate()throws HibernateException{
Session session=HibernateUtil.getSessionFactory().openSession();
Transaction tr=session.beginTransaction();
String sql="update Bookuserinformation set userid='#{alter.userid}',password='#{alter.password}'where emailid='#{alter.emailID}'";
Query query=session.createSQLQuery(sql);
query.executeUpdate();
tr.commit();
session.close();
}*/
public String Update(String userid,String firstname,String lastname,String password,String emailID){
Session session=HibernateUtil.getSessionFactory().openSession();
Transaction tr=session.beginTransaction();
Bookuserinformation bookuserinformations=(Bookuserinformation)session.get(Bookuserinformation.class,userid);
/* String sql = "select from BOOKUSERINFORMATION where userid=?";
Query query=session.createSQLQuery(sql);
query.setString(0,emailID);
List<Bookuserinformation> bookuserinformations=(List<Bookuserinformation>) query.list();
if(!bookuserinformations.isEmpty())
{
Serializable objID=session.save(bookuserinformations);
Bookuserinformation userupdate=(Bookuserinformation)session.load(Bookuserinformation.class,objID );*/
bookuserinformations.setFirstname(firstname);
bookuserinformations.setLastname(lastname);
bookuserinformations.setPassword(password);
bookuserinformations.setEmailid(emailID);
session.saveOrUpdate(bookuserinformations);
tr.commit();
return "Success1";
}
}
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package dao;
import book.Alter;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.RequestScoped;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
/**
*
* @author Administrator
*/
@ManagedBean
@RequestScoped
public class modify1 {
private SessionFactory sessionFactory;
public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}
public String executeUpdate1()
{
bookuserinfDao rghp=new bookuserinfDao();
Alter s=new Alter();
Session session=sessionFactory.openSession();
org.hibernate.Transaction tx = session.beginTransaction();
String msg = rghp.Update(s.getUserid(),s.getFirstname(),s.getLastname(),s.getPassword(),s.getEmailID());
if (msg.equals("error"))
{
s.setUserIdError("User emailID not exists. Please select another EmailID.");
s.setFirstname("");
s.setLastname("");
return "Updata";
}
else
{
return "Success1";
}
}
}