course_add.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"/>

<%! 
  ResultSet rs=null;
  String year_id="";
  String class_id="";
  String kecheng_id="";
  String teacher_id="";
  String sql="";
 %>
 
 <% 
  String college_id=request.getParameter("college_id");
  String grade_name=request.getParameter("grade_name");
  String sp_id=request.getParameter("sp_id");
  String class_number_name=request.getParameter("class_number_name");
 
   request.setCharacterEncoding("GBK");
   year_id=request.getParameter("year_id");
   class_id=request.getParameter("class_id");
   kecheng_id=request.getParameter("kecheng_id");
   teacher_id=request.getParameter("teacher_id");
   sql="select * from course_name where year_id='"+year_id+"' and class_id='"+class_id+"' and kecheng_id='"+kecheng_id+"'";
   rs=conn.executeQuery(sql);
   if(rs.next()){
  %>
     <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:param name="errmsg" value="本学期该班以安排了此课程,请重新安排!"/>
     </jsp:forward>
  <% 
   }else{
     sql="insert into course_name values('"+class_id+"'";
     sql+=",'"+year_id+"'";
     sql+=",'"+kecheng_id+"'";
     sql+=",'"+teacher_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> 
  <% 
     }
  %>