dispatchmenuaction.java

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

package hospital.Controller.Actions.UserRole;

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

public class DispatchMenuAction extends Action {
    String roleNo = "";
    String checkedMenuItems = "";
    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);

            saveMenuItems(stmt);

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

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

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

    private void setPropertyToOrginate() {
        roleNo = "";
        checkedMenuItems = "";
        successFlag = "0";
    }

    private void initPageParameters(ActionForm form, HttpServletRequest request) {
        setPropertyToOrginate();
        roleNo = request.getParameter("roleNo");
        checkedMenuItems = request.getParameter("checkedMenuItems");
        System.out.println("!!!!!" + checkedMenuItems);
    }

    private void saveMenuItems(Statement stmt) {
        try {
            String sql = "delete from sys角色菜单表 where 角色编号='" + roleNo + "'";
            stmt.executeUpdate(sql);

            String[] menuItemArray = checkedMenuItems.split(",");
            for (int i = 0; i < menuItemArray.length; i++) {
                sql = "insert into sys角色菜单表(菜单编号,角色编号) values('" + menuItemArray[i] + "','" + roleNo + "')";
                stmt.executeUpdate(sql);
            }
            successFlag = "1";
        } catch (SQLException ex) {
            ex.printStackTrace();
            successFlag = "-1";
        }
    }

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