a_school_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"/>

<%! 
  String id="";
  String sql="";
 %>

<%
  request.setCharacterEncoding("GBK");
  id=request.getParameter("id");
  try
  { 
   sql="delete from school_user where id='"+id+"'";
   conn.executeUpdate(sql);
   conn.close();
   response.sendRedirect("account_school_m.jsp");
   }
   catch(Exception e){
   response.sendRedirect("/kaoqin/public/dberror.jsp"); 
   }
 %>