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

📄 edituser.jsp

📁 用jsp和Oracle写的人事管理系统
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312"%> 
<%@ include file="JSP/OPENDB.jsp"%>
<%
String oabusyname = (String) session.getValue("oabusyname"); 
String oabusyusername = (String) session.getValue("oabusyusername"); 
String oabusyuserdept = (String) session.getValue("oabusyuserdept"); 
String oabusyuserlevel = (String) session.getValue("oabusyuserlevel"); 
if((oabusyusername==null)|(oabusyusername=="")){
response.sendRedirect("login.jsp"); 
}
%>
<%! 
String replacenull(String a){ 
	if(a==null){
return "&nbsp;"; 
	}else{
return a; 
	}
} 
%> 
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link rel="stylesheet" href="css/css.css">
<script language="javascript1.2" src="js/openwin.js"></script>
<title>人事管理系统</title>
</head>
<body bgcolor="#eeeeee" topmargin="5" leftmargin="5">
  <table border="0" cellpadding="0" cellspacing="0" width="100%">
    <tr>
      <td height=68>
        <table border="0" cellpadding="0" cellspacing="0" width="100%" height="68">
          <tr>
            
<center>
<table>
<tr>
<td>
<b>编辑<%=oabusyname%>的个人档案</b>&nbsp;&nbsp;
</td><form method="post" action="user.jsp">
<td>
<input type="submit" value="返回">
</td>

</form>
</tr>
</table>
</center>
</td>
            
          </tr>
        </table>
      </td>
    </tr>
    <tr>
      <td valign=top>
	  <%request.setCharacterEncoding("GB2312");
//打开数据库,读出个人档案
String sql="select * from scott.personinf where username='"+oabusyusername+"'"; 
ResultSet rs=stmt.executeQuery(sql); 
String inputdate;
String updatedate;
String havephoto;
String id;
if(rs.next())
{inputdate=rs.getString("inputdate");
inputdate=rs.getString("updatedate");
havephoto=rs.getString("havephoto");
id=rs.getString("id");
%>
        <table border="0" cellpadding="0" cellspacing="0" width="100%">
          <tr>
            
            <td valign=top height=280>


<center>
<br>
<form method="post"  action="editusersuccess.jsp">
<table border="0" cellpadding="0" cellspacing="0" width="95%">
  <tr>
    <td width="33%"><b>编号:</b><input type=text size=10 name=a1 value="<%=replacenull(rs.getString("A1"))%>"></td>
    <td width="33%"></td>
    <td align="right"></td>
  </tr>
</table>


<table>
<tr>
<td>
<%
if(inputdate==null){
%>

<%
	  }else{
%>
<input type="submit" name="submit" value="修改"> 
<%
}
%>
</td>
</form>
<form method="post" action="user.jsp"><td>
<input type="submit" name="submit" value="删除" onclick="return window.confirm('你确定要删除你的个人基本档案吗?');">
</td>
</form>
</table>
</center>
</td>
            
          </tr>
        </table>
		<%}else{%>
		<table border="0" cellpadding="0" cellspacing="0" width="100%">
          <tr>
            <td background="images/j4.gif" width=18 height=280></td>
            <td valign=top height=280>


<center>
<br>
<form method="post"  action="editusersuccess.jsp">
<table border="0" cellpadding="0" cellspacing="0" width="95%">
  <tr>
    <td width="33%"><b>编号:</b><input type=text size=10 name=a1 ></td>
    <td width="33%"></td>
    <td align="right"></td>
  </tr>
</table>

<table border="0" cellpadding="0" cellspacing="0" width="95%">
    <tr>
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-top: 2 solid #000000; border-bottom: 1 solid #000000" width="15%" height="20"><b>姓&nbsp;&nbsp;&nbsp;     
        名</b></td>          
      <td style="border-right: 1 solid #000000; border-top: 2 solid #000000; border-bottom: 1 solid #000000" width="35%"><%=oabusyname%></td>         
      <td align="center" style="border-right: 1 solid #000000; border-top: 2 solid #000000; border-bottom: 1 solid #000000" width="15%"><b>曾     
        用 名</b></td>         
      <td style="border-right: 2 solid #000000; border-top: 2 solid #000000; border-bottom: 1 solid #000000" width="35%"><input type=text size=10 name=a2 ></td>         
    </tr>         
    <tr>         
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000" height="20"><b>性&nbsp;&nbsp;&nbsp;     
        别</b></td>          
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><select name=a3 size=1><option value="男">男&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</option><option value="女">女</option></select></td>     
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>民&nbsp;&nbsp;&nbsp;     
        族</b></td>     
      <td style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><input type=text size=10 name=a4 ></td>     
    </tr>     
    <tr>     
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000" height="20"><b>所属部门</b></td>     
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><%=oabusyuserdept%></td>     
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>职&nbsp;&nbsp;&nbsp;     
        务</b></td>     
      <td style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><%=oabusyuserlevel%></td>     
    </tr>     
    <tr>     
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000" height="20"><b>学&nbsp;&nbsp;&nbsp;     
        历</b></td>     
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><input type=text size=10 name=a5 ></td>     
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>出生日期</b></td>     
      <td style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><input type=text size=10 name=a6 ></td>     
    </tr>     
    <tr>     
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000" height="20"><b>政治面貌</b></td>     
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><input type=text size=10 name=a7 ></td>     
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>健康状况</b></td>     
      <td style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><input type=text size=10 name=a8 ></td>     
    </tr>     
        
    <tr>          
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000" height="20"><b>身份证号码</b></td>          
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><input type=text size=10 name=a11 ></td>          
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>专&nbsp;&nbsp;&nbsp;     
        业</b></td>          
      <td style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><input type=text size=10 name=a12 ></td>          
    </tr>          
    
    <tr>         
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000" height="20"><b>外语语种</b></td>         
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><input type=text size=10 name=a19 ></td>         
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>外语水平</b></td>         
      <td style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><input type=text size=10 name=a20 ></td>         
    </tr>         
    
    <tr>         
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000" height="20"><b>计算机水平</b></td>         
      <td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><input type=text size=10 name=a23 ></td>         
      <td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>户口所在地</b></td>         
      <td style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><input type=text size=10 name=a24 ></td>         
    </tr>         
    <tr>         
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000" height="20"><b>现  住     
        址</b></td>         
      <td colspan="3" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000" width="85%"><input type=text size=50 name=a25 ></td>         
    </tr>         
     
    <tr>         
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000" height="20"><b>专长<br>         
        爱好</b></td>         
      <td colspan="3" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><textarea name=a27 rows="3" cols="49"></textarea></td>         
    </tr>         
    <tr>         
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000" height="20"><b>曾受<br>    
        过何种奖<br>    
        励和处分</b></td>         
      <td colspan="3" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><textarea name=a28 rows="3" cols="49"></textarea></td>         
    </tr>         
    <tr>         
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000" height="20"><b>工作经历</b></td>         
      <td colspan="3" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><textarea name=a29 rows="3" cols="49"></textarea></td>         
    </tr>         
      
    <tr>         
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000" height="20"><b>   <br>    
        联系方式</b></td>         
      <td colspan="3" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"><textarea name=a31 rows="3" cols="49"></textarea></td>         
    </tr>         
    
    <tr>          
      <td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 2 solid #000000" height="20"><b>备&nbsp;&nbsp;&nbsp;     
        注</b></td>         
      <td colspan="3" style="border-right: 2 solid #000000; border-bottom: 2 solid #000000"><textarea name=a33 rows="3" cols="49"></textarea></td>         
    </tr>         
   
  </table>
<table>
<tr>
<td>

<input type="submit" name="submit" value="修改">

</td>
</form>
<form method="post" action="user.jsp"><td>
<input type="submit" name="submit" value="删除" onclick="return window.confirm('你确定要删除你的个人基本档案吗?');">
</td>
</form>
</table>
</center>
</td>
            <td background="images/j5.gif" width=18 height=280></td>
          </tr>
        </table>
	
		<%}%>
    </tr>
    <tr>
      <td height=19>
        <table border="0" cellpadding="0" cellspacing="0" width="100%" height="19">
          
        </table>
      </td>
    </tr>
  </table>

</body>
</html>










⌨️ 快捷键说明

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