|
马上注册,结交更多好友,享用更多功能^_^
您需要 登录 才可以下载或查看,没有账号?立即注册
x
我使用Servlet、Mybatis和JSP搭建了一个web项目,已经完成了查询功能的开发。现在想写一个分页查询功能,使用SQL的limite语句分页查询,初始化只查询前两个,之后通过点击前端的按钮来切换每页展示的信息。已知分页的selectByPage可以正常运行,但是点击了前端的按钮无法实现预期的分页功能。
- package edu.zjku.controller;
- import edu.zjku.bean.Blog;
- import edu.zjku.service.BlogService;
- import edu.zjku.service.BlogServiceImpl;
- import javax.servlet.ServletException;
- import javax.servlet.annotation.WebServlet;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import javax.servlet.http.HttpSession;
- import java.io.IOException;
- import java.util.List;
- //这是查询所有博客的Servlet
- @WebServlet("/selectServlet")
- public class SelectServlet extends HttpServlet {
- private BlogService service = new BlogServiceImpl();
- @Override
- protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
- //获取分页信息
- String param = req.getParameter("pageNumber");
- String param2 = req.getParameter("linesPerPage");
- int pageNumber;
- int linesPerPage;
- try {
- pageNumber = Integer.parseInt(param);
- linesPerPage = Integer.parseInt(param2);
- } catch (NumberFormatException e) {
- pageNumber = 1;
- linesPerPage = 2;
- }
- //读取数据并封装
- List<Blog> blogs = null;
- blogs = service.selectByPage(pageNumber, linesPerPage);
- //存入会话域给看博客页面使用
- HttpSession session = req.getSession();
- session.setAttribute("blogs", blogs);
- //跳转到看博客页面
- resp.sendRedirect("/theBlog/read.jsp");
- }
- @Override
- protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
- doGet(req, resp);
- }
- }
复制代码 |
|