WebRoot/admin/classroom-bodel.jsp

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

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

 <% 
 
request.setCharacterEncoding("utf-8");
String num=request.getParameter("num");

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 borrowroom where (num='"+num+"')";
int i=state.executeUpdate(sql);
if(i==1){
 %>
 <div align=center>
 <h3>该信息删除成功！</h3>
 <%
 }else{
 %>
 <h3>该信息删除失败!</h3></div>
 <% 
 }
 state.close();
 conn.close();
 

 %> 
 </body>
 </html>