office_membermodifyaction.java

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

/*
 * 
 * @author 郑文金
 *
 * 这个action用于在"网上办公室"中修改个人的信息
 *
 */
package struts.action;
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;
import javax.servlet.http.HttpSession;
import struts.form.Office_membermodifyForm;
import javabean.*;
import java.sql.*;

public class Office_membermodifyAction extends Action {
	
	private ConnectionPool pool;
	private Connection con;
	public Office_membermodifyAction() throws SQLException
	{
		pool=ConnectionPool.getInstance();               //初始化连接池

	}
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception 
	{
		HttpSession session=request.getSession();
		Office_membermodifyForm modifyform =
			(Office_membermodifyForm) form;
			
		CodeString getstring=new CodeString();
		
		String answer=modifyform.getANSWER().trim();
		answer=getstring.getString(answer);
		
		String company=modifyform.getCOMPANY().trim();
		company=getstring.getString(company);
		
		String email=modifyform.getEMAIL().trim();
		email=getstring.getString(email);
		
		String question=modifyform.getQUESTION().trim();
		question=getstring.getString(question);
		
		String rname=modifyform.getRNAME().trim();
		rname=getstring.getString(rname);
		
		String sex=modifyform.getSEX().trim();
		sex=getstring.getString(sex);
		
		String user_address=modifyform.getUSER_ADDRESS().trim();
		user_address=getstring.getString(user_address);
		
		String user_city=modifyform.getUSER_CITY().trim();
		user_city=getstring.getString(user_city);
		
		String user_homeph=modifyform.getUSER_HOMEPH().trim();	
		user_homeph=getstring.getString(user_homeph);
		
		String user_mobileph=modifyform.getUSER_MOBILEPH().trim();
		user_mobileph=getstring.getString(user_mobileph);
		
		String user_officeph=modifyform.getUSER_OFFICEPH().trim();
		user_officeph=getstring.getString(user_officeph);
		
		String user_post_code=modifyform.getUSER_POST_CODE().trim();
		user_post_code=getstring.getString(user_post_code);
		
		String user_province=modifyform.getUSER_PROVINCE().trim();
		user_province=getstring.getString(user_province);
		
		String homepage=modifyform.getHOMEPAGE().trim();
		homepage=getstring.getString(homepage);
		
		con=pool.getConnection();  //从池中获得一个连接	
		String uid=(String)session.getAttribute("uid");			
		
		Member_dao membermodify =new Member_dao(con);
		
		
		if(membermodify.con!=null)//如果数据库连接成功	
		{	

			String sql="update member set RNAME= "+"'"+rname+"'" +", SEX= "+"'"+sex+"'"+", COMPANY= "+
			"'"+company+"'"+", HOMEPAGE= "+"'"+homepage+"'"+", USER_ADDRESS= "+"'"+user_address+"'"+", USER_POST_CODE= "+"'"+user_post_code+"'"+
			 ", USER_CITY= "+"'"+user_city+"'"+",USER_PROVINCE= "+"'"+user_province+"'"+", USER_MOBILEPH= "+"'"+user_mobileph+"'"+
			 ", USER_HOMEPH= "+"'"+user_homeph+"'"+", USER_OFFICEPH= "+"'"+user_officeph+"'"+", EMAIL= "+
			"'"+email+"'"+", QUESTION= "+"'"+question+"'"+", ANSWER= "+"'"+answer+"'"+" where UUID = '"+uid+"'" ;
			String msg1=membermodify.update(sql);
			
			String sql1="update USERTABLE set RNAME= "+"'"+rname+"'"+", SEX= "+"'"+sex+"'"+" where UUID= '"+uid+"'";
			membermodify.update(sql1);
			String sql2="update txlb set RNAME= "+"'"+rname+"'"+", COMPANY= "+"'"+company+"'"+" where CUID= '"+uid+"'";
			membermodify.update(sql2);									
		
			
			modifyform.reset(mapping,request);
			con.commit();
			con.close();
			if(msg1.equals("success"))//如果修改成功
			{
				return mapping.findForward("office_membermodify_confirm");
			}
			else
			return mapping.findForward("office_membermodify");
		}
		else
		{
			return mapping.findForward("DbErrorPage");
		}
		
	}

}