jsp删除mysql

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://localhost:3306/your_database";
    String username = "your_username";
    String password = "your_password";
    
    Connection conn = null;
    PreparedStatement pstmt = null;
    
    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection(url, username, password);
        
        String idToDelete = request.getParameter("id"); // 假设从请求中获取要删除的记录ID
        String sql = "DELETE FROM your_table WHERE id = ?";
        
        pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, idToDelete);
        
        int rowsDeleted = pstmt.executeUpdate();
        if (rowsDeleted > 0) {
            out.println("A record was deleted successfully!");
        }
    } catch (SQLException e) {
        out.println("SQL Exception: " + e.getMessage());
    } catch (ClassNotFoundException e) {
        out.println("Class Not Found Exception: " + e.getMessage());
    } finally {
        try {
            if (pstmt != null) pstmt.close();
            if (conn != null) conn.close();
        } catch (SQLException e) {
            out.println("Error closing resources: " + e.getMessage());
        }
    }
%>