jsp+servlet分页

上传者: a695165987 | 上传时间: 2019-12-21 18:44:26 | 文件大小: 625KB | 文件类型: rar
页面的上下两个表单可以封装成一个jsp组件.实现代码的重用 具体实现流程如下: 客户端的jsp页面传送两个变量: 1. Keyword:要查询的关键字 2. currentPage:当前要显示第几页 servelt中通过调用impl类的方法返回如下内容: 1. ArrayList对象:里面存储的是对应的页的数据 2. 原样返回currentPage,单击”next”则在此基础之上++;存在(hidden中) 3. 原样返回Keyword,下次单击按钮的时候在重新把keyword传过去存在(hidden中) 4. 返回根据要搜索的内容,和每页要显示的数量,计算要显示的总页数存在(hidden中) 按钮的翻页效果通过js实现下面是next按钮实现代码: window.open("/splitpage/SplitServelt?currentPage=" + (page+1) +"&keyword=" + keyword,"_self"); 真分页要注意如下问题: 1. PreparedStatement 的"?"功能 只能充当where 条件后面的占位符不能和top一起使用 2. 所以在实现分页的时候用了Statement + 连接变量的方式完成 3. 分页代码如下:select top 5 * from person where id >(select max(id) from person where id in (select top ((3-1)*5) id from person where name like '刘%')) 分析如下: 代码1: select top ((3-1)*5) id from person where name like '刘%' 把前2页数据的id全部找出来 查询和”刘”相关的女儿,(3-1)*5 代表要显示的是第3页.每页显示5行数据 代码2: select max(id) from person where id in(select top ((3-1)*5) id from person where name like '刘%' ) 重刚刚查询到的id里面选出最大值 代码3: select top 5 * from person where id >(select max(id) from person where id in (select top ((3-1)*5) id from person where name like '刘%')) 要显示5条记录.记录数的id 必须大于已经找出来的id(前两页的id)

文件下载

资源详情

[{"title":"( 37 个子文件 625KB ) jsp+servlet分页","children":[{"title":"MVC真分页.doc <span style='color:#111;'> 30.50KB </span>","children":null,"spread":false},{"title":"splitpage","children":[{"title":".project <span style='color:#111;'> 1.20KB </span>","children":null,"spread":false},{"title":".mymetadata <span style='color:#111;'> 300B </span>","children":null,"spread":false},{"title":"WebRoot","children":[{"title":"WEB-INF","children":[{"title":"fmt-1_0.tld <span style='color:#111;'> 12.29KB </span>","children":null,"spread":false},{"title":"fmt.tld <span style='color:#111;'> 19.14KB </span>","children":null,"spread":false},{"title":"sql-1_0-rt.tld <span style='color:#111;'> 5.25KB </span>","children":null,"spread":false},{"title":"fmt-1_0-rt.tld <span style='color:#111;'> 11.14KB </span>","children":null,"spread":false},{"title":"permittedTaglibs.tld <span style='color:#111;'> 1.14KB </span>","children":null,"spread":false},{"title":"web.xml <span style='color:#111;'> 801B </span>","children":null,"spread":false},{"title":"scriptfree.tld <span style='color:#111;'> 1.68KB </span>","children":null,"spread":false},{"title":"c-1_0-rt.tld <span style='color:#111;'> 10.51KB </span>","children":null,"spread":false},{"title":"c-1_0.tld <span style='color:#111;'> 11.04KB </span>","children":null,"spread":false},{"title":"x-1_0-rt.tld <span style='color:#111;'> 7.03KB </span>","children":null,"spread":false},{"title":"x.tld <span style='color:#111;'> 12.00KB </span>","children":null,"spread":false},{"title":"sql.tld <span style='color:#111;'> 8.25KB </span>","children":null,"spread":false},{"title":"lib","children":[{"title":"jstl.jar <span style='color:#111;'> 17.39KB </span>","children":null,"spread":false},{"title":"jtds-1.2.jar <span style='color:#111;'> 278.94KB </span>","children":null,"spread":false},{"title":"standard.jar <span style='color:#111;'> 343.11KB </span>","children":null,"spread":false}],"spread":false},{"title":"classes","children":[{"title":"conn","children":[{"title":"DBConn.class <span style='color:#111;'> 2.40KB </span>","children":null,"spread":false}],"spread":false},{"title":"dao","children":[{"title":"PersonDAO.class <span style='color:#111;'> 290B </span>","children":null,"spread":false}],"spread":false},{"title":"servelt","children":[{"title":"SplitServelt.class <span style='color:#111;'> 2.18KB </span>","children":null,"spread":false}],"spread":false},{"title":"vo","children":[{"title":"Person.class <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false}],"spread":false},{"title":"impl","children":[{"title":"PersonImpl.class <span style='color:#111;'> 3.49KB </span>","children":null,"spread":false}],"spread":false},{"title":"data","children":[{"title":"sql.sql <span style='color:#111;'> 2.16KB </span>","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"sql-1_0.tld <span style='color:#111;'> 5.98KB </span>","children":null,"spread":false},{"title":"c.tld <span style='color:#111;'> 15.62KB </span>","children":null,"spread":false},{"title":"fn.tld <span style='color:#111;'> 7.13KB </span>","children":null,"spread":false},{"title":"x-1_0.tld <span style='color:#111;'> 7.49KB </span>","children":null,"spread":false}],"spread":false},{"title":"META-INF","children":[{"title":"MANIFEST.MF <span style='color:#111;'> 39B </span>","children":null,"spread":false}],"spread":true},{"title":"splitpage.jsp <span style='color:#111;'> 3.92KB </span>","children":null,"spread":false}],"spread":true},{"title":".myeclipse","children":null,"spread":false},{"title":"src","children":[{"title":"conn","children":[{"title":"DBConn.java <span style='color:#111;'> 1.81KB </span>","children":null,"spread":false}],"spread":true},{"title":"dao","children":[{"title":"PersonDAO.java <span style='color:#111;'> 268B </span>","children":null,"spread":false}],"spread":true},{"title":"servelt","children":[{"title":"SplitServelt.java <span style='color:#111;'> 2.44KB </span>","children":null,"spread":false}],"spread":true},{"title":"vo","children":[{"title":"Person.java <span style='color:#111;'> 545B </span>","children":null,"spread":false}],"spread":true},{"title":"impl","children":[{"title":"PersonImpl.java <span style='color:#111;'> 2.59KB </span>","children":null,"spread":false}],"spread":true},{"title":"data","children":[{"title":"sql.sql <span style='color:#111;'> 2.16KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":".classpath <span style='color:#111;'> 549B </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

  • 雪落成冰 :
    值得学习。
    2015-12-21
  • sugood :
    没用上!写得还可以~支持下
    2015-09-28
  • 路边小树 :
    完美解决了我的问题,谢谢!
    2015-06-15
  • qq_24366755 :
    我已经按照这个实现了!很有帮助
    2015-01-22
  • u010906096 :
    真的很好用
    2014-10-22

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明