huresmanuserdao.java

来自「用JAVA环境开发的人力资源管理系统」· Java 代码 · 共 78 行

/*
 * Created on 2006-11-5
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package com.liyu.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.apache.commons.lang.StringUtils;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.ResultSetExtractor;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

import com.liyu.beans.FMStatiInfo;
import com.liyu.beans.JobStatiInfo;
import com.liyu.beans.PersonBaseInfo;


/**
 * @author Administrator
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class HuResManUserDao extends JdbcDaoSupport{
    private static final String GET_FM_SQL = "SELECT PERSON_SAX, COUNT(PERSON_SAX) CNT FROM PERSON_BASE_INFO GROUP BY PERSON_SAX";
    private static final String GET_JOB_SQL = "SELECT PERSON_JOBS, COUNT(PERSON_JOBS) CNT FROM PERSON_RESOURCE_INFO GROUP BY PERSON_JOBS";
    
	public FMStatiInfo getFMCount(){
		return(FMStatiInfo) this.getJdbcTemplate().query(GET_FM_SQL,new fmCountListExtractor());
		//return null;
	}
	private static class fmCountListExtractor implements ResultSetExtractor {
		public Object extractData(ResultSet rs) throws SQLException,
				DataAccessException {
		    FMStatiInfo fMStatiInfo = new FMStatiInfo();
			//List list = new ArrayList();
			while(rs.next()) {
			    if (rs.getString("PERSON_SAX").equals("F")){
			        fMStatiInfo.setFemaleCnt(StringUtils.defaultString(rs.getString("CNT")));
			    
			    }else{
			        fMStatiInfo.setMaleCnt(StringUtils.defaultString(rs.getString("CNT")));  
			    }
			}
			return fMStatiInfo;
		}
	}
	
	
	public JobStatiInfo getJOBCount(){
		return(JobStatiInfo) this.getJdbcTemplate().query(GET_JOB_SQL,new jobCountListExtractor());
		//return null;
	}
	private static class jobCountListExtractor implements ResultSetExtractor {
		public Object extractData(ResultSet rs) throws SQLException,
				DataAccessException {
		    JobStatiInfo jobStatiInfo = new JobStatiInfo();
			//List list = new ArrayList();
			while(rs.next()) {
			    if (rs.getString("PERSON_JOBS").equals("SalesManager")){
			        jobStatiInfo.setSalesManagerCnt(StringUtils.defaultString(rs.getString("CNT")));
			    }else if (rs.getString("PERSON_JOBS").equals("Manager")){
			        jobStatiInfo.setManagerCnt(StringUtils.defaultString(rs.getString("CNT")));
			    }else{
			        jobStatiInfo.setSalesCnt(StringUtils.defaultString(rs.getString("CNT")));  
			    }
			}
			return jobStatiInfo;
		}
	}
}