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(TEX
完整的ssh项目 完整的ssh项目
4星 · 超过85%的资源 需积分: 50 180 浏览量
2011-05-27
09:55:15
上传
评论 4
收藏 16.36MB RAR 举报 
完整的ssh项目 完整的ssh项目 （347个子文件） 
GoodsDAO.class 9KB OrdersDAO.class 9KB CategoryDAO.class 6KB LoginDAO.class 6KB AddgoodsAction.class 5KB UpdateAction.class 5KB Orders.class 4KB OrderaddAction.class 3KB Goods.class 3KB ShowsamecategoryAction.class 3KB SearchAction.class 3KB LoginAction.class 3KB UpdateorderAction.class 3KB connect.class 3KB FreshListAction.class 2KB HomeshowAction.class 2KB CheckusernameAction.class 2KB AddcategoryAction.class 2KB DeleteAction.class 2KB UpdateordersAction.class 2KB LoginusernameAction.class 2KB EditcategoryAction.class 2KB ChecknumAction.class 2KB ShowallAction.class 2KB DeletecategoryAction.class 2KB ShoworderAction.class 2KB RegisterAction.class 2KB ShoworderaboutmeAction.class 2KB OrderinfoAction.class 2KB OrdereditinfoAction.class 2KB UpdateinfoAction.class 2KB ShowpreAction.class 2KB TomcatFormFilter$Request.class 2KB TomcatFormFilter.class 2KB Login.class 2KB ShowHomeServiceImp.class 2KB UpdateServiceImp.class 1KB AddgoodServiceImp.class 1KB UpdateorderServiceImp.class 1KB ExitAction.class 1KB OrderServiceImp.class 1KB Category.class 1KB DeleteServiceImp.class 1KB DeletecategoryServiceImp.class 1KB AddServiceImp.class 1KB ShoworderServiceImp.class 1KB ShowallServiceImp.class 1KB UpdatecategoryServiceImp.class 1011B SearchServiceImp.class 930B ShowsamecategoryServiceImp.class 881B ShoworderaboutmeServiceImp.class 861B CheckUsernameServiceImp.class 849B LoginServiceImp.class 847B UpdateinfoServiceImp.class 835B OrderinfoServiceImp.class 831B RegisterServiceImp.class 829B ShowpreServiceImp.class 823B LoginusernameServiceImp.class 789B UpdateorderService.class 375B DeleteService.class 332B ShowHomeService.class 307B AddgoodService.class 303B UpdateService.class 282B DeletecategoryService.class 274B AddService.class 265B ShoworderService.class 240B ShowallService.class 236B UpdatecategoryService.class 230B OrderService.class 227B SearchService.class 210B ShowsamecategoryService.class 208B ShoworderaboutmeService.class 207B CheckUsernameService.class 199B UpdateinfoService.class 192B OrderinfoService.class 190B LoginService.class 187B ShowpreService.class 186B LoginusernameService.class 178B RegisterService.class 170B .classpath 5KB org.eclipse.wst.jsdt.ui.superType.container 49B style.css 11KB lightbox.css 2KB Thumbs.db 135KB
hudie.gif 291KB about.gif 11KB search.gif 6KB 455.gif 6KB footer_bg.gif 5KB logo.gif 4KB loading.gif 3KB load.gif 3KB special_icon.gif 2KB new_icon.gif 2KB order_now.gif 2KB promo_icon.gif 2KB zoom.gif 2KB csscreme.gif 2KB prevlabel.gif 1KB bullet1.gif 1KB共 347 条
- 1
- 2
- 3
- 4
评论26
最新资源