stu_add_2.jsp

企业员工考勤系统

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

<%! 
  ResultSet rs=null;
  String sql="";
  String sp_id="";
  String grade_name="";
  String class_number_name="";
  String url="";
  String class_id="";
 %>
 
 <% 
   request.setCharacterEncoding("GBK");
   sp_id=request.getParameter("sp_id");
   grade_name=request.getParameter("grade_name");
   class_number_name=request.getParameter("class_number_name");
   sql="select class_id from class_sp_college where sp_id='"+sp_id+"' and grade_name='"+grade_name+"' and class_number_name='"+class_number_name+"'";
   rs=conn.executeQuery(sql);
   if(rs.next()){
      class_id=rs.getString("class_id");
      url="stu_manager.jsp?class_id="+class_id;
      response.sendRedirect(url);
   }else{
   %>
     <jsp:forward page="stumanager.jsp">
        <jsp:param name="errmsg" value="班级不存在!"/>
     </jsp:forward>
  <%
     }
  %>