customerdao.java

来自「jave--- --- ---- 一对多关系例子」· Java 代码 · 共 77 行

package net.xinxing;

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 CustomerDAO {
	private Session session= null;

	public CustomerDAO() {
		// TODO Auto-generated constructor stub
		Configuration conf = new Configuration().configure();
		SessionFactory factory = conf.buildSessionFactory();
		this.session = factory.openSession();
	}

	public void save(Customer customer){
		Transaction tx = this.session.beginTransaction();
		this.session.save(customer);
		tx.commit();
	}
	 public void update(Customer customer){
	    	Transaction tran = this.session.beginTransaction();
	    	this.session.update(customer);
	    	tran.commit();
	    }
	    
		public Customer queryByID(String id){
	    	Customer c = null;
	    	String hql = "from Customer as c where c.cid=?";
	    	Query q = this.session.createQuery(hql);
	    	q.setString(0, id);
	    	List l = q.list();
	    	Iterator iter = l.iterator();
	    	if(iter.hasNext()){
	    		c = (Customer)iter.next();   		
	    	}
	    	return c;
	    }
	    public void delete(Customer customer){
	    	Transaction tran = this.session.beginTransaction();
	    	this.session.delete(customer);
	    	tran.commit();
	    }
	    public void delete(String id){
	    	Transaction tran = this.session.beginTransaction();
	    	String hql = "delete Customer as c where c.cid=?";
	    	Query q = this.session.createQuery(hql);
	    	q.setString(0, id);
	    	q.executeUpdate();
	    	tran.commit();
	    }
	    
	    
	    public List queryAll(){
	    	List l = null;
	    	String hql = "from Customer";
	    	Query q = this.session.createQuery(hql);
	    	l = q.list();
	    	return l;
	    }
	    
	    public List queryLike(String name){
	    	List l = null;
	    	String hql = "from Customer as c where c.name like ?";
	    	Query q = this.session.createQuery(hql);
	    	q.setString(0, "%"+name+"%");
	    	l = q.list();
	    	return l;
	    }
}