1、生成CSV

jar包：

String csvFilePath = "d:\\test.csv";CsvWriter wr =new CsvWriter(csvFilePath,',',Charset.forName("UTF-8"));for(int i=0;i<10;i++){    String[] contents = {String.valueOf(i),"测试"+i};    wr.writeRecord(contents);}wr.close();

2、导入到mysql

String url = "jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=UTF-8&rewriteBatchedStatements=true";String user = "root";String password = "123456";Connection conn= DriverManager.getConnection(url,user,password);conn.setAutoCommit(false);PreparedStatement pstmt = conn.prepareStatement("load data local infile 'd:/test.csv' into table test fields terminated by ','");pstmt.execute();conn.commit();