📄 xt_user_display.jsp
字号:
<%@ page contentType="text/html; charset=GBK"
import="javax.naming.*,java.sql.*,java.util.*,javax.sql.DataSource,java.io.*" %>
<html>
<head>
<title>ZD-OA</title>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="Cache-Control" content="no-cache, must-revalidate">
<meta http-equiv="expires" content="wed, 26 Feb 1997 08:21:57 GMT"><link rel="stylesheet" href="../../images/style.css" type="text/css">
</head>
<BODY text=black vLink=#333333 aLink=#336699 link=#000000 bgColor=#dddddd>
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0
valign="Top">
<TBODY>
<TR>
<TD>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD width=25 background=../../images/topleft.gif height=45><IMG
height=45 src="../../images/blank.gif" width=25></TD>
<TD vAlign=center align=left width="100%"
background=../../images/topback.gif>
<TABLE cellSpacing=2 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD colSpan=2 height=2></TD></TR>
<TR>
<TD noWrap align=left
background=""> <B>待办公文</B></TD>
<TD align=right><A
onmouseover="window.status='显示帮助'; return true;"
onclick="window.open('../user/help_index.cfm?ContentID=0','help','width=600,height=400');"
onmouseout="window.status=''; return true;"
href="#"><IMG
height=16 alt=帮助 src="../../images/help2.gif" width=16
border=0></A> </TD></TR>
<TR>
<TD noWrap align=left background=""
colSpan=2> </TD></TR></TBODY></TABLE></TD>
<TD vAlign=top align=middle width=27
background=../../images/topright.gif height=45>
<TABLE cellSpacing=0 cellPadding=0 background="" border=0>
<TBODY>
<TR>
<TD><IMG height=6 src="../../images/blank.gif" width=27
border=0></TD></TR>
<TR>
<TD align=middle>
</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD width=15 background=../../images/left.gif><IMG
src="../../images/blank.gif" width=15></TD>
<TD class=content> </TD>
<TD class=content vAlign=top align=middle width="100%">
<%
String username=(String)session.getValue("originalusername");
Connection connection=null;
try{
String dataSourceName="zdsoft";
Context initialContext=null;
Hashtable env=new Hashtable();
initialContext=new javax.naming.InitialContext(env);
DataSource dataSource=(DataSource)initialContext.lookup(dataSourceName);
connection=dataSource.getConnection();
}catch(SQLException e){out.println("连接数据库失败");}
Statement statement=connection.createStatement();
ResultSet columns=statement.executeQuery(
"SELECT * FROM xt_user WHERE userid='"+username+"'"); //等待由session装载，由客户端传来的用户名和登陆密码
while(columns.next()){
String d1=columns.getString("userid"); //用户名
String d2=columns.getString("usercopy");//用户别名
String d3=columns.getString("passwd"); //登陆密码
String d4=columns.getString("gwpassword"); //公文处理密码
String d5=columns.getString("email"); //邮箱地址
String d6=columns.getString("yjpassword");// 邮件密码
String d7=columns.getString("lxcall"); //联系方式
String d8=columns.getString("zwwork"); //职务
String d9=columns.getString("deptid"); //部门
String d10=columns.getString("typeid"); //角色
String d11=columns.getString("memo"); // 备注
%>
<table id=t1 width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td align="center" class="borderon">个人详细资料显示</td>
</tr>
</table>
<div style="position:relative; width:100%; height:expression(body.offsetHeight-t1.offsetHeight-2); z-index:1; left: 0px; top: 0px; overflow: auto">
<table width="100%" border="0" style="height:expression(body.offsetHeight-t1.offsetHeight-2);" cellspacing="1" cellpadding="3" bgcolor="#666666" align="center">
<tr bgcolor="#FFFFFF">
<td width="20%" bgcolor="#999999"><font color="#E8E8E8">用户名 </font></td>
<td width="80%" bgcolor="#F7F7F7"><%=d1%> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="20%" bgcolor="#999999"><font color="#E8E8E8">用户别名</font></td>
<td width="80%" bgcolor="#F7F7F7"> <%=d2%> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="20%" bgcolor="#999999"><font color="#E8E8E8">登陆密码</font></td>
<td width="80%" bgcolor="#F7F7F7"> <%=d3%></a>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="20%" bgcolor="#999999"><font color="#E8E8E8">公文处理密码</font></td>
<td width="80%" bgcolor="#F7F7F7"> <%=d4%> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="20%" bgcolor="#999999"><font color="#E8E8E8">邮箱 地址 </font></td>
<td width="80%" bgcolor="#F7F7F7"><a href='mailto:test@fdg.com'> <%=d5%> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="20%" bgcolor="#999999"><font color="#E8E8E8">邮件密码</font></td>
<td width="80%" bgcolor="#F7F7F7"> <%=d6%> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="20%" bgcolor="#999999"><font color="#E8E8E8">联系方式</font></td>
<td width="80%" bgcolor="#F7F7F7"> <%=d7%> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="20%" bgcolor="#999999"><font color="#E8E8E8">职 务</font></td>
<td width="80%" bgcolor="#F7F7F7"> <%=d8%> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="20%" bgcolor="#999999"><font color="#E8E8E8">部 门</font></td>
<td width="80%" bgcolor="#F7F7F7"> <%=d9%> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="20%" bgcolor="#999999"><font color="#E8E8E8">角 色</font></td>
<td width="80%" bgcolor="#F7F7F7"> <%=d10%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="20%" bgcolor="#999999"><font color="#E8E8E8">备 注</font></td>
<td width="80%" bgcolor="#F7F7F7"> <%=d11%></td>
</tr>
</table>
</div>
<% }
connection.close();
%>
<TABLE width="100%">
<TBODY>
<TR>
<TD height=4></TD></TR></TBODY></TABLE></TD>
<TD class=content> </TD>
<TD width=15 background=../../images/right.gif><IMG
src="../../images/blank.gif" width=15></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD width=25 background=../../images/bottomleft.gif height=25><IMG
height=25 src="../../images/blank.gif" width=25></TD>
<TD width="100%" background=../../images/bottomback.gif
height=10><IMG height=25 src="../../images/blank.gif" width=10></TD>
<TD width=27 background=../../images/bottomright.gif height=25><IMG
height=25 src="../../images/blank.gif"
width=27></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -