modulelistdao.java

一个oa系统

package com.oa.companyculture.db;

import java.util.List;

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

public class ModulelistDao extends HibernateDaoSupport {

	/**
	 * 查询所有的版块
	 * 
	 * @return list
	 */
	public List findAll() {
		 List list = null;
		try {  
			list = this.getHibernateTemplate().find("from Modulelist");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

	/**
	 * 添加新的版块
	 * 
	 * @param modulelist
	 */
	public void addModule(Modulelist modulelist) {
		try {  
			this.getHibernateTemplate().save(modulelist);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	/**
	 * 根据版块id删除版块
	 * 
	 * @param id
	 */
	public void deleteModule(int id) {
		List list = null;
		try {  
			list = this.getHibernateTemplate().find("from Modulelist where id=" + id);
		Modulelist modulelist = (Modulelist) list.get(0);
		this.getHibernateTemplate().delete(modulelist);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	/**
	 * 修改版块
	 * 
	 * @param modulelist
	 */
	public void updateModule(Modulelist modulelist) {
		try {  
			this.getHibernateTemplate().update(modulelist);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	/**
	 * 根据id查询版块
	 * 
	 * @param id
	 * @return
	 */
	public List findById(int id) {
		List list = null;
		try {  
			list = (List) this.getHibernateTemplate().find("from Modulelist where id=?", id);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		if (list != null && list.size() != 0) {
			return list;
		} else
			return null;
	}
}