WebRoot/admin/stu-del.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=utf-8" import="java.sql.*"%>
<html>
<head>
<title>管理员页面</title>
</head>
<body>

<div align=center>
 <% 
request.setCharacterEncoding("utf-8");
String id=request.getParameter("id");

String user="root";
String password="root";
String url="jdbc:mysql://localhost:3306/JSFP";

Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection(url,user,password);
Statement state=conn.createStatement();

String sql="delete from student where id='"+id+"'";
int i=state.executeUpdate(sql);
if(i==1){
 %>
 <br><br><br><br>
 <div align=center>
 <h2>该信息删除成功！</h2>
 <%
 }else{
 %>
 <h2>该信息删除失败!</h2>
 </div>
 <% 
 }
 state.close();
 conn.close();

 %>
 </div>
</body>
</html>