rolegroupaction.java

hibernate应用测试,初学hibernate 的会员可以看看.

package com.action;

import org.apache.struts.action.*;
import java.io.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.util.List;
import java.sql.SQLException;

import com.bean.ClientTable;
import com.bean.RoleGroup;
import com.dao.RoleGroupDAO;
import com.dao.UrlGroupDAO;
import com.dao.RoleUrlDAO;
import com.tool.pagetool.*;
import com.tool.QueryStrCreator;
import com.tool.LogTableWriter;
import com.bean.UrlGroup;
import com.dao.AcountTableDAO;
import javax.servlet.RequestDispatcher;
import com.dao.AcountGroupDAO;
import com.bean.AcountGroup;

public class RoleGroupAction extends Action {
    public ActionForward execute(ActionMapping mapping,
                                 ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response) throws Exception {

        request.setCharacterEncoding("gb2312");
        response.setContentType("text/html;charset=gb2312");

        String flag = request.getParameter("flag");
        ActionErrors actionErrors = new ActionErrors();
        String target = "";
        if (flag.equals("add")) { //添加组
            try {
                RoleGroupDAO.startTransation();
                int id = RoleGroupDAO.getLastId() + 1;
                RoleGroup roleGroup = new RoleGroup();
                roleGroup.setGroupId(id);
                roleGroup.setDelFlag(0);
                roleGroup.setGroupName(request.getParameter("groupName"));
                RoleGroupDAO.insertRoleGroup(roleGroup);
                RoleGroupDAO.commit();
                ActionError actionError = new ActionError(
                        "errors.addSuccese");
                actionErrors.add("addGroupSuccese", actionError);
                saveErrors(request, actionErrors);

                //写入日志
                String operatorType = "增";
                String sql =
                        "insert into ROLE_GROUP (group_id,group_name,del_flag) values (" +
                        roleGroup.getGroupId() + ",'" + roleGroup.getGroupName() +
                        "'," + roleGroup.getDelFlag() + ")";
                LogTableWriter.write(request, operatorType, sql);

                target = "addRoleGroup";
            } catch (Exception e) {
                RoleGroupDAO.rollback();
                e.printStackTrace();
                ActionError actionError = new ActionError(
                        "errors.generally.failed", e.getMessage());
                actionErrors.add("addClientSuccese", actionError);
                saveErrors(request, actionErrors);
                target = "addRoleGroup";
            }
        } else if (flag.equals("forEdit")) { //跳转至编辑页面
            initPage(request);
            target = "editRoleGroup";
        } else if (flag.equals("gotoModGroupName")) { //跳转至修改组名
            String groupIdStr = request.getParameter("groupId");
            try {
                int groupId = new Integer(groupIdStr).intValue();
                RoleGroup roleGroup = RoleGroupDAO.selectRoleGroupBygroupId(
                        groupId);
                request.setAttribute("roleGroup", roleGroup);
            } catch (Exception e) {
                e.printStackTrace();
                ActionError actionError = new ActionError(
                        "errors.generally.failed", e.getMessage());
                actionErrors.add("addClientSuccese", actionError);
                saveErrors(request, actionErrors);
            }
            target = "modifyGroupName";
        } else if (flag.equals("modify")) { //修改组名
            RoleGroup roleGroup = (RoleGroup) form;
            try {
                RoleGroupDAO.updateRoleGroup(roleGroup);
                request.setAttribute("roleGroup", roleGroup);
                ActionError actionError = new ActionError(
                        "errors.generally.succese");
                actionErrors.add("addGroupSuccese", actionError);
                saveErrors(request, actionErrors);
            } catch (Exception e) {
                e.printStackTrace();
                ActionError actionError = new ActionError(
                        "errors.generally.failed", e.getMessage());
                actionErrors.add("addClientSuccese", actionError);
                saveErrors(request, actionErrors);
            }
            target = "modifyGroupName";
        } else if (flag.equals("delete")) { //删除一个组
            String groupIdStr = request.getParameter("groupId");

            try {
                int groupId = new Integer(groupIdStr).intValue();
                RoleGroup roleGroup = RoleGroupDAO.selectRoleGroupBygroupId(
                        groupId);
                roleGroup.setDelFlag(1);
                RoleGroupDAO.updateRoleGroup(roleGroup);
                UrlGroupDAO.updateByGroupId(roleGroup);
                ActionError actionError = new ActionError(
                        "errors.generally.succese");
                actionErrors.add("addGroupSuccese", actionError);
                saveErrors(request, actionErrors);
            } catch (Exception e) {
                e.printStackTrace();
                ActionError actionError = new ActionError(
                        "errors.generally.failed", e.getMessage());
                actionErrors.add("addClientSuccese", actionError);
                saveErrors(request, actionErrors);
            }
            initPage(request);
            target = "editRoleGroup";
        } else if (flag.equals("deleteSelete")) { //删除所选的组，一个或多个
            String[] arryGroupId = request.getParameterValues("checkbox");
            if (arryGroupId == null)return mapping.findForward("editRoleGroup");
            try {
                int[] groupId = new int[arryGroupId.length];
                for (int i = 0; i < arryGroupId.length; i++) {
                    groupId[i] = new Integer(arryGroupId[i]).intValue();
                }
                RoleGroup roleGroup = null;
                for (int j = 0; j < groupId.length; j++) {
                    roleGroup = RoleGroupDAO.selectRoleGroupBygroupId(groupId[j]);
                    roleGroup.setDelFlag(1);
                    RoleGroupDAO.updateRoleGroup(roleGroup);
                }
                ActionError actionError = new ActionError(
                        "errors.generally.succese");
                actionErrors.add("addGroupSuccese", actionError);
                saveErrors(request, actionErrors);

            } catch (Exception e) {
                e.printStackTrace();
                ActionError actionError = new ActionError(
                        "errors.generally.failed", e.getMessage());
                actionErrors.add("addClientSuccese", actionError);
                saveErrors(request, actionErrors);
            }
            target = "editRoleGroup";
        } else if (flag.equals("listTeamForSetRole")) { //列出用户组并跳转到组权限设置
            initPage(request);
            target = "groupSetRole";
        } else if (flag.equals("setRoleForGroup")) { //给组设置权限,只是列出权限页面
            int groupId = new Integer(request.getParameter("groupId")).intValue();
            List allRole = RoleUrlDAO.selectAllRoleUrl();
            List theGroupRole = UrlGroupDAO.selectTheGroupRoleByGroupId(groupId);
            RoleGroup roleGroup = RoleGroupDAO.selectRoleGroupBygroupId(groupId);
            request.setAttribute("roleGroup", roleGroup);
            request.setAttribute("allRole", allRole);
            request.setAttribute("theGroupRole", theGroupRole);
            target = "groupSetRoleItem";
        } else if (flag.equals("set")) { //执行权限设置
            String[] urlIdArray = request.getParameterValues("checkbox");
            String groupIdStr = request.getParameter("groupId");

            if (groupIdStr == null)return mapping.findForward(
                    "");
            try {
                UrlGroupDAO.startTransation();
                int lastId = UrlGroupDAO.getLastId();
                int groupId = new Integer(groupIdStr).intValue();
                if (urlIdArray == null) { //删除某组的所有权限
                    UrlGroupDAO.deleteUrlGroupByGroupId(groupId);
                } else {
                    UrlGroupDAO.deleteUrlGroupByGroupId(groupId);
                    int urlId = -1;
                    for (int i = 0; i < urlIdArray.length; i++) {
                        urlId = new Integer(urlIdArray[i]).intValue();
                        UrlGroup urlGroup = new UrlGroup();
                        urlGroup.setDelFlag(0);
                        urlGroup.setGroupId(groupId);
                        urlGroup.setUgId(lastId + i + 1);
                        urlGroup.setUrlId(urlId);
                        UrlGroupDAO.insertUrlGroup(urlGroup);
                    }
                }
                UrlGroupDAO.commit();
                ActionError actionError = new ActionError(
                        "errors.generally.succese");
                actionErrors.add("addGroupSuccese", actionError);
                saveErrors(request, actionErrors);
                List allRole = RoleUrlDAO.selectAllRoleUrl();
                List theGroupRole = UrlGroupDAO.selectTheGroupRoleByGroupId(
                        groupId);
                RoleGroup roleGroup = RoleGroupDAO.selectRoleGroupBygroupId(
                        groupId);
                request.setAttribute("roleGroup", roleGroup);
                request.setAttribute("allRole", allRole);
                request.setAttribute("theGroupRole", theGroupRole);

            } catch (Exception e) {
                e.printStackTrace();
                UrlGroupDAO.rollback();