📄 user.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 allow_edit_person_personinf;
String sql1="select * from scott.userinf where username='"+oabusyusername+"'";
ResultSet rs=stmt.executeQuery(sql1);
if(rs.next())
{
allow_edit_person_personinf=rs.getString("allow_edit_person_personinf");
}else{
allow_edit_person_personinf="";
}
%>
<%!
String replacenull(String a){
if(a==null){
return " ";
}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">
<%String adminvalue="yes";
if(adminvalue.equals(allow_edit_person_personinf)){
%>
<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>
<center>
<b><%=oabusyname%>的个人档案管理</b>
</td>
</center>
</tr>
</table>
</td>
</tr>
<tr>
<td valign=top>
<%request.setCharacterEncoding("GB2312");
String submit1="删除";
if(submit1.equals(request.getParameter("submit"))){
stmt.executeUpdate("delete from scott.personinf where username='"+oabusyusername+"'");
}
//打开数据库，读出个人档案
String sql="select * from scott.personinf where username='"+oabusyusername+"'";
rs=stmt.executeQuery(sql);
String inputdate;
String updatedate;
String havephoto;
String id;
if(rs.next())
{inputdate=rs.getString("inputdate");
updatedate=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>
<table>
<tr>
<td>
<b><%=oabusyname%>的个人基本档案</b>
</td>
<%if(adminvalue.equals(allow_edit_person_personinf)){
%>
<form method="post" action="edituser.jsp"><td>
<input type="submit" value="编辑">
</td>
</form>
<form method="post" action="user.jsp"><td>
<input type="submit" name="submit" value="删除" onclick="return window.confirm('你确定要删除你的个人基本档案吗？');">
</td>
</form>
<%
}
%>
</tr>
</table>
<br>
</center>
</td>
<td background="images/j5.gif" width=18 height=280></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>
<table border="0" cellpadding="0" cellspacing="0" width="95%">
<tr>
<td width="30%"><b>编号：000</b></td>
<td width="35%"><b>录入时间：</b></td>
<td align="right"><b>修改时间：</b></td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="95%">
<tr>
<td width="15%" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-top: 2 solid #000000; border-bottom: 1 solid #000000"><b>姓 名</b></td>
<td width="35%" style="border-right: 1 solid #000000; border-top: 2 solid #000000; border-bottom: 1 solid #000000"><%=oabusyname%></td>
<td width="15%" align="center" style="border-right: 1 solid #000000; border-top: 2 solid #000000; border-bottom: 1 solid #000000"><b>曾 用 名</b></td>
<td width="100%" style="border-right: 1 solid #000000; border-top: 2 solid #000000; border-bottom: 1 solid #000000"> </td>
<td width="80" height="100" rowspan="5" align="center" valign=center style="border-right: 2 solid #000000; border-top: 2 solid #000000; border-bottom: 1 solid #000000">
<table width=80>
<tr>
<td align=center>
无<br>照<br>片
</td>
</tr></table>
</td>
</tr>
<tr>
<td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>性 别</b></td>
<td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"> </td>
<td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>民 族</b></td>
<td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"> </td>
</tr>
<tr>
<td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><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>职 务</b></td>
<td style="border-right: 1 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"><b>学 历</b></td>
<td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"> </td>
<td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>出生日期</b></td>
<td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"> </td>
</tr>
<tr>
<td align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>政治面貌</b></td>
<td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"> </td>
<td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>健康状况</b></td>
<td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"> </td>
</tr>
<tr>
<td align="center" width="15%" height="20" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>籍 贯</b></td>
<td width="35%" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"> </td>
<td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>毕业院校</b></td>
<td width="35%" colspan="2" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"> </td>
</tr>
<tr>
<td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>身份证号</b></td>
<td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"> </td>
<td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>专 业</b></td>
<td colspan="2" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"> </td>
</tr>
<tr>
<td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>外语语种</b></td>
<td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"> </td>
<td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>外语水平</b></td>
<td colspan="2" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"> </td>
</tr>
<tr>
<td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>计算机水平</b></td>
<td style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"> </td>
<td align="center" style="border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>户口所在</b></td>
<td colspan="2" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"> </td>
</tr>
<td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>现 住 址</b></td>
<td colspan="4" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"> </td>
</tr>
<tr>
<td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>特长<br>
爱好</b></td>
<td colspan="4" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"> </td>
</tr>
<tr>
<td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>曾受<br>过何种奖<br>励和处分</b></td>
<td colspan="4" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"> </td>
</tr>
<tr>
<td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>工作经历</b></td>
<td colspan="4" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"> </td>
</tr>
<tr>
<td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 1 solid #000000"><b>联系方式</b></td>
<td colspan="4" style="border-right: 2 solid #000000; border-bottom: 1 solid #000000"> </td>
</tr>
<tr>
<td height="20" align="center" style="border-left: 2 solid #000000; border-right: 1 solid #000000; border-bottom: 2 solid #000000"><b>备 注</b></td>
<td colspan="4" style="border-right: 2 solid #000000; border-bottom: 2 solid #000000"> </td>
</tr>
</table>
<table>
<tr>
<%if(adminvalue.equals(allow_edit_person_personinf)){
%>
<form method="post" action="edituser.jsp"><td>
<input type="submit" value="编辑">
</td>
</form>
<form method="post" action="user.jsp"><td>
<input type="submit" name="submit" value="删除" onclick="return window.confirm('你确定要删除你的个人基本档案吗？');">
</td>
</form>
<%
}
%>
</tr>
</table>
<br>
</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">
<tr>
</tr>
</table>
</td>
</tr>
</table>
<%
}
%>
<center>
<tr>
<A href="system.jsp">返回</A>
</tr>
</center>
<%@ include file="foot.jsp"%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -