addreportmarkaction.java

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

// Created by Xslt generator for Eclipse.
// XSL :  not found (java.io.FileNotFoundException:  (系统找不到指定的路径。))
// Default XSL used : easystruts.jar$org.easystruts.xslgen.JavaClass.xsl

package com.cmmi2pms.pmc.assess;

import com.cmmi2pms.pmc.report.*;
import com.cmmi2pms.common.comdb.*;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

/** 
 * AddReportMarkAction.java created by EasyStruts - XsltGen.
 * http://easystruts.sf.net
 * created on 05-23-2004
 * 
 * XDoclet definition:
 * @struts:action path="/addReportMark" name="addReportMarkForm" input="/pages/PMC/assess/addReportMark.jsp"
 */
public class AddReportMarkAction extends Action {

	// --------------------------------------------------------- Instance Variables

	// --------------------------------------------------------- Methods

	/** 
	 * Method execute
	 * @param ActionMapping mapping
	 * @param ActionForm form
	 * @param HttpServletRequest request
	 * @param HttpServletResponse response
	 * @return ActionForward
	 * @throws Exception
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
		AddReportMarkForm addReportMarkForm = (AddReportMarkForm) form;
		
		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();
			
			WorkReport report=new WorkReport();
			report = (WorkReport) request.getSession().getAttribute("selectedReport");
			
			String sql="update pmc_workreportlist ";
				   sql+="set hasred=1,mark="+'"'+addReportMarkForm.getMark()+'"'+",";
				   sql+="review="+'"'+addReportMarkForm.getDescrib()+'"'+",";
				   sql+="nextjob="+'"'+addReportMarkForm.getNextjob()+'"';
				   sql+=" where reportid="+report.getReportid();
			System.out.println(sql);
			dbf.setSql(sql);
			dbf.execute();
			
			if(dbf!=null) dbf.close();
		}
		catch(Exception e){
			System.out.println("error in AddReportMarkAction:"+e.getMessage());
		}
		
		return(mapping.findForward("success"));
		//throw new UnsupportedOperationException("Generated method 'execute(...)' not implemented.");
	}

}