hrlist.java

来自「本人课程设计时做的一个用struts框架实现的基于cmmi2的项目管理系统的原型」· Java 代码 · 共 79 行

/*
 * Created on 2004-4-18
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.cmmi2pms.pp.hr;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;


import com.cmmi2pms.common.comdb.*;
import org.apache.log4j.Logger;

/**
 * @author lxj
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class HrList {
	
	private Hr[] hrs;
	
	private static Logger logger = Logger.getLogger ("HrList") ;
	
	public void getAllHr(int project){
		try{
			
			//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
			//Get an instance reference to the DbFacade object
			SqlDB dbf = null;
			dbf = new SqlDB();
			ResultSet rs = null;
			String sql = "SELECT user,Role,responsibility,userName,name "
			              + "from projectMember,employee where projectMember.project='" + project
			              +"' and projectMember.user=employee.userid and projectMember.isAvailable>0 order by user";
			rs=dbf.executeQuery(sql);
			
			
			int rowNum = 0;
			ArrayList hrArrayList = new ArrayList();
			while ((rs.next())){				
				Hr aHr = new Hr();
				Integer rowNumInt = new Integer(rowNum);
				System.out.println(rowNumInt.toString());	
				aHr.setProject( project );
				aHr.setUser(rs.getInt("user"));
				aHr.setRole(rs.getString("Role"));
				aHr.setResponsibility(rs.getString("responsibility"));
				aHr.setUsername(rs.getString("userName"));
				aHr.setName(rs.getString("name"));
				hrArrayList.add(aHr);		
				rowNum++;
				//System.out.println("rowNum:" + rowNum);	
			}
			hrs = new Hr[hrArrayList.size()];
			hrArrayList.toArray(hrs);
		}
		catch (Exception e)   	
		{
			logger.error("Exception in getAllHr:" + e.getMessage());
		}
				
	}

	public Hr[] getHrs(){
		return hrs;
	}
	
	public void setHrs(Hr[] theHrs){
			this.hrs = theHrs;
	}
	 

}