📄 yuangon1.asp
字号:
<!--#include file="conn.asp"-->
<%
response.buffer=true
Response.Expires=0
id=request.querystring("id")
exec="select * from worker where id=" &id
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,3,3
%>
<html>
<head>
<link href="../../AppMain.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>丽水市公铁联运有限公司员信息</title>
</head>
<body>
<table width="100%" cellpadding="0" cellspacing="0" >
<tr>
<td width="3%" height="20"> <div align="center"><img src="../../image/T_left.gif" width="26" height="20"></div></td>
<td width="87%" background="../../image/T_bg.gif"><div align="center"><font color="#66FF00">员工详细信息</font></div></td>
<td width="10%"><img src="../../image/T_right.gif" width="75" height="20"></td>
</tr>
</table>
<table width="271" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#ffffff" bordercolordark="#000000" class="TOOLBARTABLE">
<tr class="TOOLBARTABLE" onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td width="96"><font color="#FF0000"> 员工编号:</font></td>
<td width="159"><%=rs("number")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td><font color="#FF0000"> 姓 名:</font></td>
<td><%=rs("username")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td><font color="#FF0000"> 性 别:</font></td>
<td><%= rs("sex") %> </td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td><font color="#FF0000"> 所属组织:</font></td>
<td><%=rs("zhuzhi")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td height="22"><font color="#FF0000"> 职 务:</font></td>
<td><%=rs("task")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td><font color="#FF0000"> 出生日期:</font></td>
<td><%=rs("born_date")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td><font color="#FF0000"> 在职状态:</font></td>
<td><%=rs("work")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td><font color="#FF0000"> 手机号码: </font></td>
<td><%=rs("cellphone")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td width="106"><font color="#FF0000"> 办公电话:</font></td>
<td width="133" bordercolorlight="#FFFFFF" bordercolordark="#000000"><%=rs("office_tel")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td><font color="#FF0000"> 家庭电话:</font></td>
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><%=rs("home_tel")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td><font color="#FF0000"> 电子信箱:</font></td>
<td bordercolordark="#000000" border&ncolorlight="#FFFFFF"><%=rs("email")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td><font color="#FF0000"> 身 份 证:</font></td>
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><%=rs("body")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td><font color="#FF0000"> 婚姻状况:</font></td>
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><%= rs("marry") %></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><font color="#FF0000"> 籍
贯:</font></td>
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><%=rs("addrress")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><font color="#FF0000"> 学
历:</font></td>
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><%= rs("study") %> </td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><font color="#FF0000"> 毕业学校:</font></td>
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><%=rs("school")%> </td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><font color="#FF0000"> 专
业:</font></td>
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><%=rs("major")%> </td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><font color="#FF0000"> 毕业时间:</font></td>
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><%=rs("left_date")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><font color="#FF0000"> 工作时间:</font></td>
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><%=rs("work_date")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><font color="#FF0000"> 注册时间:</font></td>
<td bordercolorlight="#FFFFFF" bordercolordark="#000000"><%=rs("zhuche_date")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td height="18"><font color="#FF0000"> 家庭住址:</font></td>
<td height="18"><%=rs("address")%></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#d1f4ae';" onmouseout="this.style.backgroundColor='#f1f1f1';">
<td height="18"> </td>
<td height="18"> </td>
</tr>
</table>
<% rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -