📄 showstbytdm.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/connect.asp" -->
<%
bt=cstr(request("byear")&"-"&request("bm")&"-"&request("bd"))
tt=cstr(request("tyear")&"-"&request("tm")&"-"&request("td"))
%>
<%
Set rsbm = Server.CreateObject("ADODB.Recordset")
con=MM_connect_STRING
sql= "SELECT * FROM baoming WHERE baomingshijian between #"&bt&"# and #"&tt&"# ORDER BY jiangzuoid ASC"
rsbm.Open sql,con,1,1
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#6699CC">
<table width="607" border="0" cellspacing="1" bgcolor="#000000">
<tr bgcolor="#666699">
<td colspan="4"><font color="#FFCC00" size="2">从<%= bt %>到<%= tt %>已经有<%= rsbm.recordcount %>位学报名参加学习</font></td>
</tr>
<tr bgcolor="#6699CC">
<td width="19%" height="22"><font color="#FFCC00" size="2">学号</font></td>
<td width="19%"><font color="#FFCC00" size="2">课程号</font></td>
<td width="18%"><font color="#FFCC00" size="2">报名时间</font></td>
<td width="44%"><font color="#FFCC00" size="2">接待雇员号</font></td>
</tr>
<% while not rsbm.eof %>
<tr bgcolor="#66aadd">
<td><%= rsbm("baomingid") %></td>
<td><%= rsbm("jiangzuoid") %></td>
<td><%= rsbm("baomingshijian") %></td>
<td><%= rsbm("guyuanid") %></td>
</tr>
<%
rsbm.movenext
wend
%>
</table>
</body>
</html>
<%
rsbm.Close()
Set rsbm = Nothing
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -