workload.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 Workload 
{
	private  String   projectId;
	private  String   taskId;
	private  String   taskName;
	private  String   layer;
	private  String   planWorkload;
	private  String   actualWorkload;
	private  String   lag;
	private  double   lagDou;
	private	 String   lagRate;
	private  double   lagRateDou;
	private	 String	  workloadLagFlag;
	private  boolean  forMa;
	private  double   windageGate;
	private  String   maReportId;
	
	public String  getWorkloadLagFlag() {
		return workloadLagFlag;
	}

	public void setWorkloadLagFlag(String  workloadLagFlag) {
		this.workloadLagFlag = workloadLagFlag;
	}
	
	public String  getMaReportId() {
		return maReportId;
	}

	public void setMaReportId(String  maReportId) {
		this.maReportId = maReportId;
	}
	
	public double getWindageGate() {
		return windageGate;
	}

	public void setWindageGate(double windageGate) {
		this.windageGate = windageGate;
	}
	
	public String getProjectId() {
		return projectId;
	}

	public void setProjectId(String projectId) {
		this.projectId = projectId;
	}
			
	public String getTaskId() {
		return taskId;
	}

	public void setTaskId(String taskId) {
		this.taskId = taskId;
	}
	
	public String getTaskName() {
		return taskName;
	}

	public void setTaskName(String taskName) {
		this.taskName = taskName;
	}
	
	public String getLayer() {
		return layer;
	}

	public void setLayer(String layer) {
		this.layer = layer;
	}
	
	public String getPlanWorkload() {
		return planWorkload;
	}

	public void setPlanWorkload(String planWorkload) {
		this.planWorkload = planWorkload;
	}
	public String getActualWorkload() {
		return actualWorkload;
	}

	public void setActualWorkload(String actualWorkload) {
		this.actualWorkload = actualWorkload;
	}
	
	public String getLag() {
		return lag;
	}

	public void setLag(String lag) {
		this.lag = lag;
	}
	
	public String getLagRate() {
		return lagRate;
	}

	public void setLagRate(String lagRate) {
		this.lagRate = lagRate;
	}
	
	public void getPlanWorkloadFormDb()
	{
		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 pp_workloadestimate where projectID = '" + projectId + "' and trackid = 0";
			rs=dbf.executeQuery(sql);					
			
			if (rs.next())
			{
				this.planWorkload=rs.getString("workload");
			}
			
			if(rs!=null) rs.close();
			if(dbf!=null) dbf.close();
		
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createMaObject:" + e.getMessage());
		}
	}
	
	
	public void store()
	{
		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 = sdf.parse(theProjectForm.getStartTime());  
	
			//java.sql.Date startTime = new java.sql.Date(d.getTime());
			
			dbf.setSql("INSERT INTO `MA_WorkLoad` VALUES (?,?,?,?,?,?,?,?,?)");
		    
		    	System.out.println("before sql");
			
			System.out.println(taskId+":"+projectId+":"+planWorkload+":"+actualWorkload+":"+lagDou+":"+lagRateDou+":"+taskName+":"+maReportId);
			
			dbf.setInt(1,Integer.parseInt(taskId));
			dbf.setString(2,projectId);
			dbf.setInt(3,Integer.parseInt(planWorkload));
			dbf.setInt(4,Integer.parseInt(actualWorkload));
			dbf.setDouble(5,lagDou);
			dbf.setDouble(6,lagRateDou);
			if (workloadLagFlag.equals("yes"))
				dbf.setInt(7,1);
			else	dbf.setInt(7,0);
			dbf.setString(8,taskName);
			dbf.setInt(9,Integer.parseInt(maReportId));
			
			dbf.execute();
			if(dbf!=null) dbf.close();
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createMaWorkload:" + e.getMessage());
		}
	}
	
	public void ma()
	{
		double temp1,temp2;
		temp1=Double.parseDouble(actualWorkload);
		temp2=Double.parseDouble(planWorkload);
		lagDou=temp1-temp2;
		//lag="30";
		lag=Double.toString(lagDou);
		lagRateDou=100*(lagDou/temp2);
		lagRate=Double.toString(lagRateDou);
		if(lagRateDou>=windageGate)
			workloadLagFlag="yes";
		else	workloadLagFlag="no";
		//lagRate="0.8";
	}
	
}