📄 studentadquery.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<%
if session("sNumber")="" then
response.write "<script>alert('对不起，您没有登陆，请先登陆后在访问。');document.location.href='index.asp';</script>"
response.end
end if
%>
<!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>
<link rel="stylesheet" href="admin/style.css">
<%
sNumber=trim(session("sNumber"))
set rs=server.createobject("adodb.recordset")
sql="select * from jiangcheng where user_number = '"&sNumber&"'"
rs.open sql,conn,1,1
%>
</head>
<body>
<!--#include file="top.asp"-->
<form method="POST" action="" name="frm">
<div align="center">
<p>
<table border="1" width="600" cellspacing="0" cellpadding="5" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr>
<td width="100%" colspan="6">
<p align="center">详细查询结果</p>
</td>
</tr><%
if not rs.eof then
%>
<tr>
<td width="20%" align="center">学号</td>
<td width="10%" align="center">姓名</td>
<td width="30%" align="center">奖惩原因</td>
<td width="20%" align="center">时间</td>
<td width="10%" align="center">状况</td>
<td width="10%" align="center">学分</td>
</tr>
<%do while not rs.eof%>
<tr>
<td width="20%" align="center"><%=rs("user_number")%></td>
<td width="10%" align="center"><%=rs("user_name")%></td>
<td width="30%" align="center"><%=rs("yuanying")%></td>
<td width="20%" align="center"><%=rs("time")%></td>
<%if rs("zk")=1 then%>
<td width="50" align="center">奖励</td>
<%elseif rs("zk")=0 then%>
<td width="50" align="center">惩罚</td>
<%else%>
<td width="50" align="center"></td>
<%end if%>
<td width="10%" align="center"><%=abs(rs("user_xuefen"))%></td>
</tr>
<%rs.movenext%>
<%loop%>
<%else%>
<tr>
<td width="100%" colspan="5"><marquee>没有您所查找的学生</marquee></td>
</tr>
<%end if%>
</table>
</div>
<%
rs.close
set rs=nothing
%>
<p>
</form>
<!--#include file="down.asp"-->
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -