projectlist.java

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

/*
 * 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.sa.project;

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 ProjectList {
	
	private Project[] projects;
	
	private static Logger logger = Logger.getLogger ("ProjectList") ;
	
	private SqlDB dbf;
	private ResultSet rs;
	
	//增加一个关闭resultset与SqlDB的方法
	private void close()
	{
		try
		{
			if(rs!=null) rs.close();
			logger.debug("close the resultset");
			if(dbf!=null) dbf.close();
			logger.debug("close the sqldb");
		}
		catch(SQLException sqle)
		{
			logger.error("Close SqlDB error: "+sqle.getMessage());
		}
	}	
	
	public void getAllProject(){
		try{
			
			//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
			//Get an instance reference to the DbFacade object
			dbf = new SqlDB();
			String sql = "SELECT name,DepartName, projectID,projectCode,projectName,Description,StartDate,endDate,Stage,Budget";
			sql += " FROM project,employee,department where project.PM = employee.userID and project.depart=department.departID  order by startDate";
			rs=dbf.executeQuery(sql);
			
			
			int rowNum = 0;
			ArrayList projectArrayList = new ArrayList();
			while ((rs.next())){				
				Project aProject = new Project();
				Integer rowNumInt = new Integer(rowNum);
				System.out.println(rowNumInt.toString());	
				aProject.setId(rowNumInt.toString());
				aProject.setProjectID(rs.getString("projectID"));
				aProject.setProjectCode(rs.getString("projectCode"));
				aProject.setProjectName(rs.getString("projectName"));
				aProject.setStartDate(rs.getString("startDate"));
				aProject.setEndDate(rs.getString("endDate"));
				aProject.setDepart(rs.getString("DepartName"));
				aProject.setPM(rs.getString("name"));
				aProject.setDescription(rs.getString("Description"));
				aProject.setBudget(rs.getString("Budget"));
				aProject.setStage(rs.getString("Stage"));
				projectArrayList.add(aProject);		
				rowNum++;
				//System.out.println("rowNum:" + rowNum);	
			}
			projects = new Project[projectArrayList.size()];
			projectArrayList.toArray(projects);
		/*
			projects = new Project[rowNum];					
	
			rs.beforeFirst();
			Project aProject = new Project();
			for (int i = 0; i < rowNum; i++)
			{
				aProject = new Project();
				aProject.setProjectID(rs.getString("projectID"));
				aProject.setProjectName(rs.getString("projectName"));
				aProject.setStartTime(rs.getString("description"));
				projects[i] = aProject;			
			}
		*/
		}
		catch (Exception e)   	
		{
			logger.error("Exception in getAllProject:" + e.getMessage());
		}
		finally
		{
			close();
		}
				
	}
	
	
	public void getMyProject(String userID){
		try{
			
			//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
			//Get an instance reference to the DbFacade object
			dbf = new SqlDB();
			String sql = "SELECT projectID,projectCode,projectName,Description,StartDate,endDate,Stage";
			sql += " FROM project,projectMember";
			sql += " where project.projectID=projectMember.project and projectMember.user="+userID+" order by startDate";
			rs=dbf.executeQuery(sql);
			
			
			int rowNum = 0;
			ArrayList projectArrayList = new ArrayList();
			while ((rs.next())){				
				Project aProject = new Project();
				Integer rowNumInt = new Integer(rowNum);
				System.out.println(rowNumInt.toString());	
				aProject.setProjectID(rs.getString("projectID"));
				aProject.setProjectCode(rs.getString("projectCode"));
				aProject.setProjectName(rs.getString("projectName"));
				aProject.setStartDate(rs.getString("startDate"));
				aProject.setEndDate(rs.getString("endDate"));
				aProject.setDescription(rs.getString("Description"));
				aProject.setStage(rs.getString("Stage"));
				projectArrayList.add(aProject);		
				rowNum++;
				//System.out.println("rowNum:" + rowNum);	
			}
			projects = new Project[projectArrayList.size()];
			projectArrayList.toArray(projects);
		/*
			projects = new Project[rowNum];					
	
			rs.beforeFirst();
			Project aProject = new Project();
			for (int i = 0; i < rowNum; i++)
			{
				aProject = new Project();
				aProject.setProjectID(rs.getString("projectID"));
				aProject.setProjectName(rs.getString("projectName"));
				aProject.setStartTime(rs.getString("description"));
				projects[i] = aProject;			
			}
		*/
		}
		catch (Exception e)   	
		{
			logger.error("Exception in getMyProject:" + e.getMessage());
		}
		finally
		{
			close();
		}
				
	}
	
	public Project[] getProjects(){
		return projects;
	}
	
	public void setProjects(Project[] theProjects){
			this.projects = theProjects;
	}
	 

}