class_del.jsp

企业员工考勤系统

<%@ 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 sp_id="";
  String id="";
  String sql="";
  String _sql="";
 %>
<% 
  request.setCharacterEncoding("GBK");
  id=request.getParameter("id");
  _sql="select * from class where id='"+id+"'";
  try{
    rs=conn.executeQuery(_sql);
    rs.next();
    sp_id=rs.getString("sp_id");
    conn.close();
  }catch(Exception e){}
  try
  { 
   sql="delete from class where id='"+id+"'";
   conn.executeUpdate(sql);
   conn.close();
   String url="class_manager.jsp?sp_id="+sp_id;
   response.sendRedirect(url);
   }
   catch(Exception e){
   response.sendRedirect("/kaoqin/public/dberror.jsp"); 
   }
 %>