package com.green.dao; import java.io.UnsupportedEncodingException; import java.util.List; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.hibernate.LockMode; import org.hibernate.Query; import org.springframework.context.ApplicationContext; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import org.springframework.transaction.annotation.Transactional; import com.green.vo.Goods; /** * A data access object (DAO) providing persistence and search support for Goods * entities. Transaction control of the save(), update() and delete() operations * can directly support Spring container-managed transactions or they can be * augmented to handle user-managed Spring transactions. Each of these methods * provides additional information for how to configure it for the desired type * of transaction control. * * @see com.green.vo.Goods * @author MyEclipse Persistence Tools */ @Transactional public class GoodsDAO extends HibernateDaoSupport { private static final Log log = LogFactory.getLog(GoodsDAO.class); // property constants public static final String NUM = "num"; public static final String NAME = "name"; public static final String IMAGE = "image"; public static final String PRICE = "price"; public static final String AMOUNT = "amount"; public static final String SPECIALFLAG = "specialflag"; public static final String UPLOADTIME = "uploadtime"; public static final String SALESFLAG = "salesflag"; public static final String INTRODUCE = "introduce"; public static final String TEXT = "text"; protected void initDao() { // do nothing } public List searchByName(String name) { try{ String paramter="%" +name+"%"; String queryString = "from Goods where name like ? "; return this.getHibernateTemplate().find(queryString, paramter); } catch (RuntimeException re) { log.error("find by name failed", re); throw re; } } public List searchBytext(String text) { try{ String paramter="%" +text+"%"; String queryString = "from Goods where introduce like ? "; return this.getHibernateTemplate().find(queryString, paramter); } catch (RuntimeException re) { log.error("find by name failed", re); throw re; } } /* * ����Ƽ�4����Ʒ��check */ public int getcountspecialf() { String hql="select count(*) from Goods where specialflag=1"; Query query=this.getSession().createQuery(hql); Integer it=(Integer)query.list().get(0); return it.intValue(); } /* * ������Ʒ����ʾ */ public List findByNew(){ String hql="from Goods order by uploadtime desc"; Query query=this.getSession().createQuery(hql); return query.list(); } /* * ��ȡ������� */ public int gettotalCount() { String hql="select count(*) from Goods"; Query query=this.getSession().createQuery(hql); Integer it=(Integer)query.list().get(0); return it.intValue(); } /* * ��ȡ��ҳ�� */ public int gettotalPage(int totalCount,int prePage) { int totalPage=0; if(totalCount%prePage==0) { totalPage=totalCount/prePage; } else totalPage=totalCount/prePage+1; return totalPage; } /* * ��ȡÿҳ��ʾ����� */ public List getlistshowall(int currentPage,int prePage) { String hql="from Goods "; Query query=this.getSession().createQuery(hql); query.setFirstResult((currentPage-1)*prePage); query.setMaxResults(prePage); return query.list(); } public void save(Goods transientInstance) { log.debug("saving Goods instance"); try { getHibernateTemplate().save(transientInstance); log.debug("save successful"); } catch (RuntimeException re) { log.error("save failed", re); throw re; } } public void update(Goods goods) { String querysql="update Goods set name=?,price=?,amount=?,specialflag=?,salesflag=?,introduce=?,text=?,categoryid=? where num=?"; try { Query queryObject =this.getSession().createQuery(querysql); queryObject.setParameter(0, goods.getName()); queryObject.setParameter(1,goods.getPrice() ); queryObject.setParameter(2, goods.getAmount()); queryObject.setParameter(3, goods.getSpecialflag()); queryObject.setParameter(4, goods.getSalesflag()); queryObject.setParameter(5, goods.getIntroduce()); queryObject.setParameter(6, goods.getText()); queryObject.setParameter(7, goods.getCategory()); queryObject.setParameter(8, goods.getNum()); queryObject.executeUpdate(); } catch (RuntimeException re) { throw re; } } public void update1(Goods goods) { String querysql="update Goods set name=?,price=?,amount=?,specialflag=?,salesflag=?,introduce=?,text=?,categoryid=?,image=? where num=?"; try { Query queryObject =this.getSession().createQuery(querysql); queryObject.setParameter(0, goods.getName()); queryObject.setParameter(1,goods.getPrice() ); queryObject.setParameter(2, goods.getAmount()); queryObject.setParameter(3, goods.getSpecialflag()); queryObject.setParameter(4, goods.getSalesflag()); queryObject.setParameter(5, goods.getIntroduce()); queryObject.setParameter(6, goods.getText()); queryObject.setParameter(7, goods.getCategory()); queryObject.setParameter(8, goods.getImage()); queryObject.setParameter(9, goods.getNum()); queryObject.executeUpdate(); } catch (RuntimeException re) { throw re; } } public void delete(Goods persistentInstance) { log.debug("deleting Goods instance"); try { getHibernateTemplate().delete(persistentInstance); log.debug("delete successful"); } catch (RuntimeException re) { log.error("delete failed", re); throw re; } } public Goods findById(java.lang.Long id) { log.debug("getting Goods instance with id: " + id); try { Goods instance = (Goods) getHibernateTemplate().get( "com.green.vo.Goods", id); return instance; } catch (RuntimeException re) { log.error("get failed", re); throw re; } } public List findByExample(Goods instance) { log.debug("finding Goods 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; } } public List findByProperty(String propertyName, Object value) { log.debug("finding Goods instance with property: " + propertyName + ", value: " + value); try { String queryString = "from Goods as model where model." + propertyName + "= ?"; return getHibernateTemplate().find(queryString, value); } catch (RuntimeException re) { log.error("find by property name failed", re); throw re; } } public List findByNum(Object num) { return findByProperty(NUM, num); } public List findByName(Object name) { return findByProperty(NAME, name); } public List findByImage(Object image) { return findByProperty(IMAGE, image); } public List findByPrice(Object price) { return findByProperty(PRICE, price); } public List findByAmount(Object amount) { return findByProperty(AMOUNT, amount); } public List findBySpecialflag(Object specialflag) { return findByProperty(SPECIALFLAG, specialflag); } public List findByUploadtime(Object uploadtime) { return findByProperty(UPLOADTIME, uploadtime); } public List findBySalesflag(Object salesflag) { return findByProperty(SALESFLAG, salesflag); } public List findByIntroduce(Object introduce) { return findByProperty(INTRODUCE, introduce); } public List findByText(Object text) { return findByProperty(TEXT, text); } public List findAll() { log.debug("finding all Goods instances"); try { String queryString = "from Goods"; return getHibernateTemplate().find(queryString); } catch (RuntimeException re) { log.error("find all failed", re); throw re; } } public Goods merge(Goods detachedInstance) { log.debug("merging Goods instance"); try { Goods result = (Goods) getHibernateTemplate().merge( detachedInstance); log.debug("merge successful"); return result; } catch (RuntimeException re) { log.error("merge failed", re); throw re; } } public void attachDirty(Goods instance) { log.debug("attaching dirty Goods instance"); try { getHibernateTemplate().saveOrUpdate(instance); log.debug("attach successful"); } catch (RuntimeException re) { log.error("attach failed", re); throw re; } } public void attachClean(Goods instance) { log.debug("attaching clean Goods instance"); try { getHibernateTemplate().lock(instance, LockMode.NONE); log.debug("attach successful"); } catch (RuntimeException re) { log.error("attach failed", re); throw re; } } public static GoodsDAO getFromApplicationContext(ApplicationContext ctx) { return (GoodsDAO) ctx.getBean("GoodsDAO"); } }
最近下载更多
微信网友_6508798513811456 LV5
2023年6月17日
ming_123_9715 LV23
2022年12月15日
2548143780 LV2
2022年12月1日
陈小小 LV3
2022年5月31日
17787885952 LV3
2022年5月5日
YYYUIDJIOJS LV1
2021年12月7日
ly010812 LV1
2021年11月24日
caodehao1 LV3
2021年11月16日
dyfvtsgf LV5
2021年6月28日
sprrow23 LV2
2021年6月20日
最近浏览更多
pangzhihui LV12
4月17日
liiiyou LV1
1月27日
仙女山的月亮 LV2
2023年11月27日
微信网友_6567487389290496
2023年7月18日
暂无贡献等级
微信网友_6508798513811456 LV5
2023年6月17日
A-sunny-day LV4
2023年6月10日
微信网友_6504705248153600
2023年6月4日
暂无贡献等级
111114 LV1
2023年5月14日
IlIlIIl LV2
2023年5月10日
3516569014 LV5
2023年5月7日