year_add.jsp

企业员工考勤系统

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

<%! 
  ResultSet rs=null;
  String sql="";
  String year_id="";
  String year_name="";
  String year_start="";
  String year_end="";
 %>
 
 <% 
   request.setCharacterEncoding("GBK");
   year_id=request.getParameter("year_id");
   year_name=request.getParameter("year_name");
   year_start=request.getParameter("year_start");
   year_end=request.getParameter("year_end");
   sql="select year_id from year where year_id='"+year_id+"'";
   rs=conn.executeQuery(sql);
   if(rs.next())
     {
  %>
  <jsp:forward page="year_manager.jsp">
    <jsp:param name="msg" value="学年代号以存在,请重新输入!"/>
  </jsp:forward>
  <% 
     }
   else{
     sql="insert into year values('"+year_id+"','"+year_name+"','"+year_start+"','"+year_end+"')";
     conn.executeUpdate(sql);
  %>
  <jsp:forward page="year_manager.jsp">
    <jsp:param name="msg" value="学年添加成功!"/>
  </jsp:forward>  
  
  <%
   }
  %>