📄 student3.asp

📁 职业培训学校学生档案成绩费用管理系统V1.0免费版.rar
💻 ASP
字号:
<!--#include file="conn.asp"-->
<%
if session("user")="" then
	response.write "您无此权限"
	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="style.css">
</head>

<body>
<!--#include file="top.asp"--><p>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from feiyong where user_time =date() order by id desc"
rs.open sql,conn,1,1

NoncePage=0
NumRecord=0
NumPage=0
if Not(rs.bof and rs.eof) then'判别数据表中是否为空记录
	NumRecord=rs.recordcount
	rs.pagesize=14
	NumPage=rs.Pagecount
	if request("page")=empty then 
		NoncePage=1
	elseif Cint(request("page"))<1 then
		NoncePage=1
	else
		NoncePage=request("page")
		if Cint(request("page"))>Cint(NumPage) then 
			NoncePage=NumPage
		end if
	end if
end if	
%>
<div align="center">
<table border="1" width="350" bordercolorlight="#000000" cellspacing="0" cellpadding="5" bordercolordark="#FFFFFF">
	<tr>
	<td width="19%">学号</td>
	<td width="23%">姓名</td>
	<td width="25%">类型</td>
	<td width="33%">金额</td>
	</tr>	
<%	
if not rs.eof then
	rs.move (Cint(NoncePage)-1)*14,1
	for i=1 to rs.pagesize
%>
	<tr>
	<td width="19%"><%=rs("user_number")%></td>
	<td width="23%"><%=rs("user_name")%></td>
	<%  'a href=xuefeiQuery.asp?id=<%=rs("id")&user_type=2>%>
	<td width="25%"><%=rs("user_type")%></td>
	<td width="33%"><%=rs("money")%></td>
	</tr>
<%
	rs.movenext
	if rs.eof then 
		exit for
	end if
	next
else
%>
	<tr>
	<td width="50%" colspan="4"><marquee>暂无情况</marquee></td>
	</tr>
<%end if%>
</table><p>
</div>
<%
rs.close
set rs=nothing
%>
<div align="center"> 
<input type="hidden" name="page" value="<%=NoncePage%>">
<%
if NoncePage>1 then
	response.write "|<a href=student3.asp?page=1>首 页</a>| |<a href=student3.asp?page="&NoncePage-1&">上一页</a>|&nbsp"
else
	response.write "|首 页| |上一页|&nbsp"
end if
if Cint(Trim(NoncePage))<Cint(Trim(NumPage)) then
	response.write "|<a href=student3.asp?page="&NoncePage+1&">下一页</a>| |<a href=student3.asp?page="&NumPage&">尾 页</a>|"
else
	response.write "|下一页| |尾 页|"
end if
%>
&nbsp;页次：<font color="#0033CC"><%=NoncePage%></font>/<font color="#0033CC"><%=NumPage%></font> 
共<font color="#0033CC"><%=NumRecord%></font>条记录&nbsp; 
</div>                        
 <p> <!--#include file="down.asp"-->							
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -