school_add.jsp

jsp+mssql 实现考勤的基本功能 包括签到 签离 请假 销假 批假等功能

<%@ 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 school_id="";
  String school_password_1="";
  String school_password_2="";
  String school_name="";
  String sql="";
  int result=0;
 %>
 
 <% 
   request.setCharacterEncoding("GBK");
   school_id=request.getParameter("school_id");
   school_password_1=request.getParameter("school_password_1");
   school_name=request.getParameter("school_name");
   sql="select school_id from school_user where school_id='"+school_id+"'";
   rs=conn.executeQuery(sql);
   if(rs.next()){
  %>
     <jsp:forward page="account_school.jsp">
        <jsp:param name="errmsg" value="用户名已存在,请重新输入!"/>
     </jsp:forward>
  <% 
      }else{
        sql="insert into school_user values('"+school_id+"'";
        sql+=",'"+school_password_1+"'";
        sql+=",'"+school_name+"')";
        result=conn.executeUpdate(sql);
        conn.close();
  %>
     <jsp:forward page="account_school.jsp">
        <jsp:param name="errmsg" value="用户成功添加!"/>
     </jsp:forward>  
  <%
    }
  conn.close();
  %>