1
2、查询分页---一般的,不用存储过程
2![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
mypage=request.form("currpage")'得到需要显示第几页
4
'mypage为空则说明此页是第一次加载
5
if mypage="" then
6
mypage=1
7
end if
8
dim myDb
9
set myDb=new ConDb
10
with myDb
11
.tbName="comEmploy" '表名
12
.pKey="empId" '主键
13
.pgFields="empId,empGz" '显示的字段
14
.pgSize=20 '每页显示的条数
15
.conditions="" '查询的条件
16
.orderBy="empId desc" '排序的条件
17
.currPg=mypage
18
end with
19
dim rs
20
set rs=myDb.pageRs()
21
'根据返回的rs写表现代码
22
myDb.cRs(rs)
23
'在适当的地方放放置分页导航
24
<%=myDb.pageNav()%>
25
set myDb=nothing
26
3、查询分页---用存储过程
27![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
28
此处的存储我用的叶子分页类用的存储过程,可在网上查找叶子分页类的相关代码
29![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
30
mypage=request.form("currpage")'得到需要显示第几页
31
'mypage为空则说明此页是第一次加载
32
if mypage="" then
33
ypage=1
34
end if
35
dim myDb
36
set myDb=new ConDb
37
with myDb
38
.tbName="comEmploy" '表名
39
.pKey="empId" '主键
40
.pgSize=2 '每页显示的条数
41
.pgFields="empId,empGz" '显示的字段
42
.conditions="" '查询的条件
43
.orderBy="empId desc" '排序的条件
44
.currPg=mypage
45
end with
46
dim rs
47
set rs=myDb.sqlPage()
48
'根据返回的rs写表现代码
49
'若查询条件是根据form提交,查询条件可保存在cookie中
50
myDb.cRs(rs)
51
'在适当的地方放放置分页导航
52
<%=myDb.pageNav()%>
53
set myDb=nothing
54
4、若你的分页显示没有什么特别的表现形式,还可以直接输入有分页导航的table
55![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
56
tbTil=Array("作者|200","IP地址|150","发布时间|150","具体内容|300")
57
'作者是表格的第一个字段的名称
58
'200是此单元格的宽度
59
mypage=request.QueryString("currpage")'得到需要显示第几页
60
'mypage为空则说明此页是第一次加载
61
if mypage="" then
62
mypage=1
63
end if
64
dim myDb:set myDb=new dbClass
65
with myDb
66
.tbName="guestBook" '表名
67
.pKey="id" '主键
68
.pgFields="mem_Author,mem_PostIP,mem_PostTime,mem_Content" '显示的字段
69
.pgSize=3 '每页显示的条数
70
.conditions="" '查询的条件
71
.orderBy="id desc" '排序的条件
72
.currPg=mypage
73
end with
74
myDb.showTb(tbTil)
75
set myDb=nothing
76
5、返回总记录数可以用myDb.vRsCount() 返回总页数可以用myDb.vPgCount()
77![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
78
6、myDb.prnSql()打印sql语句,在出现错误时利用此检查sql语句
79![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
80
下面是用到的样式代码,可作相应修改
81![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
82
程序代码:
83![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
84
table{
85
border-collapse:collapse;
86
font-size:12px;
87
}
88
td{
89
border:1px solid #FFCC99;
90
border-collapse:collapse;
91
height:30px;
92
text-align:center;
93
}
94
#fy{
95
/*width:545px;*/
96
margin-left:350px;
97
}
98
#fy span,#fy a{
99
display:block;
100
float:left;
101
height:15px;
102
}
103
#fy #rpc{
104
margin-left:20px;
105
line-height:20px;
106
}
107
#fy a{
108
border:1px solid #CCCCFF;
109
width:15px;
110
text-decoration:none;
111
margin-left:5px;
112
color:#993300;
113
cursor:pointer;
114
}
115
#fy a.aW{
116
width:40px;
117
color:#000000;
118
border:none;
119
line-height:20px;
120
}
121
#fy a:hover{
122
color:#125da7;
123
/*border:1px solid #F8b3d0;
124
background-color:#F8b3d0;*/
125
}
126
#fy a#currP{
127
color:#125da7;
128
border:1px solid #FF0000;
129
background-color:#FF0000;
130
/*border:1px solid #F8b3d0;
131
background-color:#fff5fa;*/
132
}
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
18
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
19
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
20
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
21
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
22
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
23
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
24
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
25
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
26
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
27
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
28
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
29
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
30
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
31
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
32
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
33
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
34
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
35
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
36
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
37
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
38
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
39
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
40
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
41
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
42
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
43
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
44
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
45
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
46
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
47
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
48
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
49
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
50
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
51
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
52
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
53
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
54
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
55
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
56
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
57
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
58
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
59
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
60
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
61
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
62
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
63
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
64
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
65
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
66
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
67
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
68
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
69
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
70
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
71
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
72
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
73
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
74
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
75
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
76
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
77
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
78
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
79
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
80
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
81
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
82
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
83
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
84
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
85
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
86
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
87
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
88
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
89
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
90
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
91
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
92
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
93
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
94
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
95
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
96
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
97
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
98
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
99
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
100
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
101
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
102
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
103
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
104
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
105
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
106
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
107
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
108
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
109
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
110
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
111
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
112
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
113
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
114
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
115
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
116
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
117
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
118
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
119
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
120
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
121
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
122
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
123
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
124
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
125
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
126
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
127
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
128
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
129
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
130
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
131
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
132
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)