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

<%!
  String college_id=""; 
  String class_teacher_id=""; 
  String class_id="";
  String year_id="";
  int result=0;
 %>
 
 <% 
  request.setCharacterEncoding("GBK");
  class_teacher_id=request.getParameter("class_teacher_id");
  class_id=request.getParameter("class_id");
  year_id=request.getParameter("year_id");
  college_id=request.getParameter("college_id");
  if(!class_teacher_id.equals("")&&class_teacher_id!=null){
    String sql="select * from class_class_teacher where class_id='"+class_id+"' and year_id='"+year_id+"'";
    ResultSet rs=null;
    rs=conn.executeQuery(sql);
    if(rs.next()){
      sql="delete from class_class_teacher where class_id='"+class_id+"' and year_id='"+year_id+"'";
      conn.executeUpdate(sql);
      conn.close();
    }
    conn.close();
    //rs.close();
    String _sql="insert into class_class_teacher values('"+class_id+"','"+year_id+"','"+class_teacher_id+"')";
    conn.executeUpdate(_sql);
    conn.close();
    String url="class_teacher.jsp?year_id="+year_id+"&college_id="+college_id;
    response.sendRedirect(url);
  }else{
  %>
  <jsp:forward page="c_teacher_zd.jsp">
     <jsp:param name="class_id" value="<%=class_id%>"/>
     <jsp:param name="year_id" value="<%=year_id%>"/>
     <jsp:param name="college_id" value="<%=college_id%>"/>
     <jsp:param name="errmsg" value="请选择班主任"/>
  </jsp:forward>
  
  <% 
    }
   %>