mareport.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 MaReport 
{
	private  String   maReportId;
	private  String   projectId;
	private  MaObject maObject;
	private  String   analysisResult;
	private  String   remedy;
	private  String   analysisTime;
	private  String   checkTime;
	private	 String   maObjectName;
	private  boolean  c_check;
	private  int	  mode;
	
	public MaReport(String maObjName,String pId,boolean getMaObject)
	{
		mode=0;
		if (getMaObject)
			this.maObject=new MaObject(pId,maObjName);
		maObjectName=maObjName;
		projectId=pId;
		checkTime="";
		c_check=false;
		analysisTime="2004-01-01";
	}
	
	public int getMode() {
		return mode;
	}

	public void setMode(int mode) {
		this.mode = mode;
	}
	
	public String getMaObjectName() {
		return maObjectName;
	}

	public void setMaObjectName(String maObjectName) {
		this.maObjectName = maObjectName;
	}
	
	public String getMaReportId() {
		return maReportId;
	}

	public void setMaReportId(String maReportId) {
		this.maReportId = maReportId;
	}
			
	public String getProjectId() {
		return projectId;
	}

	public void setProjectId(String projectId) {
		this.projectId = projectId;
	}
	
	public MaObject getMaObject() {
		return maObject;
	}

	public void setMaObject(MaObject maObject) {
		this.maObject = maObject;
	}
	
	public String getAnalysisResult() {
		return analysisResult;
	}

	public void setAnalysisResult(String analysisResult) {
		this.analysisResult = analysisResult;
	}
	
	public String getRemedy() {
		return remedy;
	}

	public void setRemedy(String remedy) {
		this.remedy = remedy;
	}
	public String getAnalysisTime() {
		return analysisTime;
	}

	public void setAnalysisTime(String analysisTime) {
		this.analysisTime = analysisTime;
	}
	
	public String getCheckTime() {
		return checkTime;
	}

	public void setCheckTime(String checkTime) {
		this.checkTime = checkTime;
	}
	
	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_MAReport` VALUES (?,?,?,?,?,?,?,?,?)");
		    
		    	System.out.println("before sql");
			
			java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd",java.util.Locale.CHINA);
			java.util.Date d; 
			java.sql.Date tempTime; 
			
			dbf.setInt(1,Integer.parseInt(maReportId));
			dbf.setString(2,projectId);
			dbf.setInt(3,Integer.parseInt(maObject.getAnalyst()));
			dbf.setString(4,analysisResult);
			dbf.setString(5,remedy);
			
			d = sdf.parse(analysisTime);
			tempTime = new java.sql.Date(d.getTime());
			System.out.println(tempTime);
			dbf.setDate(6,tempTime);
			
			if (c_check)	dbf.setInt(7,1);
			else		
			{
				dbf.setInt(7,0);//for test
				checkTime="3000-01-01"; 
			}
			
			d = sdf.parse(checkTime);
			tempTime = new java.sql.Date(d.getTime());
			System.out.println(tempTime);
			dbf.setDate(8,tempTime);
			
			dbf.setInt(9,maObject.tranMaObjectName(maObject.getMaObject()));
			
			dbf.execute();
			if(dbf!=null) dbf.close();
			//List results of changes.  
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createMaReport:" + e.getMessage());
		}
	}
	
	public void update()
	{
		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();
			String sql="update MA_MAReport set AnalysisResult='"+analysisResult+"',Remedy='"+remedy+"'";
			sql=sql+"where ProjectId='"+projectId+"' and MAReportId="+Integer.parseInt(maReportId)+" and MaObject="+Integer.parseInt(MaObject.tranMaObject(maObjectName));
			dbf.setSql(sql);
		    	System.out.println("before sql");
			dbf.execute();
			if(dbf!=null) dbf.close();
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in updateMaReport:" + e.getMessage());
		}
	}
	
	
	public void delFromDb()
	{
		/*
		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("DELETE  FROM MA_MAObject where MAObjectName = '" + tranMaObject(maObject) + "'");
		    
		    	System.out.println("before sql");
			
			dbf.execute();
			//List results of changes.  
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in deleteMaObject:" + e.getMessage());
		}
		*/
	}
	
	public String getAnalysisLayer()
	{
		return maObject.getAnalysisLayer();
	}
	
	public String getGatherLayer()
	{
		System.out.println("*****************"+maObject.getGatherCircle()+maObject.getGatherLayer());
		return maObject.getGatherLayer();
	}
	
	public void setText(MaReportForm form)
	{
		analysisResult=form.getAnalysisResult();
		remedy=form.getRemedy();
	}
	
	public WorkloadList getWorkloadList()
	{
		System.out.println("in the getWorkloadList");
		WorkloadList workloadList=new WorkloadList(maReportId);
		return	workloadList; 
	}
	
	public ProcessList getProcessList()
	{
		System.out.println("in the getProcessList");
		ProcessList processList=new ProcessList(maReportId);
		return	processList; 
	}
}