orderdao.java

网上购物系统struts+spring+hibernate实现

package com.sdi0708.bdifn.bookstore.dao.impl;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import com.sdi0708.bdifn.bookstore.dao.IOrderDao;
import com.sdi0708.bdifn.bookstore.domain.Order;

public class OrderDao extends BaseDao implements IOrderDao {

	public void addOrder(Order order) {
		Session session = openSession();
		session.save(order);
	}

	@SuppressWarnings("unchecked")
	public List<Order> findAllOrders(int start, int size) {
		String hql = "from Order o order by o.status";
		Session session = openSession();
		Query query = session.createQuery(hql);
		query.setFirstResult(start);
		query.setMaxResults(size);
		List<Order> orders = query.list();
		return orders;
	}
	@SuppressWarnings("unchecked")
	public List<Order> findOrdersByUserId(Long userid) {
		String hql = "from Order o where o.user.id = ? order by o.createTime";
		Session session = openSession();
		Query query = session.createQuery(hql);
		query.setLong(0, userid);
		List<Order> orders = query.list();
		return orders;
	}

	@SuppressWarnings("unchecked")
	public int getOrdersCount() {
		Session session = openSession();
		String hql = "select count(id) from Order";
		Query q = session.createQuery(hql);
		List l = q.list();
		Long count = (Long) l.get(0);
		return count.intValue();
	}

	public void modifyOrder(Long id, int status) {
		Session session = openSession();
		String hql = "update Order o set o.status = ? where o.id = ?";
		Query q = session.createQuery(hql);
		q.setInteger(0, status);
		q.setLong(1, id);
		q.executeUpdate();
	}

}