maplan.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 MaPlan 
{
	private String	    projectID;
	private String[]    maObjectNames;
	private int 	    curMaObjectName;
	private int	    numOfMaObject;
	private String	    checkTime;
	private boolean     c_check;
	private MaObject[]  maObjects;
	private String      startTime;
	private int	    changeMode;	 
	
	public MaPlan(String pId,String sTime,String[] maObjs)
	{
		projectID=pId;
		numOfMaObject=maObjs.length;
		maObjectNames=new String[maObjs.length];
		System.arraycopy(maObjs,0,maObjectNames,0,maObjs.length);
		maObjects=new MaObject[numOfMaObject];
		startTime=sTime;
		curMaObjectName=0;
		c_check=false;
		checkTime="";
		changeMode=0;
	}
	
	public MaPlan(String pId)
	{
		this.projectID = pId;
		changeMode=0;
		/*	
		maObjects = new MaObject[2];
		numOfMaObject=2;
		maObjects[0]=new MaObject();
		maObjects[1]=new MaObject();
		
		maObjects[0].setProjectID(pId);
		maObjects[0].setGatherCircle("一周");
		maObjects[0].setWindageGate("50");
		maObjects[0].setMaObject("maPaWorkload");
		maObjects[0].setAnalysisCircle("两周"); 
		maObjects[0].setAnalyst("李国翼");
		
		maObjects[1].setProjectID(pId);
		maObjects[1].setGatherCircle("一周");
		maObjects[1].setWindageGate("50");
		maObjects[1].setMaObject("maWorkload");
		maObjects[1].setAnalysisCircle("两周"); 
		maObjects[1].setAnalyst("刘新军");
		*/
		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 + "'";
			String sql = "SELECT * FROM MA_MAPlan where projectID = '" + pId + "'";;
			rs=dbf.executeQuery(sql);					
			
			if (rs.next())
			{
				this.projectID = pId;	
				this.startTime = rs.getString("StartTime").substring(0,10);
				if(rs.getString("MAPlanCheck").equals("1"))
				{
					c_check=true;
					this.checkTime = rs.getString("CheckTime").substring(0,10);
				} 
				else
				{
					c_check=false;
					this.checkTime="";
				}
			}
			
			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 + "'";
			sql = "SELECT * FROM MA_MAObject where projectID = '" + pId + "'";;
			rs=dbf.executeQuery(sql);
			
			
			MaObject aMaObject;
			numOfMaObject = 0;
			MaObject[] temp=new MaObject[13];
			//maObjects = new MaObject[13];
			while ((rs.next()) && (numOfMaObject < 13))
			{	
				aMaObject=new MaObject();			
				
				aMaObject.setProjectID(pId);
				aMaObject.setGatherCircle(rs.getString("GatherCircle"));
				aMaObject.setWindageGate(rs.getString("WindageGate"));
				aMaObject.setMaObject(aMaObject.tranMaObject(rs.getString("MAObjectName")));
				aMaObject.setAnalysisCircle(rs.getString("AnalysisCirle")); 
				aMaObject.setAnalyst(rs.getString("Analyst"));
				ProjectMember mem = new ProjectMember(aMaObject.getAnalyst());
				aMaObject.setAnalystName(mem.getName());
				
				temp[numOfMaObject] = aMaObject;		
				numOfMaObject++;
				System.out.println("numOfMaObject=" + numOfMaObject);	
			}
			maObjects=new MaObject[numOfMaObject];
			System.arraycopy(temp,0,maObjects,0,numOfMaObject);
			if(rs!=null) rs.close();
			if(dbf!=null) dbf.close();
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createProject:" + e.getMessage());
		}
		
	}
	
	public void setProjectID(String projectID)
	{
		this.projectID=projectID;
	}
	
	public String getProjectID()
	{
		return projectID;
	}
	
	public String getStartTime() {
		return startTime;
	}

	public void setStartTime(String startTime) {
		this.startTime = startTime;
	}
	
	public String getCheckTime() {
		return checkTime;
	}

	public void setCheckTime(String checkTime) {
		this.checkTime = checkTime;
	}
	
	public int getChangeMode()
	{
		return changeMode;
	}
	
	public void setChangeMode(int changeMode)
	{
		this.changeMode=changeMode;
	}
	
	public String getMaObject() {
		if ((curMaObjectName++)>=maObjectNames.length)
			return  "noMaObject";
		else	return  maObjectNames[curMaObjectName-1];
	}
	
	public void setAllMaObject(MaObject maObj)
	{
		if(changeMode==2)
		{
			maObj.store();
			numOfMaObject++;
			MaObject[] temp=new MaObject[numOfMaObject];
			for(int i=0;i<numOfMaObject-1;i++)
			{
				temp[i]=maObjects[i];
			}
			temp[numOfMaObject-1]=maObj;
			maObjects=temp;
		}
		else	maObjects[curMaObjectName-1]=maObj;
	} 
	
	public MaObject[] getAllMaObject()
	{
		return  maObjects;
	}
	
	public void store()
	{
		System.out.println("store maplan!!!!!!!!!!!!");
		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();
			
			java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd",java.util.Locale.CHINA);
	
			java.util.Date d; 
	
			java.sql.Date tempTime; 
			
			dbf.setSql("INSERT INTO `MA_MAPlan` VALUES (?,?,?,?)");
		    	//dbf.setSql("INSERT INTO `MA_MAPlan` VALUES ("+projectID+",true,2004-02-20,"+startTime+")");
		    	
		    	System.out.println("before sql");
			
			dbf.setString(1,projectID);
			
			if (c_check)	dbf.setString(2,"true");
			else		dbf.setString(2,"false"); 
			
			if (checkTime.equals(""))
				checkTime="3000-01-01";
			
			d = sdf.parse(checkTime);
			tempTime = new java.sql.Date(d.getTime());
			System.out.println(tempTime);
			dbf.setDate(3,tempTime);
			
			
			d = sdf.parse(startTime);
			tempTime = new java.sql.Date(d.getTime());
			System.out.println(tempTime);
			dbf.setDate(4,tempTime);
			
			dbf.execute();
			
			if(dbf!=null) dbf.close();
			
			for (int i=0;i<numOfMaObject;i++)
			{
				maObjects[i].store();
			}
			//List results of changes.  
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createMaPlan:" + e.getMessage());
		}	
	}
	
	public void delMaObject(String maObjectName)
	{
		int i,j;
		boolean find=false;
		
		j=0;
		System.out.println("in the delMaObject"+maObjectName);
		for(i=0;i<numOfMaObject;i++)
		{
			System.out.println(maObjects[i].getMaObject());
			if (maObjects[i].getMaObject().equals(maObjectName))
			{
				maObjects[i].delFromDb();
				j=i;
				find=true;
				break;
			}
		}
		
		if(find)
		{
			System.out.println(numOfMaObject);
			numOfMaObject--;
			for(i=j;i<numOfMaObject;i++)
			{
				maObjects[i]=maObjects[i+1];
			}
			MaObject[] temp=new MaObject[numOfMaObject];
			System.arraycopy(maObjects,0,temp,0,numOfMaObject);
			maObjects=temp;
			System.out.println(maObjects.length);
		}
	}
	
	public void check()
	{
		System.out.println("in the check maplan");
		//checkTime="2005-01-01";
		c_check=true;
		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();
			dbf.setSql("update MA_MAPlan set CheckTime='"+checkTime+"',MAPlanCheck=1 where ProjectId='"+projectID+"'");
		    	//dbf.setSql("INSERT INTO `MA_MAPlan` VALUES ("+projectID+",true,2004-02-20,"+startTime+")");
		    	System.out.println("before sql");
			dbf.execute();
			if(dbf!=null) dbf.close();
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in updateMaPlan:" + e.getMessage());
		}	
		//update
	}
	
	
	public void changeMaObject(MaObject changeMaObject)
	{
		for(int i=0;i<numOfMaObject;i++)
		{
			if(changeMaObject.getMaObject().equals(maObjects[i].getMaObject()))
			{
				maObjects[i]=changeMaObject;
				maObjects[i].update();
			}
		}
	}
	
	public MaObject findMaObject(String name)
	{
		for(int i=0;i<numOfMaObject;i++)
		{
			if(name.equals(maObjects[i].getMaObject()))
			{
				return maObjects[i];
			}
		}
		return null;
	}
}