changepasswordaction.java

来自「医院信息系统(Hospital Information System」· Java 代码 · 共 77 行

package hospital.Controller.Actions.Logon;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import java.sql.*;
import hospital.Foundation.*;

public class ChangePasswordAction extends Action {
    String oldPassword = "";
    String newPassword = "";
    String successFlag = "0";

    public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) {
        String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
        String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=hospital";
        String userName = "sa";
        String userPwd = "";
        Connection dbConn;

        try {
            Class.forName(driverName);
            dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
            Statement stmt = dbConn.createStatement();

            //初始化页面的所有参数
            initPageParameters(form, request);

            if (!oldPassword.equals("")) {
                changePassword(stmt);
            }

            stmt.close();
            dbConn.close();

        } catch (Exception ex) {
            ex.printStackTrace();
        }

        returnPageParameters(request);
        return mapping.findForward("password");
    }

    private void setPropertyToOrginate() {
        oldPassword = "";
        newPassword = "";
        successFlag = "0";
    }

    private void initPageParameters(ActionForm form, HttpServletRequest request) {
        setPropertyToOrginate();
        oldPassword = DataFixing.trimNULL(request.getParameter("oldPassword"));
        newPassword = DataFixing.trimNULL(request.getParameter("newPassword"));
    }

    private void changePassword(Statement stmt) {
        try {
            String sql = "select * from sys用户表 where 用户密码='" + oldPassword + "'";
            ResultSet rs = stmt.executeQuery(sql);
            if (rs.next()) {
                sql = "update sys用户表 set 用户密码='" + newPassword + "', 密码确认='" + newPassword + "'" + " where 用户密码='" + oldPassword + "' ";
                System.out.println(sql);
                stmt.executeUpdate(sql);
                successFlag = "1";
            } else {
                successFlag = "2";
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
            successFlag = "-1";
        }
    }

    private void returnPageParameters(HttpServletRequest request) {
        request.setAttribute("successFlag", successFlag);
    }
}