JDBC PreparedStatement example - update batch

最新推荐文章于 2022-09-15 17:41:06 发布

原创最新推荐文章于 2022-09-15 17:41:06 发布 · 950 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#jdbc #insert #system #string #date #user

J2SE 专栏收录该内容

13 篇文章

订阅专栏

本文展示了一个使用JDBC PreparedStatement批量插入记录到数据库的示例。示例中通过设置自动提交为false并使用addBatch()方法来增加性能。

Here is an example to show you how to insert few recorders in batch process ,JDBC PreparedStatement.

dbConnection.setAutoCommit(false);//commit trasaction manually
 
String insertTableSQL = "INSERT INTO DBUSER"
			+ "(USER_ID, USERNAME, CREATED_BY, CREATED_DATE) VALUES"
			+ "(?,?,?,?)";				
PreparedStatement = dbConnection.prepareStatement(insertTableSQL);
 
preparedStatement.setInt(1, 101);
preparedStatement.setString(2, "mkyong101");
preparedStatement.setString(3, "system");
preparedStatement.setTimestamp(4, getCurrentTimeStamp());
preparedStatement.addBatch();
 
preparedStatement.setInt(1, 102);
preparedStatement.setString(2, "mkyong102");
preparedStatement.setString(3, "system");
preparedStatement.setTimestamp(4, getCurrentTimeStamp());
preparedStatement.addBatch();
preparedStatement.executeBatch();
 
dbConnection.commit();