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

📄 a_school_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 school_id="";
  String school_name="";
  String school_password="";
 %>
<% 
  request.setCharacterEncoding("GBK");
  id=request.getParameter("id");
  sql="select * from school_user where id='"+id+"'";
  rs=conn.executeQuery(sql);
  if(rs.next()){
    school_id=rs.getString("school_id");
    school_name=rs.getString("school_name");
    school_password=rs.getString("school_password");
  }
  conn.close();
%>
<script language="javascript">
  function formCheck(theForm)
  {
     if(theForm.school_id.value=="")
	 {
	    alert("用户名不能为空!");
		theForm.school_id.focus();
		return false;
	 }
     if(theForm.school_password.value=="")
	 {
	    alert("密码不能为空!");
		theForm.school_password.focus();
		return false;
	 }
     if(theForm.school_name.value=="")
	 {
	    alert("真实姓名不能为空!");
		theForm.school_name.focus();
		return false;
	 }
  }
</script>
<html>
  <head>
    <title>修改学校领导用户</title>
	<link rel="stylesheet" href="../../public/style.css">
  </head>
  <body class="ss">
  <a href="account_school.jsp" class="a">添加账号</a>&nbsp;&nbsp;
  <a href="account_school_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_school_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="school_id" type="text" value="<%=school_id%>" size="20" maxlength="20"></td>
    </tr>
    <tr>
       <td colspan="2">&nbsp;</td>
    </tr>
    <tr>
       <td>真实姓名:</td>
       <td><input name="school_name" type="text" value="<%=school_name%>" size="20" maxlength="20"></td>
    </tr>
    <tr>
       <td colspan="2">&nbsp;</td>
    </tr>
    <tr>
       <td>密码:</td>
       <td><input name="school_password" type="password" value="<%=school_password%>" size="20" maxlength="20"></td>
    </tr>
    <tr>
       <td colspan="2">&nbsp;</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 + -