钟日健
2022-06-13 c048d5d7fed5de2f652b3e91655a107be167c295
src/main/java/org/springblade/modules/quartz/task/Task.java
@@ -78,22 +78,20 @@
                  String sql = OutJson.stringReplace(s);
                  String[] split = sql.split(";");//以逗号分割
                  for (String sqls : split) {
                     if (sqls.length()>1) {
                        //判断是否是新增,删除,修改
                        String substring = sqls.substring(0, 2);
                        //新增
                        if (substring.equals("in")) {
                           //运行sql语句
                           MysqlCenlint.inster(sqls);
                        }
                        //修改
                        else if (substring.equals("up")) {
                           MysqlCenlint.update(sqls);
                        }
                        //删除
                        else {
                           MysqlCenlint.delete(sqls);
                        }
                     //判断是否是新增,删除,修改
                     String substring = sqls.substring(0, 2);
                     //新增
                     if (substring.equals("in")) {
                        //运行sql语句
                        MysqlCenlint.inster(sqls);
                     }
                     //修改
                     else if (substring.equals("up")) {
                        MysqlCenlint.update(sqls);
                     }
                     //删除
                     else {
                        MysqlCenlint.delete(sqls);
                     }
                  }
                  //删除本地文件
@@ -154,7 +152,6 @@
                  //删除本地文件
                  MysqlCenlint.deletess(fileName);
                  //删除 ftp 文件
//                     ftp.dele(fileName);
                  FtpUtil.deleteFile(ftpHost, ftpPort, ftpUserName, ftpPassword, "anbao/", fileName);
               }
               if(substring1.equals("u")){
@@ -199,14 +196,14 @@
         FtpUtil.deleteFile(ftpHost, ftpPort, ftpUserName, ftpPassword, "anbao/", fileName);
         e.printStackTrace();
      } finally {
         try {
            ftp.logout();
         } catch (IOException e) {
            e.printStackTrace();
         }
         //如果ftp 没有关闭,则关闭ftp
         if (ftp.isConnected()) {
            try {
               ftp.logout();
            } catch (IOException e) {
               e.printStackTrace();
            }
            try {
               ftp.disconnect();
            } catch (IOException io) {
               io.printStackTrace();