servlet分页

采用servlet进行分页处理

Java代码

步骤：

1.创建SepPage类，并设置有关的方法。

2.在进行页面的转移时传递并当前的页面并传递参数。

3.进行分页处理。

a.计算总记录数

b.怎么样进行分页

c.首页显示处理

d.传递有关参数

e.获取有关传递的页面的参数

实例：以查询所有的用户信息为例子进行说明

packagebean;
/**********************分页类描述************************/
publicclassSepPage
{
privateintallRows;//一共有多少行记录
privateintcurPage=1;//当前页面
privateintrowPerPage=8;//一页显示多少行
privateintallPages;//一共有多少页
publicintgetAllRows()
{
returnallRows;
}
publicvoidsetAllRows(intallRows)
{
this.allRows=allRows;
}
publicintgetCurPage()
{
returncurPage;
}
publicvoidsetCurPage(intcurPage)
{
this.curPage=curPage;
}
publicintgetRowPerPage()
{
returnrowPerPage;
}
publicvoidsetRowPerPage(introwPerPage)
{
this.rowPerPage=rowPerPage;
}
publicintgetAllPages()
{
returnallPages;
}
publicvoidsetAllPages(intallPages)
{
this.allPages=allPages;
}
}


2.数据接收servlet
packageservlet;
importjava.io.IOException;
importjava.io.PrintWriter;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importbean.DBOperationBean;
importjava.util.*;
importutil.Convert;
importjava.sql.*;
importbean.*;
/**
*servlet类，获取有关客户的信息并进行相关的处理
*@authorqihuasun
*/
publicclassCustomerServletextendsHttpServlet
{
//查询所有sql语句
publicstaticfinalStringSELECTBYALL="select*fromSCOTT.EXRM_T_CUSTOMERorderbyCUM_FULLNAME";
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException
{
this.doPost(request,response);
}
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException
{
//处理有关中文乱码问题
request.setCharacterEncoding("GBK");
response.setContentType("text/html;charset=GBK");
response.setCharacterEncoding("GBK");
Stringstatus=request.getParameter("status").trim();//获取页面传递的标志位status
Stringpath="error.jsp";
if(!status.equals("")||status!=null)
{

if(status.equals("findall"))
{
DBOperationBeandb=newDBOperationBean();
Stringpage=request.getParameter("curpage");
try
{
intcurPage=Integer.parseInt(request.getParameter("curPage"));
//获取页面传递的参数
SepPagepa=newSepPage();
pa.setCurPage(curPage);
ArrayListal=db.query(this.SELECTBYALL,pa);
if(al!=null)
{
//path="main.jsp";
path="TestMain2.jsp";
request.setAttribute("all",al);
}
else
{
path="error.jsp";
}

}
catch(Exceptionex)
{
ex.printStackTrace();
}
}

}
request.getRequestDispatcher(path).forward(request,response);

}

}

4.数据访问类
packagebean;
importjava.sql.*;

importjavax.sql.*;
importjavax.xml.parsers.DocumentBuilder;
importjavax.xml.parsers.DocumentBuilderFactory;
importjavax.naming.*;
importorg.w3c.dom.Document;
importorg.w3c.dom.Element;
importorg.w3c.dom.NodeList;
importjava.util.*;
importbean.SepPage;
/**
*bean类，获取有关配置文件的信息的页面的信息，并进行有关的处理
*@authorqihuasun
*/
publicclassDBOperationBean
{
//驱动
privatefinalStringDBDRIVER="oracle.jdbc.driver.OracleDriver";
//数据库连接地址
privatefinalStringDBURL="jdbc:oracle:thin:@127.0.0.1:1521:data";
//数据库用户名
privatefinalStringDBUSER="SCOTT";
//数据库连接密码
privatefinalStringDBPASSWORD="sqh";
//声明一个数据库连接对象
privateConnectionconn=null;
privatePreparedStatementpstm=null;
privateResultSetrs=null;
publicDBOperationBean()
{
this.init();
}
privatevoidinit()//从数据库连接属性XML配置文件中获取关于连接的信息
{
conn=newDBConnection().getConnection();
}
privateConnectiongetConnection()//取得数据库连接并设置为当前连接
{
try
{
Class.forName(DBDRIVER);

conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);//连接数据库
System.out.println("connected");
}
catch(Exceptionex)
{
ex.printStackTrace();
}


returnthis.conn;
}

publicArrayListquery(Stringsql,SepPagepage)throwsException
{//执行查询，返回结果集
ArrayListal=newArrayList();
try
{
Connectionconn=this.getConnection();
pstm=conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs=pstm.executeQuery();
rs.last();//移动到最后一行
page.setAllRows(rs.getRow());//设置一共有多少行记录
//算出有多少页
if(page.getAllRows()%page.getRowPerPage()==0)
{
page.setAllPages(page.getAllRows()/page.getRowPerPage());
}
else
{
page.setAllPages(page.getAllRows()/page.getRowPerPage()+1);
}
//判定是否是第一页
if(page.getCurPage()==1)//当前页
{
//将指针移动到此ResultSet对象的开头,正好位于第一行之前
rs.beforeFirst();
}
else
{
//将指针移动到此ResultSet对象的给定行编号
rs.absolute((page.getCurPage()-1)*page.getRowPerPage());
}
inti=0;
while(rs.next()&&i<page.getRowPerPage())
{
Customercu=newCustomer();
cu.setId(rs.getInt("CUM_ID"));
cu.setName(rs.getString("CUM_FULLNAME"));
cu.setAddress(rs.getString("CUM_MAINADDRESS"));
cu.setPhone(rs.getString("CUM_PHONE"));
al.add(cu);
i++;
}
}
catch(Exceptionex)
{
ex.printStackTrace();
}
finally
{
try
{
if(conn!=null)
{
this.conn.close();
}
}
catch(Exceptionex)
{
ex.printStackTrace();
}
}
returnal;
}
}

4、页面显示
<%@pagelanguage="java"contentType="text/html;charset=GBK"%>
<%@pageimport="java.util.*,bean.SepPage"%>
<%@pageimport="bean.Customer;"%>

<%
ArrayListall=(ArrayList)request.getAttribute("all");
SepPageseppage=(SepPage)request.getAttribute("pagebean");
//获取设置的SepPage参数
%>
<!DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<htmlxmlns="http://www.w3.org/1999/xhtml">
<head>
<title>客户管理</title>
<linkhref="css/style.css"rel="stylesheet"/>
</head>
<body>
<divclass="top">
『作者管理』
</div>
<divclass="center">
<formaction="AuthorServlet?status=selectbylike&curPage=1"method="post"style="margin:0;">
<tableclass="fine"cellpadding="0"cellspacing="0">
<tr>
<tdcolspan="3"style="height:40px;">

</td>
</tr>
<tr>
<td>
序号
</td>
<td>
客户名称
</td>
<td>
联系电话
</td>
<td>
地址
</td>
&nbsp;&nbsp;&nbsp;&nbsp;<td>
操作
</td>
</tr>
<%
inti=0;
if(all!=null&&all.size()!=0)
{
for(intj=0;j<all.size();j++)
{
i++;
Customercus=(Customer)all.get(j);
intauthorId1=cus.getId();
Stringstr="找不到记录！！！";
if(i==0)
{


out.println("<scrtipt>alert('找不到记录')<script>");
}
else
{%>

<tr>
<td>

<%=i%>
</td>
<td>

<%=cus.getName()%>
</td>
<td>
<%=cus.getPhone()%>
</td>
<td>
<%=cus.getAddress()%>
</td>
<td>
<td><ahref="CustomerServlet?status=selectbyid&id=<%=cus.getId()%>">更新</a>&nbsp;&nbsp;&nbsp;&nbsp;</td>&nbsp;&nbsp;

<td><ahref="CustomerServlet?status=delete&id=<%=cus.getId()%>"onclick="if(confirm('是否删除业务信息?')){returntrue;}else{returnfalse;}">删除</a>&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td><ahref="addCus.jsp">添加</a></td>
</tr>

<%}%>

<%
}//endfor循环
}//endifall!=null
%>
<%
if(seppage!=null){
%>
<tr>
<tdcolspan="3"
style="height:32px;text-align:right;font-weight:bold;padding-right:10px;">
<fontcolor="#FF5BAD">一共有&nbsp;<fontcolor="red"><%=seppage.getAllPages()%></font>&nbsp;页&nbsp;&nbsp;当前在第&nbsp;<font
color="red"><%=seppage.getCurPage()%></font>&nbsp;页&nbsp;&nbsp;&nbsp;&nbsp;</font>
<%
if(seppage.getCurPage()!=1)//不是第一页，则首页，上一页可用
{
%>
<ahref="CustomerServlet?status=selectbyall&curPage=1">首页</a>&nbsp;&nbsp;
<a
href="CustomerServlet?status=selectbyall&curPage=<%=seppage.getCurPage()-1%>">上一页</a>
<%
}
%>
&nbsp;&nbsp;
<%
if(seppage.getCurPage()!=seppage.getAllPages())//不是最后一页，则有下一页和末页
{
%>
<a
href="CustomerServlet?status=selectbyall&curPage=<%=seppage.getCurPage()+1%>">下一页</a>&nbsp;&nbsp;
<a
href="CustomerServlet?status=selectbyall&curPage=<%=seppage.getAllPages()%>">末
页</a>
<%
}
%>

</td>
</tr>
<%
}
%>
</table>
</form>
<formaction="CustomerServlet?status=selectbylike&curPage=1"method="post"style="margin:0;">
<tableclass="fine"cellpadding="0"cellspacing="0">
<tr>
<tdcolspan="3"style="height:40px;">
<selectstyle="height:20px"name="sel">
<optionselectedvalue="由客户姓名">
由客户姓名
</option>
<optionvalue="由地址">
由地址
</option>
</select>
&nbsp;&nbsp;
<inputtype="text"name="in"style="width:200px"/><inputtype="submit"value="查找"/>
</td>
</tr>
</table>
</form>
</div>
</body>