⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 a_class_teacher_update.jsp

📁 jsp+mssql 实现考勤的基本功能 包括签到 签离 请假 销假 批假等功能
💻 JSP
字号:
<%@ 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 class_teacher_id="";
  String class_teacher_name="";
  String class_teacher_password="";
  String college_id_l="";
 %>
<% 
  request.setCharacterEncoding("GBK");
  id=request.getParameter("id");
  sql="select * from class_teacher_user where id='"+id+"'";
  rs=conn.executeQuery(sql);
  if(rs.next()){
   class_teacher_id=rs.getString("class_teacher_id");
   class_teacher_name=rs.getString("class_teacher_name");
   class_teacher_password=rs.getString("class_teacher_password");
   college_id_l=rs.getString("college_id");
  }
  conn.close();
%>
<script language="javascript">
  function formCheck(theForm)
  {
     if(theForm.class_teacher_id.value=="")
	 {
	    alert("用户名不能为空!");
		theForm.class_teacher_id.focus();
		return false;
	 }
     if(theForm.class_teacher_password.value=="")
	 {
	    alert("密码不能为空!");
		theForm.class_teacher_password.focus();
		return false;
	 }
     if(theForm.class_teacher_name.value=="")
	 {
	    alert("真实姓名不能为空!");
		theForm.class_teacher.focus();
		return false;
	 }
  }
</script>
<html>
  <head>
     <title>修改管理员用户</title>
	 <link rel="stylesheet" href="../../public/style.css">
  </head>
  <body class="ss">
  <a href="account_class_teacher.jsp" class="a">添加账号</a>&nbsp;&nbsp;
  <a href="account_class_teacher_m.jsp" class="a">管理账号</a>&nbsp;&nbsp;
  <a href="javascript:window.location.reload()" class="a">刷新</a>&nbsp;&nbsp;
  <a href="javascript:history.back()" class="a">返回</a>
  <hr></hr>
  <center>
  <h3>修改任课老师账号</h3>
  <form action="a_class_teacher_update_p.jsp" method="post" onSubmit="return formCheck(this)">
  <input type="hidden" name="id" value="<%=id%>">
  <table width="40%" border="0" cellspacing="0">
    <tr>
       <td>用户名:</td>
       <td><input name="class_teacher_id" type="text" value="<%=class_teacher_id%>" size="20" maxlength="20"></td>
    </tr>
    <tr>
       <td colspan="2">&nbsp;</td>
    </tr>
    <tr>
       <td>真实姓名:</td>
       <td><input name="class_teacher_name" type="text" value="<%=class_teacher_name%>" size="20" maxlength="20"></td>
    </tr>
    <tr>
       <td colspan="2">&nbsp;</td>
    </tr>
    <tr>
       <td>密码:</td>
       <td><input name="class_teacher_password" type="password" value="<%=class_teacher_password%>" size="20" maxlength="20"></td>
    </tr>
    <tr>
       <td colspan="2">&nbsp;</td>
    </tr>
    <tr>
       <td>所属院系:</td>
       <td><select name="college_id">
	   <% 
         ResultSet rs_c=null;
         String college_id="";
         rs_c=conn.executeQuery("select * from college");
         if(rs_c.next()){
            do{
                college_id=rs_c.getString("college_id"); 
                if(college_id_l.equals(college_id))
                    out.println("<option value="+rs_c.getString("college_id")+" selected>"+rs_c.getString("college_name")+"</option>");
                else
                    out.println("<option value="+rs_c.getString("college_id")+">"+rs_c.getString("college_name")+"</option>");
             }while(rs_c.next());
          }
          conn.close();
       %>
       </select></td>
    </tr>
    <tr>
       <td><center><input type="submit" value="修改"></center></td>
       <td><center><a href="javascript:history.back()">返回</a></center></td>
    </tr>
    <tr>
        <td colspan="2">&nbsp;</td>
    </tr>
    <%
		 String msg=(String)request.getParameter("errmsg");
	     if(msg!=null&&!msg.equals("")){
    %>
    <tr>
        <td colspan="2"><div align="center"><font color="red" size="2"><%=msg%></font></div></td>
    </tr>
   <%
         }
    %>
  </table>
  </form>
  </center>
  </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -