求MySQL与Oracle的分页项目实例

我不会写分页的代码,也没有任何资料可参考,分页功能应该有上一页,下一页,跳转到某页,返回到刚才那一页,每页显示 N 条数据等功能吧.马上要去找工作了,分页还不会写,急啊,麻烦各位高手给个案例发到我邮箱: [email protected]小女子不胜感激!!

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

LZ  你参考一下我写的分页（oracle数据库）；自定义标签（基于Struts的）通用的...
http://blog.csdn.net/Jerry_BJ/archive/2010/06/02/5642447.aspx
<%@ page language="java" contentType="text/html; charset=gbk"
pageEncoding="gbk"%>
<%@page import="java.sql.*"%>
<%
int pageNum,startNum,pageSize,total,totalPage;
pageSize=4;
String pageStr=request.getParameter("pageNum");
new com.mysql.jdbc.Driver();
Connection conn = DriverManager
.getConnection("jdbc:mysql://localhost/bbs?user=root&password=tiger");
Statement stmt = conn.createStatement();
ResultSet rs=stmt.executeQuery("select count(*) from emp");
rs.next();
total=rs.getInt(1);
totalPage=total%pageSize==0?total/pageSize:(total/pageSize+1);
if(pageStr==null||"".equals(pageStr)){
pageNum=1;
startNum=0;
}else{
pageNum=Integer.parseInt(pageStr);
if(pageNum<1){
pageNum=1;
}else if(pageNum>totalPage){
pageNum=totalPage;
}
startNum=(pageNum-1)*pageSize;
}
rs= stmt.executeQuery("select * from emp limit "+startNum+","+pageSize);
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Insert title here</title>
</head>
<body>
<center>
<h1>员工信息表</h1>
<table border="1">
<tr><td>员工编号</td><td>姓名</td><td>工作种类</td><td>上司编号</td><td>入职时间</td><td>薪资</td><td>分公司编号</td><td>部门编号</td></tr>
<%
while (rs.next()) {
%>
<tr><td><%=rs.getInt(1)%></td><td><%=rs.getString(2)%></td><td><%=rs.getString(3)%></td><td><%=rs.getInt(4)%></td><td><%=rs.getDate(5)%></td><td><%=rs.getInt(6)%></td><td><%=rs.getInt(7)%></td><td><%=rs.getInt(8)%></td></tr>
<%
}
rs.close();
stmt.close();
conn.close();
%>
</table>
共<%=totalPage %>页，这是第<%=pageNum %>页
<a href="mysqlfenye.jsp">第一页</a>
<a href="mysqlfenye.jsp?pageNum=<%=pageNum-1%>">上一页</a>
<a href="mysqlfenye.jsp?pageNum=<%=pageNum+1%>">下一页</a>
<a href="mysqlfenye.jsp?pageNum=<%=totalPage%>">最后一页</a>
</center>
</body>
</html>MYSQL
<%@ page language="java" contentType="text/html; charset=gbk"
pageEncoding="gbk"%>
<%@page import="java.sql.*"%>
<%
int pageNum,startNum,pageSize,total,totalPage,lastNum;
pageSize=4;
String pageStr=request.getParameter("pageNum");
new oracle.jdbc.driver.OracleDriver();
Connection conn = DriverManager
.getConnection("jdbc:oracle:thin:@localhost:1521:XE","scott","tiger");
Statement stmt = conn.createStatement();
ResultSet rs=stmt.executeQuery("select count(*) from emp2");
rs.next();
total=rs.getInt(1);
totalPage=total%pageSize==0?total/pageSize:(total/pageSize+1);
if(pageStr==null||"".equals(pageStr)){
pageNum=1;
startNum=1;
lastNum=startNum+pageSize-1;
}else{
pageNum=Integer.parseInt(pageStr);
if(pageNum<1){
pageNum=1;
}else if(pageNum>totalPage){
pageNum=totalPage;
}
startNum=(pageNum-1)*pageSize+1;
lastNum=startNum+pageSize-1;
}
rs=stmt.executeQuery("select * from (select A.*,rownum rn from (select * from emp2) A where rownum<="+lastNum+") where rn>="+startNum);
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Insert title here</title>
</head>
<body>
<center>
<h1>员工信息表</h1>
<table border="1">
<tr><td>员工编号</td><td>姓名</td><td>工作种类</td><td>上司编号</td><td>入职时间</td><td>薪资</td><td>分公司编号</td><td>部门编号</td></tr>
<%
while (rs.next()) {
%>
<tr><td><%=rs.getInt(1)%></td><td><%=rs.getString(2)%></td><td><%=rs.getString(3)%></td><td><%=rs.getInt(4)%></td><td><%=rs.getDate(5)%></td><td><%=rs.getInt(6)%></td><td><%=rs.getInt(7)%></td><td><%=rs.getInt(8)%></td></tr>
<%
}
rs.close();
stmt.close();
conn.close();
%>
</table>
共<%=totalPage %>页，这是第<%=pageNum %>页
<a href="oraclefenye.jsp">第一页</a>
<a href="oraclefenye.jsp?pageNum=<%=pageNum-1%>">上一页</a>
<a href="oraclefenye.jsp?pageNum=<%=pageNum+1%>">下一页</a>
<a href="oraclefenye.jsp?pageNum=<%=totalPage%>">最后一页</a>
</center>
</body>
</html>Oracle
5楼的,能发我一个么?SSH框架用这个很多的.特别是当关系型数据库不确定的时候,通用型分页代码就很重要.看到我留言发一个到我的邮箱好么? 或者加我QQ聊: 179657283  谢谢.