requirementform.java

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

				this.setImplementTime(rs.getString("ImplementTime"));
				this.setImplementDoc(rs.getString("ImplementDoc"));
				this.setTestTime(rs.getString("TestTime"));
				this.setTestDoc(rs.getString("TestDoc"));
				this.setSource(rs.getString("source"));
				this.setProposer(rs.getString("Proposer"));
				this.setRequiredesc(rs.getString("Requiredesc"));
				this.setStatus(rs.getString("Status"));							
			}
				
		}
		catch (Exception e)   	
		{
			logger.error("Exception in getRequirementTraceInfor:" + e.getMessage());
			
		}
		finally
		{
			close();
		}
				
	}
	
	
	public void delRequirement(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 = "delete FROM rm_requirement where requirementID = " + requirementID ;
					dbf.setSql(sql);
					dbf.execute();	
					
					logger.info("execute" + sql + "in delRequirement");								
			}
			catch (Exception e)   	
			{
				logger.error("Exception in getRequirementInfor:" + e.getMessage());
			}
	}
	
	public void updateRequirement() {
		try{
					//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
					//Get an instance reference to the DbFacade object
					dbf = new SqlDB();
					String sql = "update rm_requirement set ";
					sql += " requirementName ='" + this.requirementName + "',";
					sql += " proposer ='" + this.proposer + "',";
					sql += "source ='" + this.source + "',";
					sql += "getTime ='" + this.getTime + "',";
					sql += "status = '" + this.status + "',";
					sql += "requiredesc = '" + this.requiredesc + "'";
					sql += " where requirementid =" + this.requirementID;
					
					logger.info("------before execute:" + sql + "in updateRequirement");
					dbf.setSql(sql);
					dbf.execute();						
					
			}
			catch (Exception e)   	
			{
				logger.error("Exception in updateRequirement:" + e.getMessage());
			}
			finally
			{
				close();
			}
	}
	
	public void updateRequirementTrace() {
		try{
					//PooledConnectionMgr.getInstance().initialize(30,"192.168.15.150",3306,"CMMI2PM");
					//Get an instance reference to the DbFacade object
					dbf = new SqlDB();
					String sql = "update rm_requirement set ";
					sql += " getTime ='" + this.getTime + "',";
					sql += " getDoc ='" + this.getDefineDoc() + "',";
					sql += " analyseTime ='" + this.analyseTime + "',";
					sql += " analyseDoc ='" + this.analyseDoc + "',";
					sql += " generalDesignTime ='" + this.generalDesignTime + "',";
					sql += " generalDesignDoc ='" + this.generalDesignDoc + "',";
					sql += " detailDesignTime ='" + this.detailDesignTime + "',";
					sql += " detailDesignDoc ='" + this.detailDesignDoc + "',";
					sql += " implementTime ='" + this.implementTime + "',";
					sql += " implementDoc ='" + this.implementDoc + "',";
					sql += " testTime ='" + this.testTime + "',";
					sql += " testDoc ='" + this.testDoc + "'";
					sql += " where requirementid =" + this.requirementID;
					
					logger.info("------before execute:" + sql + "in updateRequirementTrace");
					dbf.setSql(sql);
					dbf.execute();									
					
			}
			catch (Exception e)   	
			{
				logger.error("Exception in updateRequirementTrace:" + e.getMessage());
			}
			finally
			{
				close();
			}
	}
	
	
	
	
	
	
	public String getRequirementID() {
		 return requirementID;
	 }

	 public void setRequirementID(String requirementID) {
		 this.requirementID = requirementID;
	 }
	 
	 public String getProject() {
		 return project;
	 }

	
	 public void setProject(String project) {
		 this.project = project;
	 }

	 public String getRequirementName() {
		 return requirementName;
	 }

	 public void setRequirementName(String requirementName) {
		 this.requirementName = requirementName;
	 }

	public String getSource() {
		 return source;
	 }

	 public void setSource(String source) {
		 this.source = source;
	 }
	 
	  public String getProposer() {
		 return proposer;
	 }

	 public void setProposer(String proposer) {
		 this.proposer = proposer;
	 }

	public String getRequiredesc() {
		 return requiredesc;
	 }

	public void setRequiredesc(String requiredesc) {
		 this.requiredesc = requiredesc;
	 }

	public String getStatus() {
		 return status;
	 }

	 public void setStatus(String status) {
		 this.status = status;
	 }

	public String getGetTime() {
		 return getTime;
	 }

	public void setGetTime(String getTime) {
		 this.getTime = getTime;
	 }
/*	 
	public String getGetDoc() {
		 return getDoc;
	 }
	 
	public String setGetDoc(String getDoc) {
		 return this.getDoc = getDoc;
	 }
*/	 
	public String getDefineDoc() {
		 return defineDoc;
	 }
	 
	public String setDefineDoc(String defineDoc) {
		 return this.defineDoc = defineDoc;
	 }

	public void setAnalyseDoc(String analyseDoc) {
		 this.analyseDoc = analyseDoc;
	 }
	 
	 public String getAnalyseDoc() {
		 return analyseDoc;
	 }

	public void setAnalyseTime(String analyseTime) {
		 this.analyseTime = analyseTime;
	 }
	 
	 public String getAnalyseTime() {
		 return analyseTime;
	 }

	public void setGeneralDesignDoc(String generalDesignDoc) {
		 this.generalDesignDoc = generalDesignDoc;
	 }
	 
	 public String getGeneralDesignDoc() {
		 return generalDesignDoc;
	 }
	 
	 public void setGeneralDesignTime(String generalDesignTime) {
		 this.generalDesignTime = generalDesignTime;
	 }
	 
	 public String getGeneralDesignTime() {
		 return generalDesignTime;
	 }

	public void setDetailDesignDoc(String detailDesignDoc) {
		 this.detailDesignDoc = detailDesignDoc;
	 }
	 
	 public String getDetailDesignDoc() {
		 return detailDesignDoc;
	 }
	 
	 public void setDetailDesignTime(String detailDesignTime) {
		 this.detailDesignTime = detailDesignTime;
	 }
	 
	 public String getDetailDesignTime() {
		 return detailDesignTime;
	 }

	public void setImplementDoc(String implementDoc) {
		 this.implementDoc = implementDoc;
	 }
	 
	 public String getImplementDoc() {
		 return implementDoc;
	 }
	 
	 public void setImplementTime(String implementTime) {
		 this.implementTime = implementTime;
	 }
	 
	 public String getImplementTime() {
		 return implementTime;
	 }
	 
	 public void setTestDoc(String testDoc) {
		 this.testDoc = testDoc;
	 }
	 
	 public String getTestDoc() {
		 return testDoc;
	 }
	 
	 public void setTestTime(String testTime) {
		 this.testTime = testTime;
	 }
	 
	 public String getTestTime() {
		 return testTime;
	 }

	
	
	

}