jsp删除mysql数据库数据

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>

<%
  // 定义数据库连接信息
  String url = "jdbc:mysql://localhost:3306/your_database";
  String username = "your_username";
  String password = "your_password";
  
  // 建立数据库连接
  Connection conn = null;
  try {
    Class.forName("com.mysql.jdbc.Driver");
    conn = DriverManager.getConnection(url, username, password);

    // 编写SQL语句
    String sql = "DELETE FROM your_table WHERE id = ?";
    
    // 创建PreparedStatement对象
    PreparedStatement pstmt = conn.prepareStatement(sql);
    
    // 设置参数值
    pstmt.setInt(1, 1); // 假设要删除的数据的id为1
    
    // 执行SQL语句
    pstmt.executeUpdate();
    
    // 关闭PreparedStatement对象
    pstmt.close();
  } catch (Exception e) {
    e.printStackTrace();
  } finally {
    // 关闭数据库连接
    if (conn != null) {
      try {
        conn.close();
      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
  }
%>