sortdao.java

一个java写的网上购物系统

package com.hb.myshop.dao;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.hb.myshop.idao.ISortDAO;
import com.hb.myshop.po.Sort;




public class SortDAO  extends HibernateDaoSupport implements ISortDAO  {
	//private static final String LOAD_ALL = "from Sort s order by s.sortid desc";
	private static final String LOAD_ALL = "from Sort s order by s.sortid desc";
	public List findAllSort()
	{   
		try {
			return this.getHibernateTemplate().find(LOAD_ALL);
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
		
		
	}
	
	public void addSort(Sort sort)
	{
		try {
			this.getHibernateTemplate().save(sort);
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public void delSort(Sort sort)
	{
		try {
			this.getHibernateTemplate().delete(sort);
			
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
	
	public void modifySort(Sort sort)
	{    
		try {
			this.getHibernateTemplate().saveOrUpdate(sort);
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	
	}
	public Sort getsort(String sortid)
	{   
		try {
			return (Sort)this.getHibernateTemplate().get(Sort.class, sortid);
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
		
	}
	public List getsortbyn(String sortname)
	{   
		try {
			String hql="from Sort where sortname like '%"+sortname+"%'";
			 return this.getHibernateTemplate().find(hql);
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
		 
	}
}