kebiao_del.jsp

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

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

<%! 
  String class_id="";
  String year_id="";
  String sql="";
  String _sql="";
 %>
<% 
  request.setCharacterEncoding("GBK");
  class_id=request.getParameter("class_id");
  year_id=request.getParameter("year_id");
  sql="delete from course_time where class_id='"+class_id+"' and year_id='"+year_id+"'";
  _sql="delete from course_name where class_id='"+class_id+"' and year_id='"+year_id+"'";
  conn.executeUpdate(sql);
  conn.executeUpdate(_sql);
  conn.close();
  response.sendRedirect("course_view.jsp");
 %>