projectmembers.java

本人课程设计时做的一个用struts框架实现的基于cmmi2的项目管理系统的原型。还有部分功能尚未实现

package com.cmmi2pms.ma;

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

import com.cmmi2pms.common.comdb.*;

public class ProjectMemberS 
{
	private ProjectMember[] memberS;
	
	public ProjectMember[] getMemberS() 
	{
		return memberS;
	}
	
	public void setMemberS(String projectId) 
	{
		ProjectMember aProjectMember;
		/*
		//可能没有这个项目，先不管
		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 projectID,projectName,description,DepartName,starttime,name,stage FROM project,employee,depart ";
			//sql = sql + " where project.PM = employee.userID and project.depart = depart.departID and projectID = '" + projectID + "'";
			System.out.println("before executeQuery");
			String sql = "SELECT * FROM projectMember where projectID = '" + projectId + "'";
			rs=dbf.executeQuery(sql);	
			System.out.println("after executeQuery");				
			
			int rowNum = 0;
			memberS = new ProjectMember[20];
			while ((rs.next()) && (rowNum < 20))
			{	
				aProjectMember=new ProjectMember(rs.getString("userID"));			
				memberS[rowNum] = aProjectMember;		
				rowNum++;
				//System.out.println("rowNum:" + rowNum);	
			}
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in getProjectInfor:" + e.getMessage());
		}
		*/
		memberS = new ProjectMember[2];
		memberS[0]=new ProjectMember("1");
		memberS[1]=new ProjectMember("2");
	}

}