sp_del.jsp

jsp+mssql 实现考勤的基本功能 包括签到 签离 请假 销假 批假等功能

<%@ 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 college_id="";
  String id="";
  String sql="";
  String _sql="";
 %>
 
<% 
  request.setCharacterEncoding("GBK");
  id=request.getParameter("id");
  _sql="select * from specialty where id='"+id+"'";
  try{
    rs=conn.executeQuery(_sql);
    rs.next();
    college_id=rs.getString("college_id");
    conn.close();
  }catch(Exception e){}

  try
   { 
   sql="delete from specialty where id='"+id+"'";
   conn.executeUpdate(sql);
   conn.close();
   String url="sp_manager.jsp?college_id="+college_id;
   response.sendRedirect(url);
   }
   catch(Exception e){
   response.sendRedirect("/kaoqin/public/dberror.jsp"); 
   }
 %>