bidrecorddaoimpl.java

Struts+Spring+Hibernate实现的在线拍卖系统,去掉了这些组件自身的jar包

package org.bestteam.dao.impl;

import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.bestteam.dao.AuctionItemsDao;
import org.bestteam.dao.BidRecordDao;
import org.bestteam.domain.AuctionItems;
import org.bestteam.domain.BidRecord;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class BidRecordDaoImpl extends HibernateDaoSupport implements
		BidRecordDao {

	private static final Log log = LogFactory.getLog(BidRecordDaoImpl.class);

	public void delete(BidRecord bidRecord) {
		log.debug("deleting BidRecord instance");
		try {
			getHibernateTemplate().delete(bidRecord);
			log.debug("delete successful");
		} catch (RuntimeException re) {
			log.error("delete failed", re);
			throw re;
		}
	}

	public List findByProperty(String propertyName, Object value) {
		log.debug("finding BidRecord instance with property: " + propertyName
				+ ", value: " + value);
		try {
			String queryString = "from BidRecord where " + propertyName + "= ?";
			return getHibernateTemplate().find(queryString, value);
		} catch (RuntimeException re) {
			log.error("find by property name failed", re);
			throw re;
		}
	}

	public List getBidRecord(int id) {
		List list = null;
		String query = "from BidRecord  bid inner join fetch bid.auctionItems au inner join fetch bid.userinfo where au.auctionItemId = ? order by bid.price desc";
		list = getHibernateTemplate().find(query, id);
		System.out.println(list.size());
		return list;
	}

	public void save(BidRecord bidRecord) {
		log.debug("saving BidRecord instance");
		try {
			getHibernateTemplate().save(bidRecord);
			log.debug("save successful");
		} catch (RuntimeException re) {
			log.error("save failed", re);
			throw re;
		}

	}

	public BidRecord saveOrUpdate(BidRecord bidRecord) {
		log.debug("saveOrUpdate BidRecord instance");
		try {
			BidRecord result = (BidRecord) getHibernateTemplate().merge(
					bidRecord);
			log.debug("saveOrUpdate successful");
			return result;
		} catch (RuntimeException re) {
			log.error("saveOrUpdate failed", re);
			throw re;
		}
	}

	public BidRecord getAuctionItemsByBidTime(int auctionItemID) {
		Integer auctionItemId;
		String sql = "select max(bid.id)from BidRecord as bid  where bid.auctionItems.auctionItemId = "
				+ auctionItemID + ")";
		List auctionItemIdList = getHibernateTemplate().find(sql);
		auctionItemId = (Integer) auctionItemIdList.get(0);
		// System.out.println(auctionItemId);
		String query = "from BidRecord as bid where bid.id =" + auctionItemId;
		List list = getHibernateTemplate().find(query);
		BidRecord bidRecord = (BidRecord) list.get(0);
		return bidRecord;
	}

	public boolean isMaxPrice(int auctionItemID, double price) {
		String sql = "from BidRecord as bid  where bid.auctionItems.auctionItemId =? order by bid.price desc";
		boolean state = false;
		System.out.println("*********" + auctionItemID);
		List list = getHibernateTemplate()
				.find(
						"select max(bid.price) from BidRecord bid where bid.auctionItems.auctionItemId = ?",
						auctionItemID);
		
		
		
		System.out.println(list);
		

		if (list != null && list.size() > 0) {
			double maxPrice = new Double(list.get(0).toString());
			if (maxPrice < price && (maxPrice - price) % 5 == 0) {
				state = true;
	
			}
		}
		
		else{
			List payList = getHibernateTemplate().find("from BidRecord bid where bid.auctionItems.auctionItemId = ?",auctionItemID);
			
			if (payList == null && payList.size() == 0){
				List auction = getHibernateTemplate().find("from AuctionItems bid where bid.auctionItemId = ?",auctionItemID);
				state = true;
			}
		}
		return state;
	}

}