1.ftp

tangzy

2021-08-21 5435fab6f2fa000a5f50f49197100ad49a81d90b

1.ftp

 src/main/java/org/springblade/modules/FTP/OutJson.java

@@ -152,7 +152,7 @@
     * @return
     */
    public static String TestJson(){
        File file = new File("D:\\anbao\\sql.json");
        File file = new File("D:\\anbao\\nsql.json");
        StringBuilder localStrBulider = new StringBuilder();
        if(file.isFile() && file.exists()) {
            try {

 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();

 src/main/java/org/springblade/modules/information/controller/InformationController.java

@@ -387,4 +387,23 @@
//    }


    public static void main(String[] args) {
        //
        String s = OutJson.TestJson();
        String sql = OutJson.stringReplace(s);
        String[] split = sql.split(";");//以逗号分割
        for (String string2 : split) {
            System.out.println("数据-->>>" + string2);
            String substring = string2.substring(0, 2);
            System.out.println(substring);
        }
//        //sql语句
//        String sql = OutJson.stringReplace(s);
//        String[] split = sql.split(";");
//        for (int i=0;i< split.length;i++){
//            System.out.println(split[i]);
//        }
    }


}