maobject.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 MaObject 
{
	private  String projectID;
	private  String maObject;
	private  String analyst;
	private  String analysisCircle;
	private  String gatherCircle;
	private  String windageGate;
	private  String analystName;
	
	public MaObject()
	{
	}
	
	public MaObject(String pId,String name)
	{
		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_MAObject where projectID = '" + pId + "' and MaObjectName = '" + tranMaObject(name) + "'";
			rs=dbf.executeQuery(sql);					
			
			if (rs.next())
			{
				this.projectID=pId;
				this.gatherCircle=rs.getString("GatherCircle");
				this.windageGate=rs.getString("WindageGate");
				this.maObject=tranMaObject(rs.getString("MAObjectName"));
				this.analysisCircle=rs.getString("AnalysisCirle"); 
				this.analyst=rs.getString("Analyst");
				ProjectMember mem = new ProjectMember(analyst);
				this.analystName=mem.getName(); 
			}
			if(rs!=null) rs.close();
			if(dbf!=null) dbf.close();
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createMaObject:" + e.getMessage());
		}
	}
	
	public String getAnalystName() {
		return analystName;
	}

	public void setAnalystName(String analystName) {
		this.analystName = analystName;
	}
			
	public String getGatherCircle() {
		return gatherCircle;
	}

	public void setGatherCircle(String gatherCircle) {
		this.gatherCircle = gatherCircle;
	}
	
	public String getWindageGate() {
		return windageGate;
	}

	public void setWindageGate(String windageGate) {
		this.windageGate = windageGate;
	}
	
	public String getProjectID() {
		return projectID;
	}

	public void setProjectID(String projectID) {
		this.projectID = projectID;
	}
	
	public String getMaObject() {
		return maObject;
	}

	public void setMaObject(String maObject) {
		this.maObject = maObject;
	}
	public String getAnalysisCircle() {
		return analysisCircle;
	}

	public void setAnalysisCircle(String analysisCircle) {
		this.analysisCircle = analysisCircle;
	}
	
	public String getAnalyst() {
		return analyst;
	}

	public void setAnalyst(String analyst) {
		this.analyst = analyst;
	}
	
	public void store()
	{
		System.out.println("store maObject::::::::::");
		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_MAObject` VALUES (?,?,?,?,?,?)");
		    
		    	System.out.println("before sql");
			
			dbf.setString(1,projectID);
			System.out.println(tranMaObjectName(maObject));
			dbf.setInt(2,tranMaObjectName(maObject));
			dbf.setInt(3,Integer.parseInt(analyst));
			dbf.setString(4,gatherCircle);
			dbf.setString(5,analysisCircle);
			dbf.setDouble(6,Double.parseDouble(windageGate));//临时
			dbf.execute();
			//List results of changes.
			if(dbf!=null) dbf.close();  
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in createMaObject:" + 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_MAObject set projectID='"+projectID+"',MAObjectName='"+tranMaObject(maObject)+"'";
			sql=sql+",Analyst='"+analyst+"',GatherCircle='"+gatherCircle+"',AnalysisCirle='"+analysisCircle+"',WindageGate='"+windageGate+"' "; 
			sql=sql+"where  projectID='"+projectID+"'and MAObjectName='"+tranMaObject(maObject)+"'";
			dbf.setSql(sql);
		    	//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());
		}
		
	}
	
	public void creatMaObject(MaObjectForm maObjectForm,String projectId)
	{		
		setProjectID(projectId);
		setGatherCircle(maObjectForm.getGatherCircle());
		setAnalysisCircle(maObjectForm.getAnalysisCircle());
		setWindageGate(maObjectForm.getWindageGate());
		setMaObject(maObjectForm.getMaObject());
		setAnalyst(maObjectForm.getAnalyst());
		ProjectMember mem = new ProjectMember(analyst);
		setAnalystName(mem.getName());
		//store();	
	}
	
	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. 
			if(dbf!=null) dbf.close(); 
		}
		catch (Exception e)   	
		{
			System.out.println("Exception in deleteMaObject:" + e.getMessage());
		}
		
	}
	
	public int tranMaObjectName(String name)
	{
		System.out.println("in the tranMaObjectName"+name);
		if (name.equals("Workload"))
			return 1;
		else if(name.equals("ProjectProcess"))	
			return 2;	
		else if(name.equals("PaWorkload"))	
			return 3;
		else return 0;
	}
	
	public static String tranMaObject(String name)
	{
		System.out.println("in tranMaObject:" + name);
		if (name.equals("1"))
			return  "Workload";
		else if(name.equals("2"))	
			return  "ProjectProcess";	
		else if(name.equals("3"))	
			return  "PaWorkload";
		else if(name.equals("Workload"))	
			return  "1";
		else if(name.equals("ProjectProcess"))	
			return  "2";
		else if(name.equals("PaWorkload"))	
			return  "3";
		else return "NotDefine";
	}
	
	public String getAnalysisLayer()
	{
		if (maObject.equals("Workload"))
		{
			if (analysisCircle.equals("一级任务完成"))
				return "1";
			else if (analysisCircle.equals("二级子任务完成"))
				return "2";		
		}
		else if (maObject.equals("ProjectProcess"))
		{
			if (analysisCircle.equals("一级任务完成"))
				return "1";
			else if (analysisCircle.equals("二级子任务完成"))
				return "2";		
		}
		return null;
	}
	
	public String getGatherLayer()
	{
		if (maObject.equals("Workload"))
		{
			if (gatherCircle.equals("一级任务完成"))
				return "1";
			else if (gatherCircle.equals("二级子任务完成"))
				return "2";		
		}
		else if (maObject.equals("ProjectProcess"))
		{
			if (gatherCircle.equals("一级任务完成"))
				return "1";
			else if (gatherCircle.equals("二级子任务完成"))
				return "2";		
		}
		return null;
	}
}