a_class_teacher_del.jsp

来自「企业员工考勤系统」· JSP 代码 · 共 27 行

<%@ page contentType="text/html;charset=GBK" import="java.sql.*" %>
<%@ page errorPage="/public/errorBusy.jsp" %>
<%@ include file="/public/check_admin.jsp" %>
<jsp:useBean id="conn" scope="page" class="SQLBean.DBConn"/>

<%! 
  String id="";
  String sql="";
 %>
 
<%
  request.setCharacterEncoding("GBK");
  id=request.getParameter("id");
  sql="delete from class_teacher_user where id='"+id+"'";  
  try
  { 
   conn.executeUpdate(sql);
   conn.close();
   response.sendRedirect("account_class_teacher_m.jsp");
   }
   catch(Exception e){
   out.println("当前班主已经安排成一个班的班主任，不能删除！");
    // response.sendRedirect("/kaoqin/public/dberror.jsp"); 
   }
 %>