a_admin_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 admin_id="";
  String admin_name="";
  String admin_password="";
 %>
<% 
  request.setCharacterEncoding("GBK");
  id=request.getParameter("id");
  admin_id=request.getParameter("admin_id");
  admin_name=request.getParameter("admin_name");
  admin_password=request.getParameter("admin_password");  
  sql="select admin_id from admin_user where admin_id='"+admin_id+"' and id !='"+id+"'";
  rs=conn.executeQuery(sql);
  if(rs.next()){
%>
     <jsp:forward page="a_admin_update.jsp">
        <jsp:param name="errmsg" value="用户名已存在,账号修改失败!"/>
		<jsp:param name="id" value="<%=id%>" />
     </jsp:forward>
<%
  }else{
    sql="update admin_user set admin_id='"+admin_id+"',admin_password='"+admin_password+"',admin_name='"+admin_name+"' where id='"+id+"'";
    conn.executeUpdate(sql);
    conn.close();
 %>
      <jsp:forward page="a_admin_update.jsp">
        <jsp:param name="errmsg" value="账号修改成功!"/>
		<jsp:param name="id" value="<%=id%>" />
     </jsp:forward>
 <%
   }
  conn.close();
 %>