Jsp分页全部代码.docx
- 文档编号:11078590
- 上传时间:2023-02-24
- 格式:DOCX
- 页数:8
- 大小:16.35KB
Jsp分页全部代码.docx
《Jsp分页全部代码.docx》由会员分享,可在线阅读,更多相关《Jsp分页全部代码.docx(8页珍藏版)》请在冰豆网上搜索。
Jsp分页全部代码
下面是写的一个邮件系统页面的分页,数据库可以根据情况改动,已经测试过,仅供参考!
1.UserMail.java
packagecom.softeem.user;
publicclassUserMail{
privateintid;
//发件人
privateStringsender;
//收件人
privateStringrecipients;
//主题
privateStringtitle;
//内容
privateStringcontents;
//时间
privateStringtimes;
//附件
privateStringupload;
//邮件大小
privateintsizes;
//邮件类型:
1为新邮件,2为收件箱,3为草稿箱,4为发件箱,5为垃圾箱
privateinttypes;
//状态:
1为已读,0为未读
privateintstatus;
publicintgetId(){
returnid;
}
publicvoidsetId(intid){
this.id=id;
}
publicStringgetSender(){
returnsender;
}
publicvoidsetSender(Stringsender){
this.sender=sender;
}
publicStringgetRecipients(){
returnrecipients;
}
publicvoidsetRecipients(Stringrecipients){
this.recipients=recipients;
}
publicStringgetTitle(){
returntitle;
}
publicvoidsetTitle(Stringtitle){
this.title=title;
}
publicStringgetContents(){
returncontents;
}
publicvoidsetContents(Stringcontents){
this.contents=contents;
}
publicStringgetTimes(){
returntimes;
}
publicvoidsetTimes(Stringtimes){
this.times=times;
}
publicStringgetUpload(){
returnupload;
}
publicvoidsetUpload(Stringupload){
this.upload=upload;
}
publicintgetSizes(){
returnsizes;
}
publicvoidsetSizes(intsizes){
this.sizes=sizes;
}
publicintgetTypes(){
returntypes;
}
publicvoidsetTypes(inttypes){
this.types=types;
}
publicintgetStatus(){
returnstatus;
}
publicvoidsetStatus(intstatus){
this.status=status;
}
}
2.UserDAO.java
/**
*查询收件箱中所有数据,分页显示
*@return
*/
publicList
List
Connectionconn=DBManager.getConnection();
//types为状态,表示收件箱
Stringsql="selecttop10*fromusersmailwheretypes='2'and(idnotin(selecttop(10*(?
-1))idfromusersmailwheretypes='2'))";
try{
PreparedStatementpst=conn.prepareStatement(sql);
pst.setInt(1,count);
ResultSetrs=pst.executeQuery();
while(rs.next()){
UserMailuser=newUserMail();
intid=rs.getInt("id");
intstatus=rs.getInt("status");
Stringupload=rs.getString("upload");
Stringsender=rs.getString("sender");
Stringtitle=rs.getString("title");
Stringtimes=rs.getString("times");
intsizes=rs.getInt("sizes");
user.setId(id);
user.setStatus(status);
user.setUpload(upload);
user.setSender(sender);
user.setTitle(title);
user.setTimes(times);
user.setSizes(sizes);
list.add(user);
}
}catch(SQLExceptione){
e.printStackTrace();
}
returnlist;
}
3.ListUserServlet.java
/**
*新建一个servlet,由jsp跳转到servlet,用于分页
*/
packagecom.softeem.servlet;
importjava.io.IOException;
importjava.util.List;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importcom.softeem.dao.UserDAO;
importcom.softeem.user.Count;
importcom.softeem.user.UserMail;
/**
*ServletimplementationclassListUserServlet
*/
publicclassListUserServletextendsHttpServlet{
privatestaticfinallongserialVersionUID=1L;
/**
*@seeHttpServlet#HttpServlet()
*/
publicListUserServlet(){
super();
//TODOAuto-generatedconstructorstub
}
/**
*@seeHttpServlet#doGet(HttpServletRequestrequest,HttpServletResponseresponse)
*/
protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{
//传状态types的值得到收件箱邮件总数
UserDAOdao=newUserDAO();
Countc=dao.getCount
(2);
//拿到收件箱邮件总数
intt=c.getCount();
//每页显示10条,r为最后一页条数
intr=t%10;
System.out.println("最后一页条数"+r);
//拿到当前页
Stringpagesize=request.getParameter("pagesize");
List
//定义页数
intpageNumber;
if(t/10==0){
pageNumber=t/10;
}else{
//最后一页
pageNumber=t/10+1;
}
//将list,pageNumber存放到request中
request.setAttribute("list",list);
request.setAttribute("pageNumber",pageNumber);
request.getRequestDispatcher("list.jsp").forward(request,response);
}
/**
*@seeHttpServlet#doPost(HttpServletRequestrequest,HttpServletResponseresponse)
*/
protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{
//TODOAuto-generatedmethodstub
super.doPost(request,response);
}
}
4.将如下代码加入到jsp页面末尾
forEachbegin="1"end="${pageNumber}"var="current"> pagesize=${current}"> outvalue="${current}"/> forEach> 页
注意:
在加链接的时候要令ListUserServlet?
pagesize=1,点击后直接显示第一页.
Jsp页面用到了c标签,所以要在jsp页面顶部导入,
<%@tagliburi="prefix="c"%>
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Jsp 分页 全部 代码