orderdao.java

本系统为符合订单管理 精确使用了账号分层用户管理 可进行主订单 次订单的增加 删除功能 实现了全密浏览用品的功能！

package com.hz.order.dao;

import java.util.ArrayList;
import java.util.List;

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

import com.hz.hibernate.HibernateSessionFactory;
import com.hz.hibernate.PublicClass;
import com.hz.pojo.Goods;
import com.hz.pojo.Mainorder;
import com.hz.pojo.Member;
import com.hz.pojo.Suborder;
import com.hz.pojo.Ware;

public class OrderDAO extends PublicClass implements IOrderDAO {

	
	public List showWare() {
		List list = new ArrayList();
		list = this.queryAll("Goods","Ware");
		return list;
	}
	
	public Ware queryWareByWareId(int wareId) {
		Ware ware = null;
		ware = (Ware) (this.queryByProperty("Goods","Ware", "wareId", wareId)).get(0);
		return ware;
	}

	public void addMainOrder(Mainorder main) {
		this.insert(main);
	}

	public int getMainOrderId() {
		String hql = "select max(orderId) from Mainorder";
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery(hql);
		List list = query.list();
		int maxOrderId = (Integer) list.get(0);
		session.beginTransaction().commit() ;
		session.close() ;
		return maxOrderId;
	}

	public Mainorder getMainorderByOrderId(int orderId) {
		Mainorder main = (Mainorder) this.queryByProperty("Member","Mainorder", "orderId", orderId).get(0);
		return main;
	}

	public Member getMemberByMemberId(int memberId) {
		Member member = (Member) this.queryByProperty("Level","Member", "memberId", memberId).get(0);
		return member;
	}

	public void updateMember(Member member) {
		this.update(member);
	}

	public void addSubOrder(List subList) {
		for(int i =0;i<subList.size();i++){
			this.insert(subList.get(i));
		}
	}

	public List queryOrderByMemberId(int memberId) {
		List orderList = new ArrayList() ;
		String hql = "from Mainorder where memberId = ?";
		Session session = HibernateSessionFactory.getSessionFactory().openSession();
		Query query = session.createQuery("from Member");
		query.list();
		query = session.createQuery(hql);
		query.setInteger(0, memberId);
		orderList = query.list();
		session.beginTransaction().commit() ;
		session.close() ;
		return orderList;
	}

	public double getPriceCountByOrderId(int orderId) {
		Mainorder main = (Mainorder) (this.queryByProperty("Member","Mainorder", "orderId", orderId)).get(0);
		double priceCount = main.getPriceCount();
		return priceCount;
	}

	public List querySubOrderByOrderId(int orderId) {
		String hql = "from Suborder where orderId = ?";
		Session session = HibernateSessionFactory.getSessionFactory().openSession();
		Query query = session.createQuery("from Member");
		query.list();
		query = session.createQuery("from Mainorder");
		query.list();
		query = session.createQuery(hql);
		query.setInteger(0, orderId);
		List list = query.list();
		session.beginTransaction().commit() ;
		session.close() ;
		return list;
	}

	public void deleteSubOrderBySubId(String[] subIds) {
		this.delete("Suborder", "subId", subIds);
	}

	public Suborder getSuborderBySubId(int subId) {
		String hql = "from Suborder where subId = ?";
		Session session = HibernateSessionFactory.getSessionFactory().openSession();
		Query query = session.createQuery("from Member");
		query.list();
		query = session.createQuery("from Mainorder");
		query.list();
		query = session.createQuery(hql);
		query.setInteger(0, subId);
		Suborder sub = (Suborder)query.list().get(0);
		session.beginTransaction().commit() ;
		session.close() ;
		return sub;
	}

	public void updateSubOrder(Suborder sub) {
		this.update(sub);
	}

	public void addGoods(Goods goods) {
		this.insert(goods);
	}

	public List queryGoods() {
		List list = this.queryAll("Goods");
		return list;
	}

	public void deleteGoods(String[] goodsIds) {
		this.delete("Goods","goodsId",goodsIds);
	}
	
	public void addWare(Ware ware){
		this.insert(ware);
	}

	public List queryWareByGoodsId(Goods goods) {
		List list = this.queryByProperty("Ware", "gooods", goods);
		return list;
	}

	public void deleteWareByGoodsId(int goodsId) {
		this.delete("Ware", "goodsId", goodsId);
	}

	public void updateState(int orderId) {
		String hql = "update from Mainorder set state=1 where orderId =?";
		Session session = HibernateSessionFactory.getSessionFactory().openSession();
		Query query = session.createQuery(hql);
		query.setInteger(0, orderId);
		query.executeUpdate();
		session.beginTransaction().commit() ;
		session.close() ;
	}
}