src/gouwushangcheng/dao/impl/ProductDaoImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package gouwushangcheng.dao.impl;
import gouwushangcheng.dao.ProductDao;
import gouwushangcheng.model.Product;

import java.sql.SQLException;
import java.util.List;


import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;



public class ProductDaoImpl extends HibernateDaoSupport implements ProductDao {

	

	public void deleteBean(Product bean) {
		this.getHibernateTemplate().delete(bean);
		
	}

	public void insertBean(Product bean) {
		this.getHibernateTemplate().save(bean);
		
	}

	@SuppressWarnings("unchecked")
	public Product selectBean(String where) {
		List<Product> list = this.getHibernateTemplate().find("from Product "+where);
		if(list.size()==0){
			return null;
		}
		return list.get(0);
	}

	public long selectBeanCount(final String where) {
		long count = (Long)this.getHibernateTemplate().find(" select count(*) from Product  "+where).get(0);
		return count;
	}

	@SuppressWarnings("unchecked")
	public List<Product> selectBeanList(final int start,final int limit,final String where) {
		return (List<Product>)this.getHibernateTemplate().executeFind(new HibernateCallback(){

			public Object doInHibernate(final Session session) throws HibernateException, SQLException {
				List<Product> list = session.createQuery(" from Product"+where).setFirstResult(start).setMaxResults(limit).list();
				return list;
			}
		});
		
	}

	public void updateBean(Product bean) {
		this.getHibernateTemplate().update(bean);
		
	}