office_chpwdaction.java

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

/*
 * 
 * @author 郑文金
 *
 * 这个action用于在网上办公室中修改密码
 *
 */
package struts.action;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
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 struts.form.Office_ChpwdForm;
import java.sql.*;
import javabean.*;

public class Office_ChpwdAction extends Action {

	private ConnectionPool pool;
	private Connection con;
	public Office_ChpwdAction() throws SQLException
	{
		pool=ConnectionPool.getInstance();               //初始化连接池	
	}
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception 
	{
		ActionErrors errors=new ActionErrors();
		Office_ChpwdForm chpwdForm = (Office_ChpwdForm) form;
		CodeString codestring=new CodeString();
		HttpSession session=request.getSession();
		String pwd=chpwdForm.getNew1password().trim();//获得新密码
		String old_pwd=chpwdForm.getPassword().trim();//获取旧密码
		String old_pwd1="";
		String msg="";
		con=pool.getConnection();  //从池中获得一个连接	
		Member_dao update=new Member_dao(con);
		if(update.con!=null)//如果数据库连接成功
		{
			String uid=(String)session.getAttribute("uid");
			String s="select * from member where uuid ="+"'"+uid+"'";
			ResultSet rs=update.query(s);
			while(rs.next())
			{
				old_pwd1=rs.getString("pwd").trim();
				old_pwd1=codestring.getString(old_pwd1);
			}
			rs.close();
			
			if(!old_pwd.equals(old_pwd1))
			{
				
				errors.add("newpassword",new ActionError("office_newpassword.error"));
				saveErrors(request,errors);
				chpwdForm.reset(mapping,request);
			}
			else
			{
				String str1="update member set PWD= "+"'"+pwd+"'"+" where UUID= "+"'"+uid+"'";
				String str2="update usertable set pwd= "+"'"+pwd+"'"+" where UUID= "+"'"+uid+"'";
				update.update(str1);
				update.update(str2);
				form.reset(mapping,request);
				msg=update.update(str1);//返回修改是否成功的标志
				con.commit();
			}
			con.close();
			if(msg.equals("success"))
			{
				return mapping.findForward("office_chpwd_confirm");
			}
			else
			
			return mapping.findForward("office_chpwd");
		}
		else//如果失败就返回错误页面
		{
			return mapping.findForward("DbErrorPage");
		}		
	}

}