两个分页代码！（mysql mssql）

mssql:

<%@ page contentType="text/html; charset=gb2312" %>
2

<%@ page language="java" %>
3

<%@ page import="java.sql.*" %>
4

<jsp:useBean id="DBConn" scope="page" class="operation.conn.DBConn" />
5

<%
6

Connection Conn = DBConn.getConn() ;
7

Statement stmt = Conn.createStatement() ;
8

int i;
10

int ipage=25; //
11

int allpage; //`
12

int pages; //X锟�E
13

int cpage=1; //e
14

int spage; //}l
15

int allCol=0;
16

//��wsn
18

Connection conn=null;
19

java.lang.String sql,pagesql;
20

java.sql.ResultSet rs,pagers;
21

Statement statement=null;
22

pagesql = "SELECT COUNT(*) FROM info";
24

//`锟斤拷?
25

pagers = stmt.executeQuery(pagesql);
27

while(pagers.next())
28

{
29

allCol = pagers.getInt(1);
30

System.out.println(allCol);
31

}
32

//o`
34

allpage = (int)Math.ceil((allCol + ipage-1) / ipage);
35

//P_锟斤拷pagesO_
36

if (request.getParameter("pages")==null) {
37

pages=1;
38

} else {
39

pages = new Integer(request.getParameter("pages")).intValue();
40

System.out.println(pages);
41

}
42

//P_e
43

if(pages > allpage || pages == 0)
44

{cpage = 1;}
45

else
46

{
47

cpage = pages;
48

}
49

%>
50

<html>
52

<head>
53

<title>分页显示记录</title>
54

<!--
57

#frame-thin {border-collapse: collapse;}
58

.over { bgcolor: #ff0000}
59

.out { bgcolor: #ffffff}
60

.STYLE1 {color: #FFFFFF}
61

body {
62

margin-left: 3px;
63

margin-top: 10px;
64

margin-right: 3px;
65

margin-bottom: 3px;
66

}
67

body,td,th {
68

font-size: 12px;
69

}
70

-->
71

</style>
72

<body>
75

<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
76

<tr>
77

<td bgcolor="#E0E0E0"><table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" id="frame-thin">
78

<tr>
79

<td height="25" bgcolor="#004182" class="InternalHeader STYLE1"> ID</td>
80

<td bgcolor="#004182" class="InternalHeader STYLE1"> 客户名称</td>
81

<td bgcolor="#004182" class="InternalHeader STYLE1" > 车牌号</td>
82

<td bgcolor="#004182" class="InternalHeader STYLE1" > 车型</td>
83

<td bgcolor="#004182" class="InternalHeader STYLE1" > 消费时间</td>
84

<td bgcolor="#004182" class="InternalHeader STYLE1" > 消费项目</td>
85

<td bgcolor="#004182" class="InternalHeader STYLE1" > 消费金额</td>
86

<td bgcolor="#004182" class="InternalHeader STYLE1" > 消费店面</td>
87

<td bgcolor="#004182" class="InternalHeader STYLE1" > 消费接待</td>
88

<td bgcolor="#004182" class="InternalHeader STYLE1" > 派工号</td>
89

<td bgcolor="#004182" class="InternalHeader STYLE1" > 联系电话</td>
90

<td bgcolor="#004182" class="InternalHeader STYLE1" ><div align="center">操作</div></td>
91

</tr>
92

<%
93

sql = "select Top "+ipage+" * from info where ID not in (select top "+(cpage-1)*ipage+" ID from info order by ID desc)order by ID desc";
94

rs = stmt.executeQuery(sql);
95

while (rs.next())
96

{
97

%>
98

<a href="../CallBackOperator/View.jsp?ID=<%=rs.getString("ID")%>&&TempletID=""">
99

<tr onMouseOver="javascript:this.bgColor='#FFC06F'" onmouseout="javascript:this.bgColor='#E0E0E0'" onClick="checked();">
100

<td height="25"></td>
101

<td> <%=rs.getString("ClientName")%></td>
102

<td> <%=rs.getString("CarNo")%></td>
103

<td> <%=rs.getString("CarType")%></td>
104

<td> <%=rs.getString("ConsumeTime")%></td>
105

<td> <%=rs.getString("ConsumeItem")%></td>
106

<td> <%=rs.getString("ConsumeMoney")%></td>
107

<td> <%=rs.getString("ConsumeStore")%></td>
108

<td> <%=rs.getString("ConsumePeople")%></td>
109

<td> <%=rs.getString("ConsumePeopleNO")%></td>
110

<td> <%=rs.getString("Tel")%></td>
111

<form name="form1" method="post" action="../CallBackOperator/View.jsp?ID=<%=rs.getString("ID")%>">
112

<td><div align="center">
113

114

<input type="submit" name="Submit" value="回访">
115

修改删除
116

117

</div></td></form>
118

</tr>
119

</a>
120

<%
121

}
122

%>
123

</table></td>
124

</tr>
125

</table>
126

<br>
127

<table width="95%" border="1" align="center" cellspacing="0" bordercolor="#000000" id="frame-thin">
128

<tr>
129

<td> </td>
130

<td><div align="right"><%= allCol %> <%= allpage %>
131

<%
132

if (cpage>1) {
133

%>
134

<a href="MyJsp.jsp?pages=<%= cpage-1 %>"><img src="images/prev.gif" border="0"></a>
135

<% }
136

if (cpage<allpage) {
137

%>
138

<a href="MyJsp.jsp?pages=<%= cpage+1 %>"><img src="images/next.gif" border="0"></a>
139

<% } %>
140

/
141

<% for (i=1;i<=allpage;i++) {%>
142

<a href="MyJsp.jsp?pages=<%= i %>"> <%= i %></a> 
143

<% } %>
144

</div></td>
145

</tr>
146

</table>
147

<%
148

rs.close();
149

stmt.close();
150

Conn.close();
151

%>
152

</body>
153

</html>
154

155

MYSQL:

<%@ page contentType="text/html; charset=gb2312" %>

<%@ page language="java" %>

<%@ page import="java.sql.*" %>

<jsp:useBean id="DBConn" scope="page" class="operation.conn.DBConn" />

Connection Conn = DBConn.getConn() ;

Statement stmt = Conn.createStatement() ;

//每页显示记录数

int PageSize = 25;

int StartRow = 0; //开始显示记录的编号

int PageNo=0;//需要显示的页数

int CounterStart=0;//每页页码的初始值

int CounterEnd=0;//显示页码的最大值

int RecordCount=0;//总记录数;

int MaxPage=0;//总页数

int PrevStart=0;//前一页

int NextPage=0;//下一页

int LastRec=0;

int LastStartRecord=0;//最后一页开始显示记录的编号

//获取需要显示的页数，由用户提交

if(request.getParameter("PageNo")==null){ //如果为空，则表示第1页

if(StartRow == 0){

PageNo = StartRow + 1; //设定为1

}

}else{

PageNo = Integer.parseInt(request.getParameter("PageNo")); //获得用户提交的页数

StartRow = (PageNo - 1) * PageSize; //获得开始显示的记录编号

}

//因为显示页码的数量是动态变化的，假如总共有一百页，则不可能同时显示100个链接。而是根据当前的页数显示

//一定数量的页面链接

//设置显示页码的初始值!!

if(PageNo % PageSize == 0){

CounterStart = PageNo - (PageSize - 1);

}else{

CounterStart = PageNo - (PageNo % PageSize) + 1;

}

CounterEnd = CounterStart + (PageSize - 1);

<html>

<head>

<title>分页显示记录</title>

<!--

#frame-thin {border-collapse: collapse;}

.over { bgcolor: #ff0000}

.out { bgcolor: #ffffff}

.STYLE1 {color: #FFFFFF}

body {

margin-left: 3px;

margin-top: 10px;

margin-right: 3px;

margin-bottom: 3px;

}

body,td,th {

font-size: 12px;

}

-->

</style>

<body>

//获取总记录数

ResultSet rs = stmt.executeQuery("select count(*) from info" );

rs.next();

RecordCount = rs.getInt(1);

rs = stmt.executeQuery("SELECT * FROM info ORDER BY ID ASC LIMIT "

+StartRow+", "+PageSize);

//获取总页数

MaxPage = RecordCount % PageSize;

if(RecordCount % PageSize == 0){

MaxPage = RecordCount / PageSize;

}else{

MaxPage = RecordCount/PageSize+1;

}

<tr>

<tr>

</tr>

int i = 1;

while (rs.next()) {

int bil = i + (PageNo-1)*PageSize;

<a href="../CallBackOperator/View.jsp?ID=<%=rs.getString("ID")%>&&TempletID=""">

修改删除

</div></td></form>

</tr>

</a>

i++;

}%>

</table></td>

</tr>

</table>

<br>

<tr>

<td><%

out.print("<font size=4>");

//显示第一页或者前一页的链接

//如果当前页不是第1页，则显示第一页和前一页的链接

if(PageNo != 1){

PrevStart = PageNo - 1;

out.print("<a href=InfoList.jsp?PageNo=1>第一页 </a>: ");

out.print("<a href=InfoList.jsp?PageNo="+PrevStart+">前一页</a>");

}

out.print("[");

//打印需要显示的页码

for(int c=CounterStart;c<=CounterEnd;c++){

if(c <MaxPage){

if(c == PageNo){

if(c %PageSize == 0){

out.print(c);

}else{

out.print(c+" ,");

}

}else if(c % PageSize == 0){

out.print("<a href=InfoList.jsp?PageNo="+c+">"+c+"</a>");

}else{

out.print("<a href=InfoList.jsp?PageNo="+c+">"+c+"</a> ,");

}

}else{

if(PageNo == MaxPage){

out.print(c);

break;

}else{

out.print("<a href=InfoList.jsp?PageNo="+c+">"+c+"</a>");

break;

}

out.print("]");;

if(PageNo < MaxPage){ //如果当前页不是最后一页，则显示下一页链接

NextPage = PageNo + 1;

out.print("<a href=InfoList.jsp?PageNo="+NextPage+">下一页</a>");

}

//同时如果当前页不是最后一页，要显示最后一页的链接

if(PageNo < MaxPage){

LastRec = RecordCount % PageSize;

if(LastRec == 0){

LastStartRecord = RecordCount - PageSize;

}

else{

LastStartRecord = RecordCount - LastRec;

}

out.print(":");

out.print("<a href=InfoList.jsp?PageNo="+MaxPage+">最后一页</a>");

}

out.print("</font>");

%></td>

</tr>

</table>

rs.close();

stmt.close();

Conn.close();

</body>

</html>

posted on 2007-11-26 00:55 sooxin 阅读(396) 评论(0) 编辑收藏所属分类: JAVA

新用户注册刷新评论列表


只有注册用户登录后才能发表评论。




网站导航: 博客园博客园最新博文博问管理
相关文章: MyEclipse下设置合适的Content Assist快捷键使用POI生成Excel文件 POI读写Excel文件 Java字符串处理总结服务器系统时间不是24小时制时间，而是含有上午，下午等中文汉字，导致数图、tasi系统用户登录失败的问题之解决方法两个分页代码！（mysql mssql）两个整数相除得到小数（JAVA）有关于java的反斜杠"\" 使用POI来处理Excel和Word文件格式 Thinking:Java中static、this、super、final用法

sooxin-JAVA

My Links

Blog Stats

常用链接

留言簿(1)

随笔档案

文章分类

文章档案

搜索

最新评论

阅读排行榜

评论排行榜

两个分页代码！（mysql mssql）