📄 userdetail.jsp
字号:
<%@ page language="java" import="java.util.*"%>
<%@ page import="java.sql.*,java.util.*,java.io.*" %>
<%@ include file="conn.jsp"%>
<%@ include file="util.jsp"%>
<%@ include file="sso.jsp"%>
<%
String id=(String)request.getParameter("id");
if(id==null){
id="";
}
String sql="select * from txl_view where id = '"+id+"'";
java.sql.ResultSet rs = st.executeQuery(sql);
rs.next();
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<style>
body {
margin-top: 0px;
margin-bottom: 0px;
}
</style>
</head>
<body text="#000000" bgcolor="#FFFFFF">
<form action="">
<div style="background-color:#E0F2FF"><a href="#" onClick="javascript:window.close();"><img border="0" src="images/gb.bmp"/></a><%if(manage){%><a href="updateuser.jsp?id=<%=id%>"><img border="0" src="images/bj.bmp"/></a><%}%></div>
<BR>
<br>
<p>
<table width="100%" border="1">
<tr valign="top"><td width="100%" bgcolor="#2181FF" colspan="3"><div align="center"><b><font size="4" color="#FFFFFF" face="宋体">人 员 信 息</font></b><BR></div></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">姓</font><font size="2" color="#FFFFFF" face="宋体">----</font><font size="2" face="宋体">名：</font></div></td><td width="84%" colspan="2"><font size="2" face="宋体"><%=rs.getString("NAME")%></font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">人员编号：</font></div></td><td width="84%" colspan="2"><font size="2" face="宋体"><%=NullToBlank(rs.getString("CODE"))%> </font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">公司名称：</font></div></td><td width="84%" colspan="2"><font size="2" face="宋体"><%=NullToBlank(rs.getString("COMPANY_NAME"))%> </font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">所属处室：</font></div></td><td width="42%" valign="middle"><font size="2" face="宋体"><%=NullToBlank(rs.getString("UNIT_NAME"))%> </font><font size="2" color="#FFFFFF" face="宋体">.</font></td><td width="42%"><img src="/icons/ecblank.gif" border="0" height="1" width="1" alt=""></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">所属部门：</font></div></td><td width="42%" valign="middle"><font size="2" face="宋体"><%=NullToBlank(rs.getString("DEPART_NAME"))%> </font><font size="2" color="#FFFFFF" face="宋体">.</font></td><td width="42%"><img src="/icons/ecblank.gif" border="0" height="1" width="1" alt=""></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">职</font><font size="2" color="#FFFFFF" face="宋体">----</font><font size="2" face="宋体">务：</font></div></td><td width="84%" colspan="2"><font size="2" face="宋体"><%=NullToBlank(rs.getString("POST"))%> </font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%"><div align="center"><font size="2" face="宋体">房 间 号：</font></div></td><td width="84%" colspan="2"><font size="2" face="宋体"> </font><font size="2" face="宋体"><%=NullToBlank(rs.getString("ROOMID"))%> </font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">区</font><font size="2" color="#FFFFFF" face="宋体">----</font><font size="2" face="宋体">号：</font></div></td><td width="84%" colspan="2"><font size="2" face="宋体"><%=NullToBlank(rs.getString("CITYID"))%> </font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">办公电话：</font></div></td><td width="84%" colspan="2"><font size="2" face="宋体"><%=NullToBlank(rs.getString("PHONE"))%> </font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">分机号码：</font></div></td><td width="84%" colspan="2"><font size="2" face="宋体"><%=NullToBlank(rs.getString("EXTENSION"))%> </font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">移动电话：</font></div></td><td width="84%" colspan="2"><font size="2" face="宋体"><%=NullToBlank(rs.getString("MOBILE"))%> </font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%"><div align="center"><font size="2" face="宋体">TD测试号码：</font></div></td><td width="42%"><font size="2" face="宋体"><%=NullToBlank(rs.getString("TDNO"))%> </font></td><td width="42%"><img src="/icons/ecblank.gif" border="0" height="1" width="1" alt=""></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">邮件地址：</font></div></td><td width="42%" valign="middle"><font size="2" face="宋体"><%=NullToBlank(rs.getString("EMAIL"))%> </font><font size="2" color="#FFFFFF" face="宋体"></font></td><td width="42%"><img src="/icons/ecblank.gif" border="0" height="1" width="1" alt=""></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">传真电话：</font></div></td><td width="84%" colspan="2"><font size="2" face="宋体"></font><font size="2" color="#FFFFFF" face="宋体"><%=NullToBlank(rs.getString("FAX"))%> </font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">邮政编码：</font></div></td><td width="84%" colspan="2"><font size="2" face="宋体"><%=NullToBlank(rs.getString("ZIP"))%> </font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">通信地址：</font></div></td><td width="84%" colspan="2"><font size="2" face="宋体"><%=NullToBlank(rs.getString("ADDRESS"))%> </font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">备</font><font size="2" color="#FFFFFF" face="宋体">----</font><font size="2" face="宋体">注：</font></div></td><td width="84%" colspan="2">
<ul>
<ul>
<ul>
<ul><font size="2" color="#FFFFFF" face="宋体"><%=NullToBlank(rs.getString("REMARK"))%> </font></ul>
</ul>
</ul>
</ul>
</td></tr>
</table>
</form>
</body>
</html>
<%
rs.close();
st.close();
con.close();
%> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -