departmentdao.java

一个自娱自乐的demo 开发环境 apache-tomcat-6.0.16 Mysql 5.1.11 Jdk 1.6 文件结构如下 --MyGame -----MyGam

package com.hb.base.dao.organization;

import java.util.List;

import org.springframework.stereotype.Component;

import com.hb.base.domain.organization.Department;
import com.hb.core.dao.hibernateImp.HibernateDaoImp;

/**
 * 2007-11-3
 * 
 * @author 何 貝
 * 
 * 部门信息DAO
 */
@Component("departmentDao")
public class DepartmentDao extends HibernateDaoImp<Department> {

	/**
	 * 取得最大的部门信息ID
	 * 
	 * @return 部门信息ID
	 */
	@SuppressWarnings("unchecked")
	public String getMaxID() {
		List<String> resultList = getHibernateTemplate().findByNamedQuery("Department.getMaxID");
		if (resultList.size() > 0) {
			String tmpID = resultList.get(0);

			return String.format("%1$08d", Integer.parseInt(tmpID) + 1);
		} else {
			return DEFAULT_MAX_ID;
		}
	}

	/**
	 * 取得部门信息树根节点对象
	 * 
	 * @return 树根节点部门信息
	 */
	@SuppressWarnings("unchecked")
	public Department getDepTreeRootNode() {
		List<Department> resultList = getHibernateTemplate().findByNamedQuery("Department.getDepById",
				new Object[] { DEFAULT_MAX_ID });
		if (resultList.size() > 0) {
			return resultList.get(0);
		}
		return null;
	}

	/**
	 * 取得部门信息对象(根据部门ID)
	 * 
	 * @param departmentID 部门信息ID
	 * @return 部门信息
	 */
	@SuppressWarnings("unchecked")
	public Department getDepartmentById(String departmentID) {
		List<Department> resultList = getHibernateTemplate().findByNamedQuery("Department.getDepById",
				new Object[] { departmentID });
		if (resultList.size() > 0) {
			return resultList.get(0);
		}
		return null;
	}

	/**
	 * 修改部门信息(根据部门ID)
	 * 
	 * @param departmentID 部门ID
	 * @param departmentName 部门名称
	 * @param startDate 有效开始时间
	 * @param endDate 有效结束时间
	 * @return 执行结果
	 */
	@SuppressWarnings("unchecked")
	public boolean modDepartment(String departmentID, String departmentName, String startDate, String endDate) {
		List<Department> resultList = getHibernateTemplate().findByNamedQuery("Department.getDepById",
				new Object[] { departmentID });
		if (resultList.size() > 0) {
			Department department = resultList.get(0);
			department.setDepartmentName(departmentName);
			department.setStartDate(startDate);
			department.setEndDate(endDate);
			save(department);
			return true;
		}
		return false;
	}

	/**
	 * 删除部门信息（根据部门ID）
	 * 
	 * @param departmentID 部门ID
	 * @return 执行结果
	 */
	@SuppressWarnings("unchecked")
	public boolean delDepartment(String departmentID) {
		List<Department> resultList = getHibernateTemplate().findByNamedQuery("Department.getDepById",
				new Object[] { departmentID });

		if (resultList.size() > 0) {
			Department department = resultList.get(0);
			remove(department);
			return true;
		}

		return false;
	}
}