rczx_zwxx_modify_action.java

这个程序是花了好几十万请人开发的

package struts.action;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionError;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletException;
import java.io.IOException;

import javabean.*;
import struts.form.*;

public class rczx_zwxx_modify_action extends Action {
//	初始化连接池	
	private ConnectionPool pool;
	
	public rczx_zwxx_modify_action()
	{
//		从连接池中获得一个连接池实例	
		pool=ConnectionPool.getInstance();
	}

	public ActionForward  execute (
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws IOException,ServletException 
		{						
			ActionErrors errors=new ActionErrors();
			Zwxx zwxx=(Zwxx)form;
						
			//声明字符转换函数\文本区处理函数\时间函数
			CodeString getstring=new CodeString();
			TextareaChange change=new TextareaChange();
			PubDate pubDate=new PubDate();
			
			//获得数据		
			int ID=zwxx.getID();
			String sid=String.valueOf(ID);
			request.setAttribute("Id",sid);			
			String JOBCATE=getstring.getString(zwxx.getJOBCATE().trim());
			String JOBNAME=getstring.getString(zwxx.getJOBNAME().trim());
			int JOBNUM=zwxx.getJOBNUM();
			String PROVINCE=getstring.getString(zwxx.getPROVINCE().trim());
			String WORKMODE=getstring.getString(zwxx.getWORKMODE().trim());
			String WORKMONEY=getstring.getString(zwxx.getWORKMONEY().trim());
			String SEX=getstring.getString(zwxx.getSEX().trim());
			String GRADE=getstring.getString(zwxx.getGRADE().trim());
			String WORKTIME=getstring.getString(zwxx.getWORKTIME().trim());
			String AGE=getstring.getString(zwxx.getAGE().trim());
			String BORNADDR=getstring.getString(zwxx.getBORNADDR().trim());
			String memo=getstring.getString(change.changeArea(zwxx.getMEMO()));
			String pbdate=pubDate.getshortPubdate();
			String VALIDTIME=getstring.getString(zwxx.getVALIDTIME().trim());
			String CLASS=getstring.getString(zwxx.getCLASS().trim());
			String LANG=getstring.getString(zwxx.getLANG().trim());		
//			数据库查询语句						
			String sql="update ZWXX set JOBCATE= "+"'"+JOBCATE+"'" +", JOBNAME= "+"'"+JOBNAME+"'"+", JOBNUM= "+"'"+JOBNUM+"'"+", PROVINCE= "+"'"+PROVINCE+"'"+", WORKMODE= "+"'"+WORKMODE+"'"+", WORKMONEY= "+"'"+WORKMONEY+"'"+
			 ", SEX= "+"'"+SEX+"'"+",GRADE= "+"'"+GRADE+"'"+", WORKTIME= "+"'"+WORKTIME+"'"+
			 ", AGE= "+"'"+AGE+"'"+", BORNADDR= "+"'"+BORNADDR+"'"+", MEMO= "+"'"+memo+"'"+", FBTIME= "+"" +
			 "'"+pbdate+"'"+", VALIDTIME= "+"'"+VALIDTIME+"'"+", CLASS= "+"'"+CLASS+"'"+", LANG= "+"'"+LANG+"'"+" where ID ="+ID+"";
			
			try{
//				创建ZwxxBO的一个实例，处理从表单获得的form数据								
				ZwxxBO zwxxBO=new ZwxxBO();
				zwxxBO.updateZwxx(sql,zwxx);
				
				return mapping.findForward("success");
			}
//			捕获一些可能的错误            			
			catch(Throwable e)
			{
				e.printStackTrace();
				ActionError error=new ActionError(e.getMessage());
				errors.add(ActionErrors.GLOBAL_ERROR,error);
			}
			saveErrors(request,errors);
			return new ActionForward(mapping.getInput());
		}
}