java 批量插入 Oracle

2024-03-15 09:32•java•阅读 2186

sql = "INSERT INTO LOG_FILENAME(ID,FILENAME,CREATETIME) VALUES(2,?,sysdate)";
public void batchInsertFileNames(File[] files) throws SQLException {
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = dataSource.getConnection();
pstmt = (PreparedStatement) conn.prepareStatement(sql);
Date date = new Date();
for (int i = 0; i < files.length; i++) {
setParams(pstmt, files[i].getName(), date);
}
//下句执行后开始批量插入数据
pstmt.executeBatch();
} finally {
DbUtils.close(pstmt);
}
}
private void setParams(PreparedStatement pstmt, String fileName, Date date)
throws SQLException {
pstmt.setString(1, fileName);
//addBatch();执行后暂时记录此条插入
pstmt.addBatch();
}