submodulelistdao.java

一个oa系统

package com.oa.companyculture.db;

import java.util.List;

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

public class SubmodulelistDao extends HibernateDaoSupport{
	
	/**
	 * 根据父模版id查询子模版
	 * @param id
	 * @return
	 */
	public List findByModuleListId(int id){
		List list = null;
		try {  
			list =(List)this.getHibernateTemplate().find("from Submodulelist where modulelistid=?",id);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	/**
	 * 根据id查询子模块
	 * 
	 * @param id
	 * @return
	 */
	public List findById(int id) {
		List list = null;
		try {  
			list = (List) this.getHibernateTemplate().find("from Submodulelist where id=?", id);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}	
		if (list != null && list.size() != 0) {
			return list;
		} else {
			return null;
		}
	}
	
	/**
	 * 修改子版块
	 * 
	 * @param submodulelist
	 */
	public void updateModulelist(Submodulelist submodulelist) {
		try { 
			this.getHibernateTemplate().update(submodulelist);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	/**
	 * 添加子版块
	 * 
	 * @param submodulelist
	 */
	public void addSubModulelist(Submodulelist submodulelist) {
		try { 
			this.getHibernateTemplate().save(submodulelist);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	/**
	 * 删除子版块
	 * 
	 * @param submodulelist
	 */
	public void deleteSubModulelist(int id) {
		List list = null;
		try { 
			list = (List) this.getHibernateTemplate().find("from Submodulelist where id=?", id);
			Submodulelist submodulelist = (Submodulelist) list.get(0);
			this.getHibernateTemplate().delete(submodulelist);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public List findAllSubModule(){
		List list = null;
		try { 
			list = (List)this.getHibernateTemplate().find("from Submodulelist");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		if (list != null && list.size() != 0) {
			return list;
		} else {
			return null;
		}
	}
}