orderdao.java

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

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 OrderDAO {

	private Session session = null;

	public OrderDAO() {
		Configuration conf = new Configuration().configure();
		SessionFactory factory = conf.buildSessionFactory();
		this.session = factory.openSession();

	}

	public void save(Order order) {
		Transaction tx = this.session.beginTransaction();
		this.session.save(order);
		tx.commit();
	}

	public void update(Order order) {
		Transaction tran = this.session.beginTransaction();
		this.session.update(order);
		tran.commit();
	}

	public Order queryByID(String id) {
		Order o = null;
		String hql = "from Orders as o where o.oid=?";
		Query q = this.session.createQuery(hql);
		q.setString(0, id);
		List l = q.list();
		Iterator iter = l.iterator();
		if (iter.hasNext()) {
			o = (Order) iter.next();
		}
		return o;
	}

	public void delete(Order order) {
		Transaction tran = this.session.beginTransaction();
		this.session.delete(order);
		tran.commit();
	}

	public void delete(String id) {
		Transaction tran = this.session.beginTransaction();
		String hql = "delete Orders as o where o.oid=?";
		Query q = this.session.createQuery(hql);
		q.setString(0, id);
		q.executeUpdate();
		tran.commit();
	}

	public List queryAll() {
		List l = null;
		String hql = "from orders";
		Query q = this.session.createQuery(hql);
		l = q.list();
		return l;
	}

	public List queryLike(String name) {
		List l = null;
		String hql = "from orders as o where o.name like ?";
		Query q = this.session.createQuery(hql);
		q.setString(0, "%" + name + "%");
		l = q.list();
		return l;
	}
}