//jdbctemplate批量新增的使用MENU_ID_LIST是前端页面传递到后端控制层，再由控制层传到实现层的List

 //JdbcTemplate是spring jdbctemplate通过注解实例化得到的

 public int insertEmpMenu(final String EMP_ID_, final List<String> MENU_ID_LIST, Map<String, Object> operator) {

         if (MENU_ID_LIST == null || MENU_ID_LIST.size() == 0) {//常见的判断方式

             return 0;

         }

         String sql = "insert into OM_EMPMENU(ID_, EMP_ID_, MENU_ID_) values (?, ?, ?)";

         BatchPreparedStatementSetter batch = new BatchPreparedStatementSetter() {

             public void setValues(PreparedStatement ps, int i) throws SQLException {

                 ps.setString(1, BaseUtils.getUuid());

                 ps.setString(2, EMP_ID_);

                 ps.setString(3, MENU_ID_LIST.get(i));

             }

             public int getBatchSize() {

                 return MENU_ID_LIST.size();

             }

         };

         return JdbcTemplate.batchUpdate(sql, batch).length;

     }

 for (Map<String, Object> matYearPlanSum : matYearPlanSumList) {

                 AVL_AMOUNT_ = ((BigDecimal) matYearPlanSum.get("AMOUNT_")).doubleValue();

                 matYearPlanSum.put("AVL_AMOUNT_", AVL_AMOUNT_);

                 for (Map<String, Object> matMonthPlanHis : matDeptMonthPlanSpentBudget) {

                     if (matYearPlanSum.get("MAT_NO_").equals(matMonthPlanHis.get("MAT_NO_"))) {

                         if (matYearPlanSum.get("AMOUNT_") != null && matMonthPlanHis.get("SPENT_AMOUNT_") != null) {

                             AVL_AMOUNT_ = ((BigDecimal) matYearPlanSum.get("AMOUNT_")).doubleValue() - ((BigDecimal) matMonthPlanHis.get("SPENT_AMOUNT_")).doubleValue();

                         }

                         matYearPlanSum.put("AVL_AMOUNT_", AVL_AMOUNT_);

                         break;

                     }

                 }

             }

 for (Map<String, Object> matMonthPlan : matMonthPlanList) {

                 for (Map<String, Object> matYearPlanSum : matYearPlanSumList) {

                     if (matMonthPlan.get("MAT_NO_").equals(matYearPlanSum.get("MAT_NO_"))) {

                         if (matYearPlanSum.get("ENABLE_AMOUNT_") != null && matMonthPlan.get("AMOUNT_") != null) {

                             ENABLE_AMOUNT_ = ((BigDecimal) matMonthPlan.get("AMOUNT_")).doubleValue();

                             ENABLE_AMOUNT_ = (Double) matYearPlanSum.get("ENABLE_AMOUNT_") + ENABLE_AMOUNT_;//例如此处的Double

                         }

                         matMonthPlan.put("ENABLE_AMOUNT_", ENABLE_AMOUNT_);

                         break;

                     }

                 }

             }