在线拍卖系统 Myeclipse+SSHA+MSSQL2005

package com.epay.dao; import java.util.List; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.epay.pojo.TblGoods; import com.epay.pojo.TblPrice; import com.epay.pojo.TblUser; public class TblPriceDAOimpl extends HibernateDaoSupport implements PriceDAO { private static final Log log = LogFactory.getLog(TblPriceDAOimpl.class); /* (non-Javadoc) * @see com.epay.dao.PriceDAO#save(com.epay.pojo.TblPrice) */ public void save(TblPrice transientInstance) { log.debug("saving TblPrice instance"); try { getHibernateTemplate().save(transientInstance); log.debug("save successful"); } catch (RuntimeException re) { log.error("save failed", re); throw re; } } /* (non-Javadoc) * @see com.epay.dao.PriceDAO#delete(com.epay.pojo.TblPrice) */ public void delete(TblPrice persistentInstance) { log.debug("deleting TblPrice instance"); try { getHibernateTemplate().delete(persistentInstance); log.debug("delete successful"); } catch (RuntimeException re) { log.error("delete failed", re); throw re; } } /* (non-Javadoc) * @see com.epay.dao.PriceDAO#findById(java.lang.Integer) */ public TblPrice findById(java.lang.Integer id) { log.debug("getting TblPrice instance with id: " + id); try { TblPrice instance = (TblPrice) getHibernateTemplate().get( "com.epay.pojo.TblPrice", id); return instance; } catch (RuntimeException re) { log.error("get failed", re); throw re; } } /* (non-Javadoc) * @see com.epay.dao.PriceDAO#findByExample(com.epay.pojo.TblPrice) */ public List findByExample(TblPrice instance) { log.debug("finding TblPrice instance by example"); try { List results = getHibernateTemplate().findByExample(instance); log.debug("find by example successful, result size: " + results.size()); return results; } catch (RuntimeException re) { log.error("find by example failed", re); throw re; } } /* (non-Javadoc) * @see com.epay.dao.PriceDAO#findByProperty(java.lang.String, java.lang.Object) */ public List findByProperty(String propertyName, Object value) { log.debug("finding TblPrice instance with property: " + propertyName + ", value: " + value); try { String queryString = "from TblPrice as model where model." + propertyName + "= ?"; return getHibernateTemplate().find(queryString, value); } catch (RuntimeException re) { log.error("find by property name failed", re); throw re; } } /* (non-Javadoc) * @see com.epay.dao.PriceDAO#findAll() */ public List findAll() { log.debug("finding all TblPrice instances"); try { String queryString = "from TblPrice"; return getHibernateTemplate().find(queryString); } catch (RuntimeException re) { log.error("find all failed", re); throw re; } } /* 用户登录后查看竞价商品 * @see com.epay.dao.PriceDAO#seeRouped(com.epay.pojo.TblPrice) */ public List seeRouped( TblPrice tblprice) { String hql="select new TblPrice(price.tblGoods,price.tblUserByBuyerid,price.buyprice" + ",price.buytime) from TblPrice price,TblUser user,TblGoods good where price." + "tblUserByBuyerid.uid=user.uid and price.tblGoods.goodsid=good.goodsid and price.tblGoods.goodsid =?"; List list=getHibernateTemplate().find(hql, tblprice.getTblGoods().getGoodsid()); return list; } /* 对浏览商品进行竞价购买 * @see com.epay.dao.PriceDAO#toBuy(com.epay.pojo.TblPrice, com.epay.pojo.TblGoods) */ public boolean toBuy(TblPrice price,TblGoods good) { String hql1="update TblGoods g set g.goodsstatus=2 where g.goodsid=?"; getHibernateTemplate().save(price); int num2 = getHibernateTemplate().bulkUpdate(hql1,good.getGoodsid()); if(num2!=0){ return true; }else return false; } /* 卖方选择买家进行交易 * @see com.epay.dao.PriceDAO#bargain(com.epay.pojo.TblPrice, com.epay.pojo.TblGoods) */ public boolean bargain(TblPrice price,TblGoods good){ String hql="update TblPrice p set p.buystatue=2 where p.tblGoods.goodsid=?"; String hql1="update TblGoods g set g.goodsstatus=3 where g.goodsid=?"; int num = getHibernateTemplate().bulkUpdate(hql, price.getTblGoods().getGoodsid()); int num1=getHibernateTemplate().bulkUpdate(hql1, good.getGoodsid()); if(num!=0&&num1!=0){ return true; } return false; } // public static void main(String [] args){ // ApplicationContext contx=new ClassPathXmlApplicationContext("applicationContext.xml"); // TblPriceDAOimpl price=(TblPriceDAOimpl) contx.getBean("TblPriceDAO"); // TblPrice tblprice=new TblPrice(); // TblGoods good=new TblGoods(); // TblUser user = new TblUser(); // TblUser user1=new TblUser(); // // good.setGoodsid(38); // user.setUid(11); // user1.setUid(12); // // tblprice.setTblGoods(good); // tblprice.setTblUserByBuyerid(user); // tblprice.setTblUserBySalerid(user1); // tblprice.setBuyprice("123"); // tblprice.setBuytime("2008/10/30"); // tblprice.setBuystatue(1); // // price.toBuy(tblprice,good); // } }