course_del.jsp

企业员工考勤系统

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

<%! 
 String course_id="";
 String year_id="";
 String college_id="";
 String grade_name="";
 String sp_id="";
 String class_number_name="";
 String sql="";
 %>

<% 
  request.setCharacterEncoding("GBK");
  course_id=request.getParameter("course_id");
  year_id=request.getParameter("year_id");
  college_id=request.getParameter("college_id");
  grade_name=request.getParameter("grade_name");
  sp_id=request.getParameter("sp_id");
  class_number_name=request.getParameter("class_number_name");

  try
  { 
   sql="delete from course_name where course_id='"+course_id+"'";
   conn.executeUpdate(sql);
   conn.close();
%>
     <jsp:forward page="course.jsp">
        <jsp:param name="year_id" value="<%=year_id%>"/>
        <jsp:param name="college_id" value="<%=college_id%>"/>
        <jsp:param name="grade_name" value="<%=grade_name%>"/>
        <jsp:param name="sp_id" value="<%=sp_id%>"/>
        <jsp:param name="class_number_name" value="<%=class_number_name%>"/>
     </jsp:forward>
<%
   }
   catch(Exception e){
   response.sendRedirect("/kaoqin/public/dberror.jsp"); 
   }
 %>