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