<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page language="java" import="java.sql.Connection,java.sql.Statement,java.sql.ResultSet" %>
<jsp:directive.page import="java.sql.DriverManager;"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body>
<%
Connection con=null;
//加载 Oracle jdbc thin 驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver");
//Oracle thin jdbc URL
String url="jdbc:oracle:thin:@192.168.10.2:1521:ora10";
con = DriverManager.getConnection(url,"TRSPORTALV6","TRSPORTALV6");
Statement stmt=con.createStatement();
String sql="select count(*) from WCMMETATABLEXWLW_ZZH ";
ResultSet rs=stmt.executeQuery(sql);
int jumpPage=1;//跳转页
int pageNum=1;//当前页
int pageSize=3;//每页大小
int countPage=0;//总页数
int countRecord=0;//总记录数
//总记录数
if(rs.next()){
countRecord=rs.getInt(1);
}
//总页数
if(countRecord % pageSize == 0){
countPage = countRecord / pageSize;
}else{
countPage = countRecord/pageSize+1;
}
String strPage=request.getParameter("pageNum");
String strjump=request.getParameter("jumpPage");
if(strPage==null){
pageNum=1;//如果没有则显示第一页
}else{
pageNum=Integer.parseInt(strPage);
if(pageNum<1){
pageNum=1;
}
}
//对跳转页进行判断
if(strjump!=null){
pageNum=Integer.parseInt(strjump);
if(pageNum<1){
pageNum=1;
}
if(pageNum>countPage){
pageNum=countPage;
}
}
int startPage=(pageNum-1)*pageSize+1;
int endPage=(pageNum)*pageSize;
//这SQL语句很重要,基本上用了ORACLE的rownum来实现分页的。
sql="select * from (select t.*,rownum r from WCMMETATABLEXWLW_ZZH t) where r between "+startPage+" and "+endPage+"";
rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<table>
<tr><td><%=rs.getString("CRUSER")%></td><td><%=rs.getString("CRTIME")%></td></tr>
</table>
<%}%>
<table>
<form name="name" action="test.jsp">
<tr>
<td>总共有<%=countRecord%>条记录</td>
<td>第<a href="test.jsp?pageNum=<%=pageNum%>"><%=pageNum%></a>页</td>
<td>总<%=countPage%>页</a></td>
<td><a href="test.jsp?pageNum=0">首页</a></td>
<td><%if(pageNum>1){%><a href="test.jsp?pageNum=<%=pageNum-1%>">上页</a><%}%></td>
<td><%if(pageNum<countPage){%><a href="test.jsp?pageNum=<%=pageNum+1%>">下页</a><%}%></td>
<td><a href="test.jsp?pageNum=<%=countPage%>">尾页</a></td>
<td>转到<input type="text" name="jumpPage" style="width: 15px">页<input type="submit" value="跳转" ></td>
</tr>
</form>
</table>
</body>
</html>