del_stu_kq.jsp

企业员工考勤系统

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

<%! 
  String id="";
  String sql="";
  String kecheng_id="";
  String sk_time="";
  String stu_number="";
  String teacher_id="";
  String class_id="";
  String year_id="";
 
 %>
 
<%
  request.setCharacterEncoding("GBK");
  id=request.getParameter("id");
  sk_time=request.getParameter("sk_time");
 
  stu_number=request.getParameter("stu_number");
   year_id=request.getParameter("year_id");
   kecheng_id=request.getParameter("kecheng_id");
   class_id=request.getParameter("class_id");
  
    sql="delete from kaoqin_record where id='"+id+"' and stu_number='"+stu_number+"' and sk_time='"+sk_time+"'";
    conn.executeUpdate(sql);
    conn.close();
    String url="stu_kq.jsp?year_id="+year_id+"&kecheng_id="+kecheng_id+"&class_id="+class_id+"&stu_number="+stu_number;
   response.sendRedirect(url);
 %>