class_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 sp_id="";
  String grade_name="";
  String sql="";
  int result=0;
  String class_id="";
  String class_number_name="";
 %>
 
 <% 
   request.setCharacterEncoding("GBK");
   sp_id=request.getParameter("sp_id");
   grade_name=request.getParameter("grade_name");
   class_number_name=request.getParameter("class_number_name");
   class_id=grade_name+sp_id+class_number_name;
   sql="select * from class where class_id='"+class_id+"'";
   rs=conn.executeQuery(sql);
   if(rs.next()){
  %>
      <jsp:forward page="classmanager.jsp">
         <jsp:param name="errmsg" value="班级以存在,请重新选择!"/>
      </jsp:forward>
  <% 
     }else{
        sql="insert into class values('"+class_id+"'";
        sql+=",'"+grade_name+"'";
        sql+=",'"+sp_id+"'";
        sql+=",'"+class_number_name+"')";
        result=conn.executeUpdate(sql);
        conn.close();
  %>
      <jsp:forward page="classmanager.jsp">
         <jsp:param name="errmsg" value="班级建立成功!"/>
      </jsp:forward>
  <%
      } 
      conn.close();
  %>