grade_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"/>

<%! 
  ResultSet rs=null;
  
  String grade_name="";
  String sql="";
  int result=0;
 %>
 
 <% 
   request.setCharacterEncoding("GBK");
  
   grade_name=request.getParameter("grade_name");
   sql="select grade_name from grade where grade_name='"+grade_name+"'";
   rs=conn.executeQuery(sql);//执行所有的查寻操作
  if(rs.next()){
  %>
     <jsp:forward page="grade_manager.jsp">
        <jsp:param name="errmsg" value="年级名称以存在,请重新输入!"/>
     </jsp:forward>
  <% 
   }else{
        sql="insert into grade values('"+grade_name+"')";
        
        result=conn.executeUpdate(sql);
        conn.close();
  %>
     <jsp:forward page="grade_manager.jsp">
        <jsp:param name="errmsg" value="年级成功添加!"/>
     </jsp:forward>
 <%
    }
  conn.close();
 %>