java preparedstatement 执行批量数据调优的核心做法是开启 jdbc url 的 rewritebatchedstatements 参数,并在代码中配合使用 addbatch() 和 executebatch()。这样可以将多条 sql 合并为一条网络请求发送给数据库,显著降低 i/o 开销并提升吞吐量。

rewriteBatchedStatements 参数如何改变驱动行为
该参数直接控制 MySQL Connector/J 对批量语句的处理策略。默认情况下,驱动会将每条 SQL 单独发送;开启后,驱动会拦截 addBatch() 调用,将语句拼接成 INSERT INTO ... VALUES (...), (...) 格式一次性提交。

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class BatchOptimization {
public static void main(String[] args) throws Exception {
// 关键:URL 中必须包含 rewriteBatchedStatements=true
String url = "jdbc:mysql://localhost:3306/test?rewriteBatchedStatements=true";
Connection conn = DriverManager.getConnection(url, "user", "pass");
String sql = "INSERT INTO users (name, age) VALUES (?, ?)";
try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
for (int i = 0; i
<h2>executeBatch() 返回值与事务控制的影响</h2>
<p>executeBatch() 返回的是 int 数组,每个元素代表对应语句受影响的行数。如果未关闭自动提交(autoCommit),每批数据可能触发多次隐式提交,导致性能瓶颈。建议手动管理事务或使用 setAutoCommit(false)。</p><div class="aritcle_card flexRow artxards">
<div class="artcardd flexRow">
<a class="aritcle_card_img" rel="nofollow" href="/xiazai/skill13095" title="Build Java agent transport gateways with Atmosphere"><img
src="https://img.php.cn/upload/skill/001/246/273/6adaf20e352aa140.jpg" alt="Build Java agent transport gateways with Atmosphere" onerror="this.onerror='';this.src='/static/lhimages/moren/morentu.png'" ></a>
<div class="aritcle_card_info flexColumn">
<a rel="nofollow" href="/xiazai/skill13095" title="Build Java agent transport gateways with Atmosphere" class="overflowclass">Build Java agent transport gateways with Atmosphere</a>
<p class="overflowclass">使用Atmosphere构建通过WebSocket、SSE、gRPC、WebTransport、MCP、A2A和AG-UI流传输的JVM代理网关,并带有治理钩子。</p>
</div>
<a rel="nofollow" href="/xiazai/skill13095" title="Build Java agent transport gateways with Atmosphere" class="aritcle_card_btn flexRow flexcenter"><b></b><span>下载</span>
</a>
</div>
</div><p>@@##@@</p>
<pre class="brush:php;toolbar:false;">import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class TransactionalBatch {
public static void main(String[] args) throws Exception {
String url = "jdbc:mysql://localhost:3306/test?rewriteBatchedStatements=true";
Connection conn = DriverManager.getConnection(url, "user", "pass");
// 关闭自动提交以控制事务边界
conn.setAutoCommit(false);
String sql = "INSERT INTO users (name, age) VALUES (?, ?)";
try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
for (int i = 0; i
<h2>当单条 SQL 超过 1MB 时会发生什么</h2>
<p>MySQL 默认 max_allowed_packet 限制为 4MB,但 JDBC 驱动在拼接批量语句时若单条 SQL 字符串过长,可能触发 PacketTooBigException。此时需调整服务器配置或分批处理。</p>

Java免费学习笔记:立即使用
解锁 Java 大师之旅:从入门到精通的终极指南










