从Java内部创建SQL批处理更新

灭霸詹再世

我想更新mySql数据库中特定列上的每一行。目前，我在java.sql.PreparedStatement每行中使用一个，并在for循环中进行迭代。我想知道在Java编程方面是否还有其他选择可以减少这种时间和资源的消耗（类似于批量执行准备好的语句）。更新是从Java代码进行的，因为这是我从中获取值的地方。我也没有兴趣在服务器上制作存储过程，因为我没有这样做的权利。

解决方案:


            这里是一个示例的链接，该示例使用Java的Prepared语句执行批处理更新。我还提供了该站点的示例以供快速参考。
http://www.exampledepot.com/egs/java.sql/BatchUpdate.html
try {
// Disable auto-commit
connection.setAutoCommit(false);
// Create a prepared statement
String sql = "INSERT INTO my_table VALUES(?)";
PreparedStatement pstmt = connection.prepareStatement(sql);
// Insert 10 rows of data
for (int i=0; i<10; i++) {
      pstmt.setString(1, ""+i);
      pstmt.addBatch();
}
// Execute the batch
int [] updateCounts = pstmt.executeBatch();
// All statements were successfully executed.
// updateCounts contains one element for each batched statement.
// updateCounts<i> contains the number of rows affected by that statement.
processUpdateCounts(updateCounts);
// Since there were no errors, commit
connection.commit();
} catch (BatchUpdateException e) {
// Not all of the statements were successfully executed
int[] updateCounts = e.getUpdateCounts();
// Some databases will continue to execute after one fails.
// If so, updateCounts.length will equal the number of batched statements.
// If not, updateCounts.length will equal the number of successfully executed statements
processUpdateCounts(updateCounts);
// Either commit the successfully executed statements or rollback the entire batch
connection.rollback();
} catch (SQLException e) {
}
public static void processUpdateCounts(int[] updateCounts) {
for (int i=0; i<u>= 0) {
         // Successfully executed; the number represents number of affected rows
      } else if (updateCounts<i> == Statement.SUCCESS_NO_INFO) {
         // Successfully executed; number of affected rows not available
      } else if (updateCounts<i> == Statement.EXECUTE_FAILED) {
         // Failed to execute
      }
}
}

从Java内部创建SQL批处理更新

灭霸詹再世 LV1