jsp实现oracle分页查询,详细的jsp分页（oracle+jsp+apache）

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection conn=DriverManager.getConnection(sConn,"你的用户名","密码");

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

Statement stmtcount=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

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

String sqlcount="select count(*) from mytable_view";

http://www.gaodaima.com/?p=44742详细的jsp分页(oracle+jsp+apache)

ResultSet rscount=stmtcount.executeQuery(sqlcount);

int pageSize=你的每页显示纪录数；

int rowCount=0; //总的记录数

while (rscount

int pageCount; //总的页数

int currPage; //当前页数

String strPage;

strPage=request.getParameter("page");

if (strPage==null){

currPage=1;

}

else{

currPage=Integer.parseInt(strPage);

if (currPage<1) currPage=1;

}

pageCount=(rowCount+pageSize-1)/pageSize;

if (currPage>pageCount) currPage=pageCount;

int thepage=(currPage-1)*pageSize;

int n=0;

rs.absolute(thepage+1);

while (n

%>

rscount.close();

stmt.close();

stmtcount.close();

conn.close();

%>

//下面是 第几页等

第页 共页 共条

1){%>首页

1){%>上一页

下一页

1){%>尾页

跳到页