requirementform.java

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

package com.cmmi2pms.rm;

/**
 * @author lxj
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import com.cmmi2pms.common.comdb.*;
import com.cmmi2pms.common.*;
import org.apache.log4j.Logger;


public class RequirementForm extends ActionForm {
//	--------------------------------------------------------- Instance Variables
    private String requirementID;
    private String    project;
    private String    requirementName;
    private String    source;
    private String    proposer;
    private String    requiredesc;
    private String    status;
    private String    getTime;
    //private String    getDoc;
    private String    defineDoc;
    private String    analyseTime;
    private String    analyseDoc;
    private String    generalDesignTime;
    private String    generalDesignDoc;
    private String    detailDesignTime;
    private String    detailDesignDoc;
    private String    implementTime;
    private String    implementDoc;
    private String    testTime;
    private String    testDoc;
    
    
    private SqlDB dbf;
	private ResultSet rs;

	 
	 private static Logger logger = Logger.getLogger ("RequirementForm") ;
	 
	 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 RequirementForm[] getAllRequirement(String projectID){
		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 * from rm_Requirement ";
			sql += " where projectid =" + projectID + " order by requirementID ";
			rs=dbf.executeQuery(sql);			
			
			int rowNum = 0;
			ArrayList requirementArrayList = new ArrayList();
			while ((rs.next())){				
				RequirementForm aRequirement = new RequirementForm();
				aRequirement.setRequirementID(rs.getString("RequirementID"));
				aRequirement.setRequirementName(rs.getString("RequirementName"));
				aRequirement.setProject(projectID);
				aRequirement.setSource(rs.getString("source"));
				aRequirement.setProposer(rs.getString("Proposer"));
				aRequirement.setRequiredesc(rs.getString("Requiredesc"));
				aRequirement.setStatus(rs.getString("Status"));
				aRequirement.setGetTime(rs.getString("GetTime"));
				requirementArrayList.add(aRequirement);		
				rowNum++;
				//System.out.println("rowNum:" + rowNum);	
			}
			RequirementForm[] requirements = new RequirementForm[requirementArrayList.size()];
			requirementArrayList.toArray(requirements);
			
			return requirements;
	
		}
		catch (Exception e)   	
		{
			logger.error("Exception in getAllRequire:" + e.getMessage());
			return null;
		}
		finally
		{
			close();
		}
				
	}
	 
	 public RequirementForm[] getAllRequirementTrace(String projectID){
		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 * from rm_Requirement ";
			sql += " where projectid =" + projectID + " order by requirementID ";
			rs=dbf.executeQuery(sql);			
			
			int rowNum = 0;
			ArrayList requirementArrayList = new ArrayList();
			while ((rs.next())){				
				RequirementForm aRequirement = new RequirementForm();
				aRequirement.setRequirementID(rs.getString("RequirementID"));
				aRequirement.setRequirementName(rs.getString("RequirementName"));
				aRequirement.setGetTime(rs.getString("getTime"));
				//aRequirement.setGetDoc(rs.getString("getDoc"));
			aRequirement.setDefineDoc(rs.getString("getDoc"));
				aRequirement.setAnalyseTime(rs.getString("AnalyseTime"));
				aRequirement.setAnalyseDoc(rs.getString("AnalyseDoc"));
				aRequirement.setGeneralDesignTime(rs.getString("GeneralDesignTime"));
				aRequirement.setGeneralDesignDoc(rs.getString("GeneralDesignDoc"));
				aRequirement.setDetailDesignTime(rs.getString("DetailDesignTime"));
				aRequirement.setDetailDesignDoc(rs.getString("DetailDesignDoc"));
				aRequirement.setImplementTime(rs.getString("ImplementTime"));
				aRequirement.setImplementDoc(rs.getString("ImplementDoc"));
				aRequirement.setTestTime(rs.getString("TestTime"));
				aRequirement.setTestDoc(rs.getString("TestDoc"));
				aRequirement.setSource(rs.getString("source"));
				aRequirement.setProposer(rs.getString("Proposer"));
				aRequirement.setRequiredesc(rs.getString("Requiredesc"));
				aRequirement.setStatus(rs.getString("Status"));
				requirementArrayList.add(aRequirement);		
				rowNum++;
				//System.out.println("rowNum:" + rowNum);	
			}
			RequirementForm[] requirements = new RequirementForm[requirementArrayList.size()];
			requirementArrayList.toArray(requirements);
			
			return requirements;
	
		}
		catch (Exception e)   	
		{
			logger.error("Exception in getAllRequire:" + e.getMessage());
			return null;
		}
		finally
		{
			close();
		}
				
	}
          
     
     public void createRequirement(String projectID) {
		
		try{
			//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
			//Get an instance reference to the DbFacade object
			dbf = new SqlDB();
							
			String sql = "Insert into rm_requirement(requirementid,projectid,requiredesc,";
			sql += "requirementName,source,proposer,Status,getTime) values(";
			
			int newID = CommonFuncs.getCurrentID("requirementID","rm_requirement");
			sql += newID + ",";
			sql += projectID + ",";
			sql += "'" + this.requiredesc + "',";
			sql += "'" + this.requirementName + "',";
			sql += "'" + this.source + "',";
			sql += "'" + this.proposer+ "',";
			sql += "'" + this.status + "',";
			sql += "'" + this.getTime + "'";
			sql += ")";
			
			logger.info("SQL in createRequirement:" + sql);
			
			dbf.setSql(sql);		    
		   
			dbf.execute();		
			
			dbf.close();	
			
			logger.info("Requirement" + this.getRequirementName() + "is created");
		}
		catch (Exception e)   	
		{
			logger.error("Exception in create Requirement:" + e.getMessage());
		}
		finally
		{
			close();
		}
     }
    
   
	public void getRequirementInfor(String requirementID) {
		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 * from rm_requirement ";
					sql += " where requirementID =" + requirementID ;
					
					rs=dbf.executeQuery(sql);	
					
					logger.info("executeQuery:" + sql + "in getRequirementInfor");			
			
					if (rs.next())
					{
						this.project = rs.getString("projectid");
						this.requirementName = rs.getString("requirementName");
						this.requiredesc = rs.getString("requiredesc");
						this.requirementID = rs.getString("requirementid");
						this.proposer = rs.getString("proposer");
						this.source = rs.getString("source");
						this.getTime = rs.getString("getTime");	
						this.status = rs.getString("status");					     					
					}
					
			}
			catch (Exception e)   	
			{
				logger.error("Exception in getRequirementInfor:" + e.getMessage());
			}
			finally
			{
				close();
			}
	}
	
	public void getRequirementTraceInfor(String requirementID){
		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 * from rm_Requirement ";
			sql += " where requirementID =" + requirementID;
			rs=dbf.executeQuery(sql);			
			
			if ((rs.next())){				
				this.setRequirementID(rs.getString("RequirementID"));
				this.setRequirementName(rs.getString("RequirementName"));
				this.setGetTime(rs.getString("getTime"));
				//this.setGetDoc(rs.getString("getDoc"));
			this.setDefineDoc(rs.getString("getDoc"));
				this.setAnalyseTime(rs.getString("AnalyseTime"));
				this.setAnalyseDoc(rs.getString("AnalyseDoc"));
				this.setGeneralDesignTime(rs.getString("GeneralDesignTime"));
				this.setGeneralDesignDoc(rs.getString("GeneralDesignDoc"));
				this.setDetailDesignTime(rs.getString("DetailDesignTime"));
				this.setDetailDesignDoc(rs.getString("DetailDesignDoc"));