| | |
| | | } else { |
| | | for (FTPFile file : files){ |
| | | String fileName = file.getName(); |
| | | // InputStream is = ftp.retrieveFileStream(new String(fileName.getBytes("GBK"), FTP.DEFAULT_CONTROL_ENCODING)); |
| | | // String substring1 = fileName.substring(0, 2); |
| | | if (fileName.contains("ni")){ |
| | | System.out.println("-------接收到内网回传的文件: " + fileName); |
| | | //把文件下载到本地 |
| | |
| | | Result result = DataHandler.handler(s,uuid); |
| | | //删除本地文件 |
| | | MysqlCenlint.deletess(fileName); |
| | | // ftp.dele(fileName); |
| | | FtpUtil.deleteFile(ftpHost, ftpPort, ftpUserNameIn, ftpPasswordIn, ftpPath, fileName); |
| | | // is.close(); |
| | | ftp.dele(fileName); |
| | | // FtpUtil.deleteFile(ftpHost, ftpPort, ftpUserNameIn, ftpPasswordIn, ftpPath, fileName); |
| | | ftp.completePendingCommand(); |
| | | ftp.logout(); |
| | | if (result.getCode()==200) { |
| | | //返回 |
| | | return new Result(200,null,"新增成功",null); |
| | |
| | | System.out.println("ftp连接失败"); |
| | | e.printStackTrace(); |
| | | } finally { |
| | | if (ftp != null) { |
| | | if (ftp.isConnected()) { |
| | | try { |
| | | ftp.disconnect(); |
| | | } catch (IOException e) { |
| | |
| | | for (FTPFile file : files){ |
| | | String fileName = file.getName(); |
| | | if (fileName.contains("nl")){ |
| | | //转流 |
| | | // InputStream is = ftp.retrieveFileStream(new String(fileName.getBytes("GBK"), FTP.DEFAULT_CONTROL_ENCODING)); |
| | | //把文件下载到本地 |
| | | FtpUtil.downloadFtpFile(ftpHost, ftpUserNameIn, ftpPasswordIn, ftpPort, ftpPath, localPath, fileName); |
| | | // 解析数据 |
| | |
| | | } |
| | | // is.close(); |
| | | ftp.completePendingCommand(); |
| | | ftp.logout(); |
| | | } |
| | | } |
| | | return new Result(400,null,"未读取到对应的文件",null); |
| | |
| | | System.out.println("ftp连接失败"); |
| | | e.printStackTrace(); |
| | | } finally { |
| | | if (ftp != null) { |
| | | if (ftp.isConnected()) { |
| | | try { |
| | | ftp.disconnect(); |
| | | } catch (IOException e) { |
| | |
| | | } else { |
| | | for (FTPFile file : files){ |
| | | String fileName = file.getName(); |
| | | // InputStream is = ftp.retrieveFileStream(new String(fileName.getBytes("GBK"), FTP.DEFAULT_CONTROL_ENCODING)); |
| | | // String substring1 = fileName.substring(0, 2); |
| | | if (fileName.contains("nt")){ |
| | | //把文件下载到本地 |
| | | FtpUtil.downloadFtpFile(ftpHost, ftpUserNameIn, ftpPasswordIn, ftpPort, ftpPath, localPath, fileName); |
| | |
| | | } |
| | | // is.close(); |
| | | ftp.completePendingCommand(); |
| | | ftp.logout(); |
| | | } |
| | | } |
| | | return new Result(400,null,"未读取到对应的文件",null); |
| | |
| | | System.out.println("ftp连接失败"); |
| | | e.printStackTrace(); |
| | | } finally { |
| | | if (ftp != null) { |
| | | if (ftp.isConnected()) { |
| | | try { |
| | | ftp.disconnect(); |
| | | } catch (IOException e) { |
| | |
| | | else { |
| | | for (FTPFile file : files) { |
| | | String fileName = file.getName(); |
| | | // InputStream is = ftp.retrieveFileStream(new String(fileName.getBytes("GBK"), FTP.DEFAULT_CONTROL_ENCODING)); |
| | | // if (null == is) { |
| | | // return false; |
| | | // } else { |
| | | // String substring1 = fileName.substring(0, 2); |
| | | if (fileName.contains("nq")) { |
| | | //把文件下载到本地 |
| | | FtpUtil.downloadFtpFile(ftpHost, ftpUserNameIn, ftpPasswordIn, ftpPort, ftpPath, localPath, fileName); |
| | | // |
| | | String s = OutJson.TestJson(fileName); |
| | | //sql语句 |
| | | String sql = OutJson.stringReplace(s); |
| | | 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); |
| | | } |
| | | if (fileName.contains("nq")) { |
| | | //把文件下载到本地 |
| | | FtpUtil.downloadFtpFile(ftpHost, ftpUserNameIn, ftpPasswordIn, ftpPort, ftpPath, localPath, fileName); |
| | | // |
| | | String s = OutJson.TestJson(fileName); |
| | | //sql语句 |
| | | String sql = OutJson.stringReplace(s); |
| | | String[] split = sql.split(";");//以逗号分割 |
| | | for (String sqls : split) { |
| | | //判断是否是新增,删除,修改 |
| | | String substring = sqls.substring(0, 2); |
| | | //新增 |
| | | if (substring.equals("in")) { |
| | | //运行sql语句 |
| | | MysqlCenlint.inster(sqls); |
| | | } |
| | | //删除本地服务器文件 |
| | | MysqlCenlint.deletess(fileName); |
| | | //删除 ftp 服务器文件 |
| | | // ftp.dele(fileName); |
| | | FtpUtil.deleteFile(ftpHost, ftpPort, ftpUserNameIn, ftpPasswordIn, ftpPath, fileName); |
| | | //修改 |
| | | else if (substring.equals("up")) { |
| | | MysqlCenlint.update(sqls); |
| | | } |
| | | //删除 |
| | | else { |
| | | MysqlCenlint.delete(sqls); |
| | | } |
| | | } |
| | | //关闭流 |
| | | // is.close(); |
| | | ftp.completePendingCommand(); |
| | | //删除本地服务器文件 |
| | | MysqlCenlint.deletess(fileName); |
| | | //删除 ftp 服务器文件 |
| | | // ftp.dele(fileName); |
| | | FtpUtil.deleteFile(ftpHost, ftpPort, ftpUserNameIn, ftpPasswordIn, ftpPath, fileName); |
| | | } |
| | | ftp.completePendingCommand(); |
| | | ftp.logout(); |
| | | } |
| | | } |
| | | } catch (Exception e) { |
| | | System.out.println("ftp连接失败"); |
| | | e.printStackTrace(); |
| | | } finally { |
| | | if (ftp != null) { |
| | | if (ftp.isConnected()) { |
| | | try { |
| | | ftp.disconnect(); |
| | | } catch (IOException e) { |
| | |
| | | public static Result getSecurityNumberBit(String uuid) { |
| | | //创建 ftp 对象 |
| | | FTPClient ftp = new FTPClient(); |
| | | boolean flag = false; |
| | | try { |
| | | //设置超时时间 |
| | | ftp.setDataTimeout(60000); |
| | |
| | | } else { |
| | | for (FTPFile file : files){ |
| | | String fileName = file.getName(); |
| | | // InputStream is = ftp.retrieveFileStream(new String(fileName.getBytes("GBK"), FTP.DEFAULT_CONTROL_ENCODING)); |
| | | // String substring1 = fileName.substring(0, 2); |
| | | if (fileName.contains("ns")){ |
| | | //把文件下载到本地 |
| | | FtpUtil.downloadFtpFile(ftpHost, ftpUserNameIn, ftpPasswordIn, ftpPort, ftpPath, localPath, fileName); |
| | |
| | | //返回 |
| | | return result; |
| | | } |
| | | // is.close(); |
| | | ftp.completePendingCommand(); |
| | | ftp.logout(); |
| | | } |
| | | } |
| | | return new Result(400,null,"未读取到对应的文件",null); |