小弟我的access数据库查询结果需要分页显示，但是执行结果没有显示，怎么实现，多谢！
日期：2014-05-17 浏览次数：20880 次
我的access数据库查询结果需要分页显示，但是执行结果没有显示，请教高手如何实现，谢谢！！
<!--#include file= "conn.asp "-->
<% jino=trim(request.form( "jino "))
teachername=trim(request.form( "teachername "))
exec= "select * from 课程 where jino= ' "+jino+ " ' and teachername= ' "+teachername+ " ' "
set rs=server.createobject( "adodb.recordset ")
rs.open exec,conn,1,1
if rs.eof then
response.write "请重新查询 "
response.end
end if
rs.PageSize=10 '##设置一个页码里面显示的记录数
pagecount=rs.PageCount '##pagecount是记录的个数
page=int(request.QueryString ( "page "))
if page <=0 then page=1
if request.QueryString( "page ")= " " then '##当前页为 page页
page=1
end if
rs.AbsolutePage=page
%>
<html>
<head>
<title> 查询结果 </title>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<script language= "JavaScript ">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName== "Netscape ")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW ¦ ¦ innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
</head>
<body background= "images/bg1.jpg " bgcolor= "#FFFFFF " text= "#000000 " >
<div align= "center ">
<p> <font color= "#660033 "> <font size= "4 " color=
<!--#include file= "conn.asp "-->
<% jino=trim(request.form( "jino "))
teachername=trim(request.form( "teachername "))
exec= "select * from 课程 where jino= ' "+jino+ " ' and teachername= ' "+teachername+ " ' "
set rs=server.createobject( "adodb.recordset ")
rs.open exec,conn,1,1
if rs.eof then
response.write "请重新查询 "
response.end
end if
rs.PageSize=10 '##设置一个页码里面显示的记录数
pagecount=rs.PageCount '##pagecount是记录的个数
page=int(request.QueryString ( "page "))
if page <=0 then page=1
if request.QueryString( "page ")= " " then '##当前页为 page页
page=1
end if
rs.AbsolutePage=page
%>
<html>
<head>
<title> 查询结果 </title>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<script language= "JavaScript ">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName== "Netscape ")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW ¦ ¦ innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
</head>
<body background= "images/bg1.jpg " bgcolor= "#FFFFFF " text= "#000000 " >
<div align= "center ">
<p> <font color= "#660033 "> <font size= "4 " color=
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
