"errors.generally.failed", "重復的產品信息");
                        actionErrors.add("", actionError);
                        saveErrors(request, actionErrors);
                        request.setAttribute("productTable", productTable);
                        target = "modifyProduct";
                        return mapping.findForward(target);
                    }
                    //產品信息不重復執行更新
                    ProductTableDAO.updateProductTable(productTable);

                    ActionError actionError = new ActionError(
                            "errors.modifyUserInfoSuccese");
                    actionErrors.add("", actionError);
                    saveErrors(request, actionErrors);
                    //寫入日志
                    String operatorType = "改";
                    String sql = "update PRODUCT_TABLE set " +
                                 "PRODUCT_ID=" + productTable.getProductId() +
                                 "," +
                                 "PRODUCT_NAME=" + productTable.getProductName() +
                                 "," +
                                 "PRODUCT_TYPE=" +
                                 productTable.getProductTechnics() + "," +
                                 "PIN_PAI=" + productTable.getPinPai() +
                                 ",PRODUCT_TECHNICS=" +
                                 productTable.getProductTechnics() + "," +
                                 "PRODUCT_PACKAGE=" +
                                 productTable.getProductPackage() + "," +
                                 "PRODUCT_MANUFACTURER=" +
                                 productTable.getProductManufacturer() + "," +
                                 "PRODUCT_GRADE=" +
                                 productTable.getProductGrade() + "," +
                                 "PRODUCE_BATCH=" +
                                 productTable.getProduceBatch() + "," +
                                 "GUARANTEE_PERIOD=" +
                                 productTable.getGuaranteePeriod() + "," +
                                 "DEL_FLAG=" + productTable.getDelFlag() + " " +
                                 "where PRODUCT_ID = " +
                                 productTable.getProductId();
                    LogTableWriter.write(request, operatorType, sql);
                } catch (Exception e) {
                    e.printStackTrace();
                    ActionError actionError = new ActionError(
                            "errors.modifyUserInfoFailed");
                    actionErrors.add("addClientFeiled", actionError);
                    saveErrors(request, actionErrors);
                }
                request.setAttribute("productTable", productTable);
                target = "modifyProduct";
            }
        //刪除
        if (flag.equals("delete")) {

            String productIdStr = request.getParameter("productId");
            int productId = -1;
            try {
                productId = Integer.parseInt(productIdStr);
                productTable = ProductTableDAO.selectProductTableByproductId(
                        productId);
                boolean tmp = ProductTableDAO.selectIsReferProduct(productTable);
                if (tmp) { //如果產品已被引用
                    ActionError actionError = new ActionError(
                            "errors.generally.failed", "產品已被引用");
                    actionErrors.add("", actionError);
                    saveErrors(request, actionErrors);
                    target = "listProduct";
                    return mapping.findForward(target);
                }
                productTable.setDelFlag(1);
                ProductTableDAO.updateProductTable(productTable);
                ActionError actionError = new ActionError(
                        "errors.generally.succese");
                actionErrors.add("", actionError);
                saveErrors(request, actionErrors);
                //寫入日志
                String operatorType = "刪";
                String sql = "update PRODUCT_TABLE set " +
                             "PRODUCT_ID=" + productTable.getProductId() + "," +
                             "PRODUCT_NAME=" + productTable.getProductName() +
                             "," +
                             "PRODUCT_TYPE=" + productTable.getProductTechnics() +
                             "," +
                             "PIN_PAI=" + productTable.getPinPai() +
                             ",PRODUCT_TECHNICS=" +
                             productTable.getProductTechnics() + "," +
                             "PRODUCT_PACKAGE=" +
                             productTable.getProductPackage() + "," +
                             "PRODUCT_MANUFACTURER=" +
                             productTable.getProductManufacturer() + "," +
                             "PRODUCT_GRADE=" + productTable.getProductGrade() +
                             "," +
                             "PRODUCE_BATCH=" + productTable.getProduceBatch() +
                             "," +
                             "GUARANTEE_PERIOD=" +
                             productTable.getGuaranteePeriod() + "," +
                             "DEL_FLAG=" + productTable.getDelFlag() + " " +
                             "where PRODUCT_ID = " + productTable.getProductId();
                LogTableWriter.write(request, operatorType, sql);
            } catch (Exception e) {
                e.printStackTrace();
                ActionError actionError = new ActionError(
                        "errors.generally.failed", e.getMessage());
                actionErrors.add("", actionError);
                saveErrors(request, actionErrors);
            }
            target = "listProduct";
        }
        return mapping.findForward(target);
    }

    //初始化并獲得分頁
    private Page initPage(HttpServletRequest request) {
        String currentPageStr = request.getParameter("currentPage");
        String queryStr = QueryStrCreator.create("productTable", 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("productPageTool"); //有，則直接拿來用
        if (pageTool == null) { //沒有，則新建，并放進會話中，以備下次用
            pageTool = PageToolBuilder.builder(new ProductTableDAO());
            session.setAttribute("productPageTool", pageTool);
        }
        //由分頁工具生成分頁
        Page page = null;
        try {
            String flag = request.getParameter("flag");
            if (flag.equals("query")) //查詢時的分頁
                page = pageTool.createPage(currentPage, size, queryStr);
            else //其它非查詢的分頁
                page = pageTool.createPage(currentPage, size);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        //將分頁放進請求中，分發到下一個頁面顯示
        request.setAttribute("allProductPage", page);
        return page;
    }
}