<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.sql.*"%>
删除页面
<%
request.setCharacterEncoding("utf-8");
String id = request.getParameter("id");
String url="jdbc:mysql://127.0.0.1:3306/teamessage?serverTimezone=UTC";
String username = "root";
String password = "1314";
Connection conn = DriverManager.getConnection(url,username,password);
String sql = "delete from teachermessage where id=?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1,Integer.parseInt(id));
int result = pstmt.executeUpdate();
String msg = "删除失败，单击点击跳转到老师信息页面";
if(result==1){
msg = "删除成功，跳转到老师信息页面";
}
pstmt.close();
conn.close();
%>
<%
response.setHeader("Refresh","2;url=TeachMessage.jsp");
%>