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)