[Java知识库] springboot将数据库内容编译成csv样式通过FTP上传

开发: C++知识库 Java知识库 JavaScript Python PHP知识库人工智能区块链大数据移动开发嵌入式开发工具数据结构与算法开发测试游戏开发网络协议系统运维
教程: HTML教程 CSS教程 JavaScript教程 Go语言教程 JQuery教程 VUE教程 VUE3教程 Bootstrap教程 SQL数据库教程 C语言教程 C++教程 Java教程 Python教程 Python3教程 C#教程
数码: 电脑笔记本显卡显示器固态硬盘硬盘耳机手机 iphone vivo oppo 小米华为单反装机图拉丁

-> Java知识库 -> springboot将数据库内容编译成csv样式通过FTP上传 -> 正文阅读

[Java知识库]springboot将数据库内容编译成csv样式通过FTP上传

引用的jar包

		<!-- commons-csv -->
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-csv</artifactId>
            <version>1.8</version>
        </dependency>
		<!-- Commons net 各种网络协议的Client类 如FTP -->
        <dependency>
            <groupId>commons-net</groupId>
            <artifactId>commons-net</artifactId>
        </dependency>

public void test() {
        
        try {
            // 准备输出流
            ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
            OutputStreamWriter osw = new OutputStreamWriter(outputStream, "GBK");
            // 假如标题上还有一行文件说明信息
            CSVPrinter printer = new CSVPrinter(osw, CSVFormat.DEFAULT.withHeader("收件人",":张三","1","寄件人",":罗老师"));
            printer.printRecord("标题1","标题2","标题3","标题4","标题5","标题6","7");
            printer.printRecord("211128","20211128","11111","22222","33333","","9222");
            printer.printRecord("211128","20211128","11111","22222","33333","","9222");
            printer.flush();
            printer.close();
            ByteArrayInputStream inputStream = new ByteArrayInputStream(outputStream.toByteArray());
            FTPClient ftpClient = FtpUtil.connect();
            String fileName = "法外狂徒.csv";
            FtpUtil.upload(ftpClient,fileName,inputStream,"/test/upload");
            ftpClient.logout();
            if (ftpClient.isConnected()) {
                ftpClient.disconnect();
            }
        } catch (IOException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }

    }