保安员导出过多导致报错问题处理

Administrator

2021-12-16 cdcd2d540de3e6ba4c2e9e7c6a879416da78c17b

 src/main/java/org/springblade/modules/equipage/controller/GunController.java

@@ -87,7 +87,7 @@
         //数据同步
         String s1 =
            "insert into sys_gun(id,issue_unit,card_number,gun_mode," +
               "dept_id,person_in_charge,issue_time,valid_time,jurisdiction) " +
               "dept_id,person_in_charge,issue_time,valid_time,jurisdiction,card_no) " +
               "values(" + "'" + gun.getId() + "'" + "," +
               "'" + gun.getIssueUnit() + "'" + "," +
               "'" + gun.getCardNumber() + "'" + "," +
@@ -96,6 +96,7 @@
               "'" + gun.getPersonInCharge() + "'" + "," +
               "'" + new SimpleDateFormat("yyyy-MM-dd").format(gun.getIssueTime()) + "'" + "," +
               "'" + new SimpleDateFormat("yyyy-MM-dd").format(gun.getValidTime()) + "'" + "," +
               "'" +gun.getCardNo() + "'" + "," +
               "'" +gun.getJurisdiction() + "'" + ")";
         FtpUtil.sqlFileUpload(s1);
      }else {
@@ -111,6 +112,7 @@
               ",issue_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(gun.getIssueTime()) + "'" +
               ",valid_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(gun.getValidTime()) + "'" +
               ",jurisdiction = " + "'" + gun.getJurisdiction() + "'" +
               ",card_no = " + "'" + gun.getCardNo() + "'" +
               " " +"where id = " + "'" + gun.getId() + "'";
         FtpUtil.sqlFileUpload(s1);
      }
@@ -168,6 +170,7 @@
      gunExcel1.setGunMode("x****");
      gunExcel1.setIssueUnit("*****");
      gunExcel1.setPersonInCharge("张三");
      gunExcel1.setCardNo("360112**********");
      list.add(gunExcel1);
      String fileName = null;
      try {