package com.anbow.selvet;
import com.anbow.JDBC.JDBC;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
@WebServlet("/Delete")
public class UserDelete extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Connection connection = JDBC.getConnection();
System.out.println(connection);
String id = request.getParameter(“id”);
String sql = “delete from userlist where id = ?”;
try {
PreparedStatement ps = connection.prepareStatement(sql);
ps.setString(1,id);
ps.executeUpdate();
request.getRequestDispatcher("userList.jsp").forward(request,response);
} catch (SQLException e) {
e.printStackTrace();
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doPost(request,response);
}
}
**
需要给删除按钮传一个id
**