deptsystemdao.java

上一上传oa系统漏掉web-inf文件夹

package com.oa.db;

import java.util.List;

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

public class DeptSystemDao extends HibernateDaoSupport {

	/**
	 * 根据部门查询规章制度
	 * 
	 * @param Dept
	 * @return list
	 */
	public List findByDept(String dept) {	
		List list = null;
		try {
		   list = this.getHibernateTemplate().find("from Deptsystem where department=?",dept);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block   
			e.printStackTrace();
		}
		return list;
	}

	/**
	 * 根据发布人查询规章制度
	 * 
	 * @param promulgator
	 * @return list
	 */
	public List findBypPomulgator(String promulgator) {
		List list = null;
		try {
		   list = this.getHibernateTemplate().find("form Deptsystem where promulgator=?",promulgator );
		} catch (HibernateException e) {
			// TODO Auto-generated catch block   
			e.printStackTrace();
		}
		return list;
	}

	/**
	 * 查询所有的规章制度
	 * 
	 * @return list
	 */
	public List findAllSystem() {
		List list = null;
		try {
		  list = this.getHibernateTemplate().find("from Deptsystem");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block   
			e.printStackTrace();
		}
		return list;
	}

	/**
	 * 根据部门规章制度id查询
	 * 
	 * @param id
	 * @return list
	 */
	public List findById(int id) {
		List list = null;
		try {
		  list = this.getHibernateTemplate().find("from Deptsystem where id=?" ,id);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block   
			e.printStackTrace();
		}
		return list;
	}

	/**
	 * 添加新的规章制度
	 * 
	 * @param deptsystem
	 */
	public void addSystem(Deptsystem deptsystem) {
		try {
			this.getHibernateTemplate().save(deptsystem);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block   
			e.printStackTrace();
		}
	}

	/**
	 * 修改规章制度
	 * 
	 * @param deptsystem
	 */
	public void updateSystem(Deptsystem deptsystem) {
		try {
			this.getHibernateTemplate().update(deptsystem);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block   
			e.printStackTrace();
		}
	}

	/**
	 * 根据规章制度id删除规章制度
	 * 
	 * @param id
	 */
	public void deleteSystem(int id) {
		try {
			List list = (List) this.getHibernateTemplate().find("from Deptsystem where id=?",id);
			Deptsystem deptsystem = (Deptsystem) list.get(0);
			this.getHibernateTemplate().delete(deptsystem);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block   
			e.printStackTrace();
		}
	}
	
	/**
	 * 查询公司公共制度
	 * 
	 * @return
	 */
	public List findCompanySystem() {
		List list = null;
		try {
		    list = this.getHibernateTemplate().find("from Deptsystem where department=?", "所有部门");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block   
			e.printStackTrace();
		}
		return list;
	}
}