personoperate.java

一个用Hibernate持久层技术开发的小工程

package org.wzz.demo01;

import java.util.Iterator;
import java.util.List; 
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class PersonOperate {
     private Session session=null;
     private Transaction t= null;
     public PersonOperate(){
    	 Configuration config = new Configuration().configure();
    	 SessionFactory factory=config.buildSessionFactory();
    	 this.session=factory.openSession();
    	 t=this.session.beginTransaction();
     }
     public void insert(Person p){
         this.session.save(p);
          t.commit(); 
         this.session.close();
     }
     public void update(Person p){
          this.session.update(p);
           t.commit(); 
          this.session.close();
      }
     public Person QueryById(String id){
    	 Person p=null;
    	 String hql="FROM Person as p where p.id=?";
    	 Query q=this.session.createQuery(hql) ;
    	 q.setString(0,id);
    	 List l= q.list() ;
    	 Iterator it = l.listIterator() ;
    	 if(it.hasNext()){
    		 p = (Person)it.next();
    	 }
    	 return p ;
     }
     public void delete(Person p){
    	 this.session.delete(p);
         t.commit(); 
         this.session.close();   	  
    	 }
     public void delete(String id){
    	 String hql = "DELETE Person where id = ?";
    	 Query q = this.session.createQuery(hql) ;
     	 q.setString(0, id) ;
    	 q.executeUpdate() ;
    	 t.commit(); 
    	 }
     public List QueryAll(){
    	 String hql="FROM Person as p";
    	 Query q = this.session.createQuery(hql) ;
    	 List l = q.list();
    	 return l;
     }
     public List QueryByLike(String str){
    	 String hql = "FROM Person as p WHERE p.name Like ?";
    	 Query q = this.session.createQuery(hql) ;
    	 q.setString(0,"%"+str+"%") ;
       	 List l= q.list();
    	 return l;
     }
}