stu_del.jsp

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

<%@ 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"/>

<%! 
 ResultSet rs=null;
  String id="";
  String stu_number="";
  String class_id="";
  String sql="";
  String _sql="";
 %>
<% 
  request.setCharacterEncoding("GBK");
  id=request.getParameter("id");
  _sql="select * from student where id='"+id+"'";
  try{
    rs=conn.executeQuery(_sql);
    rs.next();
    class_id=rs.getString("class_id");
    stu_number=rs.getString("stu_number");
    conn.close();
  }catch(Exception e){}

  try
  { 
   sql="delete from student where id='"+id+"'";
   conn.executeUpdate(sql);
   conn.close();
   sql="delete from stu_user where stu_id='"+stu_number+"'";
   conn.executeUpdate(sql);
   conn.close();
   String url="stu_manager.jsp?class_id="+class_id;
   response.sendRedirect(url);
   }
   catch(Exception e){
   response.sendRedirect("/kaoqin/public/dberror.jsp"); 
   }
 %>