ordersdao.java

来自「一个java写的网上购物系统」· Java 代码 · 共 54 行

package com.hb.myshop.dao;

import java.text.SimpleDateFormat;
import java.util.List;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.hb.myshop.idao.IOrdersDAO;
import com.hb.myshop.po.Orders;

public class OrdersDAO extends HibernateDaoSupport implements IOrdersDAO {

	public void deleteOrders(String  orderid) {
		List orders=getHibernateTemplate().find("from Orders where orderId='"+orderid+"'");
		for(int i=0;i<orders.size();i++){
			getHibernateTemplate().delete((Orders)orders.get(i));
		}
	}

	public List getAllOrders(String orderid) {
		HibernateTemplate ht = this.getHibernateTemplate();
		List orders = ht.find("from Orders where orderId='"+orderid+"' and isbuy='false'");
		// 格式化时间为yyyy-MM-dd
		SimpleDateFormat dataFormat = new SimpleDateFormat("yyyy-MM-dd");
		for (int i = 0; i < orders.size(); i++) {
			String strDate = dataFormat.format(((Orders) orders.get(i))
					.getShoptime());
			java.sql.Date date = java.sql.Date.valueOf(strDate);
			((Orders) orders.get(i)).setShoptime(date);
		}
		return orders;
	}
	
	/**
	 * 
	 */
	
	public void insertOrders(Orders order) {
		HibernateTemplate ht = this.getHibernateTemplate();
		ht.save(order);
	}
	
	public List selectAll(){
		return getHibernateTemplate().getSessionFactory().openSession().createQuery("select  count(distinct orderid) from  Orders").list();
	}

	public List getUesedOrders(String orderid) {
		return getHibernateTemplate().find("from Orders where orderId='"+orderid+"' and isbuy='true'");
	}

	public List getUesedOrderID(String username) {
		return getHibernateTemplate().find("from Record where username='"+username+"'");
	}
}