String sql = "INSERT INTO your_table (column1, column2) VALUES (?, ?), (?, ?), (?, ?)";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
// 設(shè)置占位符的值
preparedStatement.setString(1, value1);
preparedStatement.setString(2, value2);
preparedStatement.setString(3, value3);
preparedStatement.setString(4, value4);
preparedStatement.setString(5, value5);
preparedStatement.setString(6, value6);
// 執(zhí)行批處理
int[] batchResults = preparedStatement.executeBatch();

Statement statement = connection.createStatement();
statement.addBatch("INSERT INTO your_table (column1, column2) VALUES ('value1', 'value2')");
statement.addBatch("INSERT INTO your_table (column1, column2) VALUES ('value3', 'value4')");
statement.addBatch("INSERT INTO your_table (column1, column2) VALUES ('value5', 'value6')");
int[] batchResults = statement.executeBatch();

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class BatchInsertExample {
    public static void main(String[] args) {
        String jdbcUrl = "jdbc:mysql://localhost:3306/tbl";
        String username = "root";
        String password = "root";
        Connection connection = null;
        PreparedStatement preparedStatement = null;
        try {
            // 建立數(shù)據(jù)庫連接
            connection = DriverManager.getConnection(jdbcUrl, username, password);
            // SQL插入語句，使用占位符來防止SQL注入
            String sql = "INSERT INTO goods(name, price) VALUES (?, ?)";
            // 創(chuàng)建PreparedStatement對(duì)象，并設(shè)置為批處理模式
            preparedStatement = connection.prepareStatement(sql);
            connection.setAutoCommit(false); // 設(shè)置為手動(dòng)提交
            // 循環(huán)添加多個(gè)批處理操作
            for (int i = 0; i < 10; i++) {
                // 設(shè)置占位符的值
                preparedStatement.setString(1, "value" + i);
                preparedStatement.setString(2, "value" + (i * 2));
                // 添加到批處理中
                preparedStatement.addBatch();
            }
            // 執(zhí)行批處理
            int[] batchResults = preparedStatement.executeBatch();
            // 手動(dòng)提交事務(wù)
            connection.commit();
            // 檢查批處理執(zhí)行結(jié)果
            for (int result : batchResults) {
                if (result == PreparedStatement.SUCCESS_NO_INFO || result == PreparedStatement.EXECUTE_FAILED) {
                    // 處理失敗的情況
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
            try {
                // 發(fā)生異常時(shí)回滾事務(wù)
                if (connection != null) {
                    connection.rollback();
                }
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        } finally {
            try {
                // 關(guān)閉PreparedStatement和Connection
                if (preparedStatement != null) {
                    preparedStatement.close();
                }
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}