#Servlet删除操作
通过ID找到对应的信息并删除,并重定向到列表页面
@WebServlet("/delete")
public class delect extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String id = request.getParameter("id");
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/1701d", "root", "root");
PreparedStatement pr = conn.prepareStatement("delete from tb_car2 where id=?");
pr.setString(1, id);
int insert = pr.executeUpdate();
if (insert > 0) {
System.out.println("删除成功");
response.sendRedirect("list");
} else {
System.out.println("删除失败");
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}