stu_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 class_id="";
  String stu_number="";
  String stu_name="";
  String stu_sex="";
  String sql="";
  String _sql="";
  int result=0;
 %>
 
 <% 
   request.setCharacterEncoding("GBK");
   class_id=request.getParameter("class_id");
   stu_number=request.getParameter("stu_number");
   stu_name=request.getParameter("stu_name");
   stu_sex=request.getParameter("stu_sex");
   sql="select stu_number from student where stu_number='"+stu_number+"'";
   rs=conn.executeQuery(sql);
   if(rs.next()){
  %>
     <jsp:forward page="stu_manager.jsp">
        <jsp:param name="errmsg" value="学号以经存在,请重新输入!"/>
     </jsp:forward>
  <% 
      }else{
        sql="insert into student values('"+stu_number+"'";
        sql+=",'"+stu_name+"'";
        sql+=",'"+stu_sex+"'";
        sql+=",'"+class_id+"')";
        result=conn.executeUpdate(sql);
        
         _sql="insert into stu_user values('"+stu_number+"'"+",'"+stu_number+"')";
        result=conn.executeUpdate(_sql);
        
        conn.close();
   %>
        <jsp:forward page="stu_manager.jsp">
		   <jsp:param name="errmsg" value="学生添加成功！"/>
		</jsp:forward>
  <%
        }
   conn.close();
  %>