Java 与 SQL 结合：高效删除 Oracle 2016 - 2018 年数据，每 3000 条提交一次！

以下是一个示例代码： ```java import java.sql.*; public class DeleteData { public static void main(String[] args) { Connection conn = null; Statement stmt = null; try { conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "username", "password"); stmt = conn.createStatement(); int batchSize = 0; String sql = "DELETE FROM table_name WHERE year_column BETWEEN 2016 AND 2018"; ResultSet rs = stmt.executeQuery(sql); while(rs.next()) { batchSize++; if(batchSize % 3000 == 0) { conn.commit(); } } conn.commit(); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (stmt != null) stmt.close(); if (conn != null) conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } } ``` 请将示例代码中的`jdbc:oracle:thin:@localhost:1521:xe`、`username`、`password`以及`table_name`和`year_column`替换为实际的数据库连接信息和表信息。在实际使用时，请根据需求进行相应的配置和修改。 ######[AI写代码神器 | 856点数解答 | 2024-11-24 12:26:26]