a_school_update_p.jsp

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

<%@ page contentType="text/html;charset=GBK" import="java.sql.*"%>
<%@ 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 id="";
  String school_id="";
  String school_name="";
  String school_password="";
 %>
<% 
  request.setCharacterEncoding("GBK");
  id=request.getParameter("id");
  school_id=request.getParameter("school_id");
  school_name=request.getParameter("school_name");
  school_password=request.getParameter("school_password");  
  sql="select school_id from school_user where school_id='"+school_id+"' and id !='"+id+"'";
  rs=conn.executeQuery(sql);
  if(rs.next()){
%>
     <jsp:forward page="a_school_update.jsp">
        <jsp:param name="errmsg" value="用户名已存在,账号修改失败!"/>
		<jsp:param name="id" value="<%=id%>" />
     </jsp:forward>
<%
  }else{
    sql="update school_user set school_id='"+school_id+"',school_password='"+school_password+"',school_name='"+school_name+"' where id='"+id+"'";
    conn.executeUpdate(sql);
    conn.close();
 %>
      <jsp:forward page="a_school_update.jsp">
        <jsp:param name="errmsg" value="账号修改成功!"/>
		<jsp:param name="id" value="<%=id%>" />
     </jsp:forward>
 <%
   }
  conn.close();
 %>