jobdao.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.Job;
import com.hb.core.dao.hibernateImp.HibernateDaoImp;

/**
 * 2008/01/15
 * 
 * @author 何 貝
 * 
 * 部门任职信息DAO
 */
@Component("jobDao")
public class JobDao extends HibernateDaoImp<Job> {
	/**
	 * 取得指定部门下面的所有员工信息列表尺寸
	 * 
	 * @param departmentID 部门ID
	 * @param validateDate 任职有效时间
	 * @return 员工列表尺寸
	 */
	@SuppressWarnings("unchecked")
	public int getEmployeeListSizeByDepIDAndValidateDate(String departmentID,
			String validateDate) {
		List<Long> resultList = getHibernateTemplate()
				.findByNamedQueryAndNamedParam(
						"Job.getEmployeeListSizeByDepIDAndValidateDate",
						new String[] { "validateDate", "departmentID" },
						new Object[] { validateDate, departmentID });

		return resultList.get(0).intValue();
	}

	/**
	 * 取得指定职位下面的所有员工信息列表尺寸
	 * 
	 * @param jobID 职位ID
	 * @param validateDate 任职有效时间
	 * @return 员工信息列表尺寸
	 */
	@SuppressWarnings("unchecked")
	public int getEmployeeListSizeByJobIDAndValidateDate(String jobID,
			String validateDate) {
		List<Long> resultList = getHibernateTemplate().findByNamedQuery(
				"Job.getEmployeeListSizeByJobIDAndValidateDate",
				new Object[] { jobID, validateDate, validateDate });

		return resultList.get(0).intValue();
	}
}