<%@ 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 connn = DriverManager.getConnection(url,username,password); String sql = "delete from teachclass where id=?"; PreparedStatement pstmtn = connn.prepareStatement(sql); pstmtn.setInt(1,Integer.parseInt(id)); int result = pstmtn.executeUpdate(); String msgn = "删除失败，单击点击跳转到教师授课页面"; if(result==1){ msgn = "删除成功，跳转到教师授课页面"; } pstmtn.close(); connn.close(); %> <% response.setHeader("Refresh","2;url=TeachClass.jsp"); %>