departmentdao.java

一个oa系统

package com.oa.db;

import java.util.ArrayList;
import java.util.List;

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


public class DepartmentDAO extends HibernateDaoSupport{
	
	public String findColumnById(int parecid){//通过id查询部门
		List list = null;
		String departmentname = "";
		try {
			list = this.getHibernateTemplate().find("from Department where id=?",parecid);
			if(list!=null&&list.size()!=0){
				Department vo = (Department)list.get(0);
				departmentname = vo.getDepartment();
			}
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return departmentname;
	}
	
	public List QueryDepartment() {//查询部门
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Department");	
			} catch (HibernateException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		    return list;
	}
	
	
	/**
	 * 查询所有部门
	 * 
	 * @return
	 */
	public List showAll() {
		List list = this.getHibernateTemplate().find("from Department");
		return list;
	}

	/**
	 * 根据部门id查询部门资料
	 * 
	 * @param id
	 * @return
	 */
	public List showById(int id) {
		List list = this.getHibernateTemplate().find(
				"from Department where id=" + id);
		return list;
	}

	/**
	 * 添加新的部门
	 * 
	 * @param dept
	 */
	public void addDept(Department dept) {
		this.getHibernateTemplate().save(dept);
	}

	/**
	 * 修改部门
	 * 
	 * @param dept
	 */
	public void updateDept(Department dept) {
		this.getHibernateTemplate().update(dept);
	}

	/**
	 * 删除部门
	 * 
	 * @param id
	 */
	public void deleteDept(int id) {
		List list = this.getHibernateTemplate().find(
				"from Department where id=" + id);
		Department department = (Department) list.get(0);
		this.getHibernateTemplate().delete(department);
	}

	/**
	 * 根据部门id查询部门名称
	 * 
	 * @param id
	 * @return departmentname
	 */
	public String showDeptById(int id) {
		List list = this.getHibernateTemplate().find("from Department where id=" + id);
		Department department = (Department) list.get(0);
		String departmentname = department.getDepartment();
		return departmentname;
	}
	
	public ArrayList<Department> findAllDept() {
		// TODO 自动生成方法存根
		ArrayList<Department> deptList = new ArrayList<Department>();
		try {
			String sql = "from Department";
			deptList = (ArrayList<Department>) getHibernateTemplate().find(sql);
			Department dept = new Department();
			dept.setDepartment("公共公告");
			dept.setId(99);
			deptList.add(dept);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block   
			e.printStackTrace();
		}
		return deptList;
	}

	public Department findOneDeptByDeptId(int deptId) {
		// TODO 自动生成方法存根
		Department dept = new Department();
		dept = (Department) getHibernateTemplate().find("from Department where id=?" ,deptId).get(0);
		
		return dept;
	}
	
}