package hospital.Controller.Actions.UserRole;

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

public class DispatchButtonAction extends Action {
    String roleNo = "";
    String checkedButtonItems = "";
    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("buttonListAction");
    }

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

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

    private void saveMenuItems(Statement stmt) {
        try {
            String sql = "delete from sys角色按鈕表 where 角色編號='" + roleNo + "'";
            stmt.executeUpdate(sql);

            String[] buttonItemArray = checkedButtonItems.split(",");
            for (int i = 0; i < buttonItemArray.length; i++) {
                sql = "insert into sys角色按鈕表(按鈕編號,角色編號) values('" + buttonItemArray[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);
    }
}