Java 批量执行SQL语句

话不多少 直接上代码

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
 
public class BatchExecutionExample {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/yourdatabase";
        String username = "yourusername";
        String password = "yourpassword";
 
        Connection conn = null;
        Statement statement = null;
 
        try {
            conn = DriverManager.getConnection(url, username, password);
            statement = conn.createStatement();
 
            // 开始批处理
            statement.addBatch("INSERT INTO yourtable (column1, column2) VALUES ('value1', 'value2')");
            statement.addBatch("INSERT INTO yourtable (column1, column2) VALUES ('value3', 'value4')");
            // ... 添加更多的插入语句 ...
 
            // 执行批处理
            int[] updateCounts = statement.executeBatch();
 
            // 提交事务
            conn.commit();
 
            System.out.println("Batch execution completed successfully");
 
        } catch (SQLException e) {
            try {
                if (conn != null) {
                    conn.rollback(); // 在发生异常的情况下回滚事务
                }
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
            e.printStackTrace();
        } finally {
            try {
                if (statement != null) {
                    statement.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}