Administrator
2021-08-21 75d710137ad9098e36e41f6ce8f2ccde0b6becc4
src/main/java/org/springblade/modules/FTP/monitor.java
@@ -90,20 +90,23 @@
            String s = OutJson.TestJson();
            //sql语句
            String sql = OutJson.stringReplace(s);
            //判断是否是新增,删除,修改
            String substring = sql.substring(0, 2);
            //新增
            if (substring.equals("in")){
               //运行sql语句
               MysqlCenlint.inster(sql);
            }
            //修改
            else if (substring.equals("up")){
            }
            //删除
            else {
            String[] split = sql.split(";");//以逗号分割
            for (String sqls : split) {
               //判断是否是新增,删除,修改
               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);
               }
            }
            //删除本地文件
            MysqlCenlint.delete();