setLocalInfileInputStraemを用いたLOAD DATA LOCAL INFILE (MySQL) (参考 http://d.hatena.ne.jp/sh2/20090528 )

gistfile1.java

byte[] buf= {};
Connection conn = DriverManager.getConnection(JDBC_URL, JDBC_USER, JDBC_PASS);
//conn.setAutoCommit(false);
Statement stmt = conn.createStatement();
String sql = "LOAD DATA LOCAL INFILE '' INTO TABLE thetable"
		+ " FIELDS TERMINATED BY ',' ENCLOSED BY '\"' ESCAPED BY '\"'"
		+ " LINES TERMINATED BY '\n'";
InputStream is = new ByteArrayInputStream(buf);
((com.mysql.jdbc.Statement) stmt).setLocalInfileInputStream(is);
stmt.execute(sql);
//conn.commit();