javaee分页，在servlet中使用js，实现分页的页面跳转
分页代码：
package com.ru.view;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class usermanage extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(“text/html;charset=utf-8″);
PrintWriter out = response.getWriter();
out.println(“<script type=’text/javascript’>”);
out.println(“function gotoPageNow(){” +
“var pagenow1=document.getElementByIdx_x(‘paganow’).value;” +
“window.location.replace(‘/usermanager/usermanage?pageNow=’+pagenow1);}”
);
out.println(“</script>”);
out.println(“<img width=180px height=89px src=’images/0005.gif’/><font size=’30px’ text-align=center>欢迎”+1+”登录</font><br/>”);
out.println(“<br/><a href=’/usermanager/mainframe’>返回主界面</a>”);
out.println(“<a href=’/usermanager/login’>退出登陆</a><br>”);
out.println(“用户管理界面”);
//oracle数据库操作
Connection ct=null;
PreparedStatement ps=null;
ResultSet rs=null;
//分页定义变量
int rowCount=1;//总条数
int pageSize=3;//每页记录数
int pageCount=1;//总页数
int pageNow=1;//当前页
//得到当前页
String sPageNow=request.getParameter(“pageNow”);
if(sPageNow!=null){
}
try {
//加载驱动
Class.forName(“oracle.jdbc.driver.OracleDriver”);
//连接数据库
ct=DriverManager.getConnection(“jdbc:oracle:thin:@127.0.0.1:1521:orcl”,”userm”,”123456″);
//计算总共有多少页
ps=ct.prepareStatement(“select count(*) from users”);
rs=ps.executeQuery();
rs.next();//因为rs开始的时候会指向结果记得上一个地址，随意先要把游标下一一个地址。
rowCount=rs.getInt(1);
if (rowCount%pageSize==0) {
pageCount=rowCount/pageSize;
} else {
pageCount=rowCount/pageSize+1;
}
//预编译sql语句
ps=ct.prepareStatement(“select * from (select t.*,rownum rn from (select * from users order by id) t where rownum<=”+pageSize*pageNow+”) where rn>=”+(pageSize*(pageNow-1)+1));
//执行
rs=ps.executeQuery();
//操作
out.println(“<table border=1 width=500px>”);
out.println(“<tr><th>帐号</th><th>用户名</th><th>邮箱</th><th>级别</th></tr>”);
while (rs.next()) {
out.println(“<tr><td>”+rs.getString(1)+”</td><td>”+rs.getString(2)+”</td><td>”+rs.getString(3)+”</td><td>”+rs.getString(4)+”</td></tr>”);
}
out.println(“</table><br/>”);
//上一页
if(pageNow!=1){
out.println(“<a href=’/usermanager/usermanage?pageNow=”+(pageNow-1)+”‘>上一页</a>”);
}
//显示分页
for(int i=1;i<=pageCount;i++){
out.println(“<a href=’/usermanager/usermanage?pageNow=”+i+”‘><”+i+”></a>”);
}
//下一页
if (pageNow!=pageCount) {
out.println(“<a href=’/usermanager/usermanage?pageNow=”+(pageNow+1)+”‘>下一页</a>”);
}
//当前页总页数
out.println(“<a>当前第 ”+pageNow+” 页</a><a>共 ”+pageCount+” 页</a><br/><br/>”);
//页面跳转
out.println(“跳转到<input type=’text’ id=’paganow’ name=’pagenow’>页<input type=’button’ onclick=’gotoPageNow()’ value=’提交’>”);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}finally{
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else{
rs=null;
}
if(ps!=null){
try {
ps.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else{
ps=null;
}
if(ct!=null){
try {
ct.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else{
ct=null;
}
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doGet(request, response);
}
}