jsp删除用户的关键代码

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class DeleteUserServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String userId = request.getParameter("userId");
        
        Connection conn = null;
        PreparedStatement pstmt = null;
        
        try {
            // 加载数据库驱动
            Class.forName("com.mysql.jdbc.Driver");
            
            // 获取数据库连接
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/yourdatabase", "username", "password");
            
            // 准备SQL语句
            String sql = "DELETE FROM users WHERE id = ?";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, userId);
            
            // 执行删除操作
            int rowsAffected = pstmt.executeUpdate();
            
            if (rowsAffected > 0) {
                response.sendRedirect("success.jsp"); // 删除成功后跳转到成功页面
            } else {
                response.sendRedirect("error.jsp"); // 删除失败后跳转到错误页面
            }
        } catch (Exception e) {
            e.printStackTrace();
            response.sendRedirect("error.jsp");
        } finally {
            try {
                if (pstmt != null) pstmt.close();
                if (conn != null) conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

<a href="DeleteUserServlet?userId=<%= user.getId() %>">删除用户</a>