oracle单变分页,Oracle 简单分页

OraclePaging.java

package cn.nevo.service;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class OraclePaging {

//JDBC方式实现oracle连接

final String driver = "oracle.jdbc.driver.OracleDriver";

final String url = "jdbc:oracle:thin:@localhost:1521:orcl";

final String user = "scott";

final String pwd = "tiger";

Connection conn = new JdbcOdbcConnection(driver).getConnection(url, user, pwd);

Statement st = null;

ResultSet rs = null;

//获得结果集并返回

public ResultSet oraclePage(String strsql) {

try {

st = conn.createStatement();

rs = st.executeQuery(strsql);

} catch (SQLException e) {

e.printStackTrace();

}

return rs;

}

//关闭数据库资源

public void closeAll() {

try {

rs.close();

st.close();

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

index.jsp

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

查询scott方案下emp表实现分页

实现oracle分页

姓名	入职日期

//接收点击连接时候的pageNow

String s_pageNow = (String)request.getParameter("pageNow");

int pageNow = 1;

if(!"".equals(s_pageNow)&&s_pageNow != null){

pageNow = Integer.parseInt(s_pageNow);

}

ResultSet rs = null;

//总记录数查询语句

String strsql2 = "select count(*) from emp";

int rowcount = 5; //每页显示的记录数

int recordCount = 0; //总共的记录数

int pagecount = 0; //总共显示的页数

rs = (oraclePaging.oraclePage(strsql2));

if(rs.next()) {

recordCount = rs.getInt(1);

if(recordCount % rowcount == 0) {

pagecount = recordCount / rowcount;

}else {

pagecount = recordCount / rowcount + 1;

}

}

//分页查询sql语句

String strsql = "select * from (select e.*, rownum rn from (select * from emp) e where rownum <= " + rowcount * pageNow + ") where rn >=" + ((pageNow -1) * (rowcount) + 1);

rs = oraclePaging.oraclePage(strsql);

while(rs.next()) {

out.println("

");

out.println("

" + rs.getString(2) + "");

out.println("

" + rs.getDate(5) + "");

out.println("

");

}

%>

//页数的链接

for(int i=1; i<=pagecount; i++) {

out.print("[" + i + "]");

}

oraclePaging.closeAll();

%>