String csvFilePath = "d:\\test.csv";

CsvWriter wr =new CsvWriter(csvFilePath,',',Charset.forName("UTF-8"));

for(int i=;i<;i++)

{

    String[] contents = {String.valueOf(i),"测试"+i};

    wr.writeRecord(contents);

}

wr.close();

String url = "jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=UTF-8&rewriteBatchedStatements=true";

String user = "root";

String password = "";

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