Java向数据库中一次性插入大量数据

String sql = “insert into username.tablename(id) values(?)”;

PreparedStatement stmt = conn.prepareStatement(sql);

int rownum = 0;
while (rownum < 99999) {
    stmt.setString(1, UUID.randomUUID().toString());
    stmt.addBatch(); 
    rownum ++;
}

stmt.executeBatch(); 
conn.commit();

 

转载于:https://www.cnblogs.com/liuxiaoke/p/10129945.html