waredao.java

一个java写的网上购物系统

package com.hb.myshop.dao;

import java.util.List;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.hb.myshop.idao.IWareDAO;
import com.hb.myshop.po.Sort;
import com.hb.myshop.po.Ware;

public class WareDAO extends HibernateDaoSupport implements IWareDAO
{
	private static final String LOAD_ALL = "from Ware w order by w.wareid desc";
	private static final String getWares = "from Ware w where sortid like '% ? %' and warename like '% ? %' and wareid like '% ? %' and wareprice like '% ? %' ";
	public List getAllWares(){
		HibernateTemplate ht = this.getHibernateTemplate();
		List wares = ht.find("from Ware");
		return wares;
	}	
	
	public void addWare(Ware ware)
	{
		try {
			this.getHibernateTemplate().save(ware);
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public void addAndupWare(Ware ware)
	{
		try {
			this.getHibernateTemplate().saveOrUpdate(ware);
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public void delWaret(Ware ware)
	{
		try {
			this.getHibernateTemplate().delete(ware);
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public void modifyWare(Ware ware)
	{
		try {
			this.getHibernateTemplate().saveOrUpdate(ware);
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public Ware getWare(String wareid)
	{
		try {
			return (Ware)this.getHibernateTemplate().get(Ware.class, wareid);
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}
	public List getWarebyn(String warename)
	{
		try {
			 return this.getHibernateTemplate().find("from Ware where warename=?",warename);
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}
	
	public List getWares(String sortid,String warename,String wareid,String wareprice)
	{
		String hql=null;
		if(sortid==null){
			hql="from Ware w where warename like '%"+warename+"%' and wareid like '%"+wareid+"%' and wareprice like '%"+wareprice+"%' ";
		}
		else{
			Sort sort=(Sort)getHibernateTemplate().get(Sort.class,sortid);
			hql="from Ware w where sort="+sort+" and warename like '%"+warename+"%' and wareid like '%"+wareid+"%' and wareprice like '%"+wareprice+"%' ";
		}
		try {
			return this.getHibernateTemplate().find(hql);
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}
	public List seachWare(String wareName,String sortName){
		if(sortName.equals("所有商品")){
			return getHibernateTemplate().find("from Ware where warename like '%"+wareName+"%'");
		} 
		else if(wareName.equals("商品关键字")){
			Sort sort=(Sort)getHibernateTemplate().find("from Sort where sortname='"+sortName+"'").get(0);
			return getHibernateTemplate().find("from Ware where sortid='"+sort.getSortid()+"'");
		}
		else{
			Sort sort=(Sort)getHibernateTemplate().find("from Sort where sortname='"+sortName+"'").get(0);
			return getHibernateTemplate().find("from Ware where warename like '%"+wareName+"%' and sortid='"+sort.getSortid()+"'");
		}
	}
}