📄 userinfo.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %><%@ include file="check.jsp" %>
<%
if(String.valueOf(session.getAttribute("Urule")).compareTo("a")!=0){
response.sendRedirect ("error.jsp?id=admin");
}
%>
<script language=javascript src="mouse.js"></script>
<%
String sql ="select * from myuser where ID="+request.getParameter("id");
sqlbean.executeQuery(sql);
if(sqlbean.next()){
%>
<link rel="stylesheet" href="oa.css">
<body bgcolor="#FFFFFF" topmargin="0" leftmargin="0" style="background-image: url('images/main_bg.gif'); background-attachment: scroll; background-repeat: no-repeat; background-position: left bottom">
<table border="1" cellpadding="0" cellspacing="0" width="100%" bordercolorlight=#000000 bordercolordark=#ffffff align=right>
<tr>
<td colspan=5 align=center><FONT COLOR="blue">
该用户共登陆系统<FONT COLOR="red"><%=sqlbean.getString("times")%></FONT>次，最后一次登陆时间是:<FONT COLOR="red">
<%=sqlbean.getString("Utime")%></FONT>、登陆IP:<FONT COLOR="red"><%=sqlbean.getString("logIP")%></FONT></FONT>
</td>
</tr>
<%
}
sql ="select * from userinfo where userid="+request.getParameter("id");
sqlbean.executeQuery(sql);
if(sqlbean.next()){
%>
<tr>
<td align="center" width="15%"><b>姓 名</b></td>
<td width="30%"> <%=session.getAttribute("Uname")%></td>
<td align="center" width="15%"><b>曾 用 名</b></td>
<td width="25%"> <%=sqlbean.getString("Uname")%></td>
<td width="80" height="100" rowspan="5" align="center" valign=center>
<%if (sqlbean.getString("havephoto").compareTo("0")==0){%>
无<BR>照<BR>片
<%}else{%>
<img src="<%=sqlbean.getString("photo")%>" width="80" height="100" border="0">
<%}%>
</td>
</tr>
<tr>
<td align="center"><b>性 别</b></td>
<td> <%=sqlbean.getString("sex")%></td>
</td>
<td align="center"><b>民 族</b></td>
<td> <%=sqlbean.getString("nation")%></td>
</tr>
<tr>
<td align="center"><b>所属部门</b></td>
<td> <%=session.getAttribute("Upart")%></td>
<td align="center"><b>职 务</b></td>
<td> <%=sqlbean.getString("duty")%></td>
</tr>
<tr>
<td align="center"><b>职 称</b></td>
<td> <%=sqlbean.getString("grade")%></td>
<td align="center"><b>出生日期</b></td>
<td> <%=sqlbean.getString("birthday")%></td>
</tr>
<tr>
<td align="center"><b>政治面貌</b></td>
<td> <%=sqlbean.getString("polity")%></td>
<td align="center"><b>健康状况</b></td>
<td> <%=sqlbean.getString("health")%></td>
</tr>
<tr>
<td align="center" height="20"><b>籍 贯</b></td>
<td> <%=sqlbean.getString("Nplace")%></td>
<td align="center"><b>体 重</b></td>
<td colspan="2"> <%=sqlbean.getString("weight")%></td>
</tr>
<tr>
<td height="20" align="center"><b>身份证号</b></td>
<td> <%=sqlbean.getString("idcard")%></td>
<td align="center"><b>身 高</b></td>
<td colspan="2"> <%=sqlbean.getString("height")%></td>
</tr>
<tr>
<td align="center" height="20"><b>婚姻状况</b></td>
<td> <%=sqlbean.getString("marriage")%></td>
<td align="center"><b>毕业院校</b></td>
<td colspan="2"> <%=sqlbean.getString("Fschool")%></td>
</tr>
<tr>
<td align="center" height="20"><b>本人成分</b></td>
<td> <%=sqlbean.getString("member")%></td>
<td align="center"><b>专 业</b></td>
<td colspan="2"> <%=sqlbean.getString("speciality")%></td>
</tr>
<tr>
<td height="20" align="center"><b>工 龄</b></td>
<td> <%=sqlbean.getString("length")%></td>
<td align="center"><b>学 历</b></td>
<td colspan="2"> <%=sqlbean.getString("study")%></td>
</tr>
<tr>
<td height="20" align="center"><b>外语语种</b></td>
<td> <%=sqlbean.getString("foreign1")%></td>
<td align="center"><b>外语水平</b></td>
<td colspan="2"> <%=sqlbean.getString("Clevel")%></td>
</tr>
<tr>
<td height="20" align="center"><b>记算机能力</b></td>
<td> <%=sqlbean.getString("Clevel")%></td>
<td align="center"><b>户口所在地</b></td>
<td colspan="2"> <%=sqlbean.getString("Hplace")%></td>
</tr>
<tr>
<td height="20" align="center"><b>QQ号码</b></td>
<td> <%=sqlbean.getString("QQ")%></td>
<td align="center"><b>EMAIL</b></td>
<td colspan="2"> <%=sqlbean.getString("email")%></td>
</tr>
<tr>
<td height="20" align="center"><b>常用电话</b></td>
<td> <%=sqlbean.getString("phone")%></td>
<td align="center"><b>手机号码</b></td>
<td colspan="2"> <%=sqlbean.getString("mobile")%></td>
</tr>
<tr>
<td height="20" align="center"> <b>传呼号码</b> </td>
<td> <%=sqlbean.getString("call")%></td>
<td align="center"><b>现 住 址</b></td>
<td colspan="2"><%=sqlbean.getString("place")%></td>
</tr>
<tr>
<td height="20" align="center"><b>专长及爱好</b></td>
<td > <%=sqlbean.getString("love")%></td>
<td align="center"><b>联系方式</b></td>
<td colspan="2"> <%=sqlbean.getString("contact")%></td>
</tr>
<tr>
<td height="20" align="center"><b>受过何奖<br>
励和处分</b></td>
<td colspan="4"> <%=sqlbean.getString("award")%></td>
</tr>
<tr>
<td height="20" align="center"><b>工作经历</b></td>
<td colspan="4"> <%=sqlbean.getString("experience")%></td>
</tr>
<tr>
<td height="20" align="center"><b>家庭情况</b></td>
<td colspan="4"> <%=sqlbean.getString("family")%></td>
</tr>
<tr>
<td height="20" align="center"><b>备 注</b></td>
<td colspan="4"> <%=sqlbean.getString("remark")%></td>
</tr>
</table>
<%
}
sqlbean.close();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -