jsp批量删除mysql数据库

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String user = "username";
    String password = "password";
    Connection conn = null;
    PreparedStatement pstmt = null;

    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection(url, user, password);

        // 假设我们要删除所有status为'inactive'的记录
        String sql = "DELETE FROM mytable WHERE status = ?";
        pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, "inactive");

        int rowsDeleted = pstmt.executeUpdate();
        out.println(rowsDeleted + " rows deleted.");
    } catch (Exception e) {
        out.println("Error: " + e.getMessage());
    } finally {
        try { pstmt.close(); } catch (Exception e) {}
        try { conn.close(); } catch (Exception e) {}
    }
%>