course_storage.jsp

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

<%@ 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"/>

<%! 
   ResultSet rs=null;
   String course_id="";
   String week="";
   String lesson="";
   String status="0";
   String sql="";
   int result=0;
   String year_id="";
   String class_id="";
 %>
 <% 
   request.setCharacterEncoding("GBK");
   year_id=request.getParameter("year_id");
   class_id=request.getParameter("class_id");
   sql="select * from course_time where class_id='"+class_id+"' and year_id='"+year_id+"'";
   ResultSet _rs=null;
   _rs=conn.executeQuery(sql);
   if(_rs.next()){
     sql="delete from course_time where class_id='"+class_id+"' and year_id='"+year_id+"'";
     conn.executeUpdate(sql);
   }
   sql="select * from course";
   rs=conn.executeQuery(sql);
   if(rs.next()){
     do{
       course_id=rs.getString("course_id");
       week=rs.getString("week_id");
       lesson=rs.getString("lesson_id");  
       status=rs.getString("status");
       sql="insert into course_time values('"+course_id+"','"+week+"','"+lesson+"','"+year_id+"','"+class_id+"','"+status+"')";
       result=conn.executeUpdate(sql);
      }while(rs.next());
     String sql_d="delete from course"; 
     conn.executeUpdate(sql_d);
     conn.close();
     response.sendRedirect("storage_success.jsp");
   }else
     response.sendRedirect("storage_errors.jsp");
  %>