📄 updateuser.jsp

📁 实现了一个OA系统基本的功能
💻 JSP
字号:
<%@ page language="java" import="java.util.*" contentType="text/html;charset=gb2312" import="java.sql.*" errorPage="errorpage.jsp"%>
<%@page import="oabean.database"%>
<%@page import="oabean.common"%>



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>

    
    <title>修改员工</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
<script Language="JavaScript">
    function check()
    {  
      var flag=1;
      var s="";
    if(document.info.userName.value=="")
      { 
       s="请输入员工姓名";
       flag=0;
      }
     
      if(document.info.depName.value=="")
      { if(flag==0) s+=",选择部门";
        else s="请选择部门";
        flag=0;
      }
       if(document.info.power.value=="")
      { if(flag==0) s+=",分配职位";
        else s="请分配职位";
        flag=0;
      }
      if(flag==0)
      { 
        alert(s+"!"); return false;
      }
      else return true;
   }
   
	function mycheck()
	{
	window.opener.location.reload();
	}
	
   </script>

  </head>
 
  <jsp:useBean id="department" scope="page" class="oabean.departmentBean"/>
  <body bgcolor="#4692B3"text="#FFFFFF"link="#33FF00">
  <p>
 
    
  <form name="info" action="user/updateUser.user" onsubmit="return check();" method="post">
  
<%  
  String uname=(String)session.getAttribute("user"); 
  if(uname==null) 
  {
  response.sendRedirect("../index.jsp");
  }   
  oabean.common common= new oabean.common();
  database db=new database();
     
  String userid=request.getParameter("userId");
  String sql="select * from oa_user where userId='"+userid+"'";
  ResultSet rs=db.executeQuery(sql);
  String username="";
  int depid=0;
  String power=null;
  if(rs.next())
  {  
   username=rs.getString("userName");
   depid=rs.getInt("depId");
   power=""+rs.getInt("power");
   rs.close();
  }
 %>
  <table width="49%" height="50" border="0" align="center">
    <tr><td>姓名:<input name="userName" type="text" value="<%=username %>"></td></tr>
    <tr><td> 属于部门:<select name="depName">      
                <%
                 rs=department.getDeparment();
                 String name="";
                 int depId=0;
                 while(rs.next())
                 { 
                  name=rs.getString("depName");
                  depId=rs.getInt("depId");
                  if(depId!=depid)
                  {
                 %>
                 <option value="<%=depId %>"><%=name%></option> 
                 <% 
                  }
                  else
                  { 
                  %>   
                    <option value="<%=depId %>" selected><%=name%></option>     
                 <%}  }
                 %>
              </select>
   </td></tr>  
    <tr><td>分配职位:<select name="power"> 
                     <%
                     if (("1").equals(power)) 
                     {
                     %> 
                     <option value="1" selected>一般员工</option> 
                     <option value="2">部门管理员</option>
                     <%
                     }
                     else if(("2").equals(power))
                     {
                     %>
                     <option value="1" >一般员工</option> 
                     <option value="2" selected>部门管理员</option>
                     <%
                     }
                     %>
                  </select>
   </td></tr>  
   <tr><td><input name="userId" type="hidden" value="<%=userid%>" ></td></tr>
</table>
<p>
<table width="20%">
<tr>
<td><input type="submit" name="Submit" value="确定" onclick="mycheck();"></td> 
<td><input type="reset" name="res" value="重置"> </td>
 </form>
 <td><input type="submit" name="guanbi" value="取消" onclick="tb_remove();">	</td>
 </tr>
 </table>  
 </body> 
</html>
⌨️ 快捷键说明

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