accountaction.java

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

            } catch (Exception e) {
                e.printStackTrace();
                AcountTableDAO.rollback();
                ActionError actionError = new ActionError(
                        "errors.generally.failed", e.getMessage());
                actionErrors.add("", actionError);
                saveErrors(request, actionErrors);
            }
            initPage(request);
            List allRoleGroup = RoleGroupDAO.selectAllRoleGroup();
            request.setAttribute("allRoleGroup", allRoleGroup);

            target = "editAccount";
        } else if (flag.equals("delete")) { //删除账号
            String[] acountIdAndAcountGroupId = request.getParameterValues(
                    "checkbox"); //checkbox中的值的格式为:"acountId||acountGroupId"
            String groupIdStr = request.getParameter("groupId2");
            if (acountIdAndAcountGroupId == null || groupIdStr == null)return
                    mapping.findForward("");
            int groupId = -1;
            try {
                groupId = Integer.parseInt(groupIdStr);
                for (int i = 0; i < acountIdAndAcountGroupId.length; i++) {
                    String accountIdStr = acountIdAndAcountGroupId[i].substring(
                            0, acountIdAndAcountGroupId[i].indexOf("||"));
                    AcountTable acountTable = new AcountTable();
                    acountTable.setAcountId(Integer.parseInt(accountIdStr));
                    acountTable.setDelFlag(1);
                    AcountTableDAO.updateDelFlagByAcountId(acountTable);
                }
                ActionError actionError = new ActionError(
                        "errors.generally.succese");
                actionErrors.add("addGroupSuccese", actionError);
                saveErrors(request, actionErrors);

            } catch (Exception e) {
                e.printStackTrace();
                AcountTableDAO.rollback();
                ActionError actionError = new ActionError(
                        "errors.generally.failed", e.getMessage());
                actionErrors.add("", actionError);
                saveErrors(request, actionErrors);
            }
            initPage(request);
            List allRoleGroup = RoleGroupDAO.selectAllRoleGroup();
            request.setAttribute("allRoleGroup", allRoleGroup);
            target = "editAccount";
        } else if (flag.equals("getOut")) { //把账号从当前组移走，但不删除账号
            String[] acountIdAndAcountGroupId = request.getParameterValues(
                    "checkbox"); //checkbox中的值的格式为:"acountId||acountGroupId"
            String groupIdStr = request.getParameter("groupId2");
            if (acountIdAndAcountGroupId == null || groupIdStr == null)return
                    mapping.findForward("");
            int groupId = -1;
            try {
                groupId = Integer.parseInt(groupIdStr);
                for (int i = 0; i < acountIdAndAcountGroupId.length; i++) {
                    String accountGroupIdStr = acountIdAndAcountGroupId[i].
                                               substring(
                            acountIdAndAcountGroupId[i].indexOf("||") + 2);
                    AcountGroupDAO.deleteAcountGroupByselfId(Integer.parseInt(
                            accountGroupIdStr));
                }
                ActionError actionError = new ActionError(
                        "errors.generally.succese");
                actionErrors.add("addGroupSuccese", actionError);
                saveErrors(request, actionErrors);
            } catch (Exception e) {
                e.printStackTrace();
                AcountTableDAO.rollback();
                ActionError actionError = new ActionError(
                        "errors.generally.failed", e.getMessage());
                actionErrors.add("", actionError);
                saveErrors(request, actionErrors);
            }
            initPage(request);
            List allRoleGroup = RoleGroupDAO.selectAllRoleGroup();
            request.setAttribute("allRoleGroup", allRoleGroup);
            target = "editAccount";
        } else if (flag.equals("goModify")) {
            String acountIdStr = request.getParameter("acountId");
            if (acountIdStr == null)return mapping.findForward("");
            try {
                AcountTable acount = AcountTableDAO.selectAcountTableByacountId(
                        Integer.parseInt(acountIdStr));
                request.setAttribute("acount", acount);
                if (acount.getClientId() > 0) {
                    ClientTable client = ClientTableDAO.
                                         selectClientTableByclientId(
                                                 acount.getClientId());
                    request.setAttribute("detailObj", client);

                } else if (acount.getCompUserId() > 0) {
                    CompUser compUser = CompUserDAO.selectCompUserBycompUserId(
                            acount.getCompUserId());
                    request.setAttribute("detailObj", compUser);
                } else if (acount.getShmId() > 0) {
                    StorehouseShmanagerView shManager =
                            StorehouseShmanagerViewDAO.
                            selectStorehouseShmanagerViewByshmId(acount.
                            getShmId());
                    request.setAttribute("detailObj", shManager);
                } else {
                    return mapping.findForward("");
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
            target = "modifyAcount";
        } else if (flag.equals("modify")) {
            String accountName = request.getParameter("account");
            String pwd = request.getParameter("pwd");
            String typeFlag = request.getParameter("type");
            String idStr = request.getParameter("id");
            String acountIdStr = request.getParameter("acountId");
            int id = -1;
            AcountTable accountTable = new AcountTable();
            accountTable.setAccountName(accountName);
            accountTable.setPwd(pwd);
            try {
                id = new Integer(idStr).intValue();
                int acountId = Integer.parseInt(acountIdStr);
                byte[] tmpC = type.getBytes("ISO8859-1");
                accountTable.setAcountId(acountId);
                type = new String(tmpC, "gb2312");
                if (type.equals("client")) {
                    accountTable.setClientId(id);
                } else if (type.equals("compUser")) {
                    accountTable.setCompUserId(id);
                } else if (type.equals("shm")) {
                    accountTable.setShmId(id);
                }
                AcountTableDAO.updateAcountTable(accountTable);

                AcountTable acount = AcountTableDAO.selectAcountTableByacountId(
                        acountId);
                request.setAttribute("acount", acount);
                if (acount.getClientId() > 0) {
                    ClientTable client = ClientTableDAO.
                                         selectClientTableByclientId(
                                                 acount.getClientId());
                    request.setAttribute("detailObj", client);

                } else if (acount.getCompUserId() > 0) {
                    CompUser compUser = CompUserDAO.selectCompUserBycompUserId(
                            acount.getCompUserId());
                    request.setAttribute("detailObj", compUser);
                } else if (acount.getShmId() > 0) {
                    StorehouseShmanagerView shManager =
                            StorehouseShmanagerViewDAO.
                            selectStorehouseShmanagerViewByshmId(acount.
                            getShmId());
                    request.setAttribute("detailObj", shManager);
                } else {
                    return mapping.findForward("");
                }
                ActionError actionError = new ActionError(
                        "errors.generally.succese");
                actionErrors.add("addGroupSuccese", actionError);
                saveErrors(request, actionErrors);

            } catch (Exception e) {
                e.printStackTrace();
                AcountTableDAO.rollback();
                ActionError actionError = new ActionError(
                        "errors.generally.failed", e.getMessage());
                actionErrors.add("", actionError);
                saveErrors(request, actionErrors);
                return mapping.findForward("modifyAcount");
            }
            target = "modifyAcount";
        } else if (flag.equals("gotoOpenAcount")) {
            initPage(request);
            List allRoleGroup = RoleGroupDAO.selectAllRoleGroup();
            request.setAttribute("allRoleGroup", allRoleGroup);
            target = "gotoOpenAcount";
        }

        else if (flag.equals("openAcount")) { //开通账号
            String[] acountIdArry = request.getParameterValues("checkbox");
            if (acountIdArry == null)return mapping.findForward("");
            try {
                for (int i = 0; i < acountIdArry.length; i++) {
                    AcountTable acount = new AcountTable();
                    acount.setAcountId(Integer.parseInt(acountIdArry[i]));
                    acount.setOpenFlag(1); //设置开通标志
                    acount.setOpenDate(java.sql.Date.valueOf(com.tool.MyDate.
                            getDate("-")));
                    AcountTableDAO.updateOpenFlagByAcountId(acount);
                }
                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("", actionError);
                saveErrors(request, actionErrors);
            }
            initPage(request);
            List allRoleGroup = RoleGroupDAO.selectAllRoleGroup();
            request.setAttribute("allRoleGroup", allRoleGroup);
            target = "gotoOpenAcount";
        } else if (flag.equals("closeAcount")) { //封锁账号
            String[] acountIdArry = request.getParameterValues("checkbox");
            if (acountIdArry == null)return mapping.findForward("");
            try {
                for (int i = 0; i < acountIdArry.length; i++) {
                    AcountTable acount = new AcountTable();
                    acount.setAcountId(Integer.parseInt(acountIdArry[i]));
                    acount.setOpenFlag(0); //设置封锁标志
                    acount.setOpenDate(java.sql.Date.valueOf(com.tool.MyDate.
                            getDate("-")));
                    AcountTableDAO.updateOpenFlagByAcountId(acount);
                }
                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("", actionError);
                saveErrors(request, actionErrors);
            }
            initPage(request);
            List allRoleGroup = RoleGroupDAO.selectAllRoleGroup();
            request.setAttribute("allRoleGroup", allRoleGroup);
            target = "gotoOpenAcount";
        }
        return mapping.findForward(target);
    }

    //初始化并获得分页
    private Page initPage(HttpServletRequest request) {
        String currentPageStr = request.getParameter("currentPage");
        String queryStr = QueryStrCreator.create("acountAndGroup", request);
        int currentPage = 1; //当前页码
        int size = 20; //每页的记录数

        try { //防止从地址栏直接输入非法页码
            if (currentPageStr != null) currentPage = new Integer(
                    currentPageStr).intValue();
        } catch (Exception e) {
            e.printStackTrace();
        }
        //处理分页
        //会话中是否已有分页生成工具
        PageTool pageTool = null;
        HttpSession session = request.getSession();
        pageTool = (PageTool) session.getAttribute("acountPageTool"); //有，则直接拿来用
        if (pageTool == null) { //没有，则新建，并放进会话中，以备下次用
            pageTool = PageToolBuilder.builder(new AcountTableDAO());
            session.setAttribute("acountPageTool", pageTool);
        }
        //由分页工具生成分页
        Page page = null;
        try {
            String flag = request.getParameter("flag");
            if (flag.equals("query") || flag.equals("queryForImport")) //查询时的分页
                page = pageTool.createPage(currentPage, size, queryStr);
            else //其它非查询的分页
                page = pageTool.createPage(currentPage, size);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        //将分页放进请求中，分发到下一个页面显示
        request.setAttribute("allAcountPage", page);
        return page;
    }
}