ssm框架+PageHelper插件实现分页查询功能

   org.springframeworkspring-core4.3.2.RELEASE org.springframeworkspring-aop4.3.2.RELEASE org.springframeworkspring-aspects4.3.2.RELEASE org.springframeworkspring-beans4.3.2.RELEASE org.springframeworkspring-context4.3.2.RELEASE org.springframeworkspring-expression4.3.2.RELEASE org.springframeworkspring-jdbc4.3.2.RELEASE org.springframeworkspring-test4.3.2.RELEASE org.springframeworkspring-tx4.3.2.RELEASE org.springframeworkspring-web4.3.2.RELEASE org.springframeworkspring-webmvc4.3.2.RELEASE org.mybatismybatis-spring1.3.0 org.mybatismybatis3.4.4 commons-iocommons-io2.4 org.apache.commonscommons-lang33.4 commons-loggingcommons-logging1.1.1 org.apache.logging.log4jlog4j-core2.9.1 org.slf4jslf4j-log4j121.7.21test aopallianceaopalliance1.0 mysqlmysql-connector-java5.1.38 com.mchangec3p00.9.5.2 javax.servletjstl1.2 javax.servletjavax.servlet-api3.1.0provided javax.servlet.jspjavax.servlet.jsp-api2.2.1provided taglibsstandard1.1.2 com.github.pagehelperpagehelper5.1.2   org.apache.maven.pluginsmaven-compiler-plugin3.6.1 utf-8 org.apache.tomcat.maventomcat7-maven-plugin2.2 UTF-8

  com.github.pagehelperpagehelper5.1.2

   <!-- 扫描注解的包 --><!-- 配置数据库 --><!-- 加载配置文件 --> <!-- 配置sqlSessionFactory, 并将数据源注入 --> <!-- 引入数据源 --><!--载入mybatis配置文件--><!--载入配置mapper映射的xml--><!-- 配置映射接口 --> <!-- 配置声明式事务 --> <!-- 配置aop -->

   <!-- 扫描注解的包 --><!-- 开启注解 --><!--静态资源访问--><!-- 配置视图解析器 --> 

   <!-- 引入 pageHelper插件 --><!--注意这里要写成PageInterceptor, 5.0之前的版本都是写PageHelper, 5.0之后要换成PageInterceptor-->  <!--reasonable：分页合理化参数，默认值为false。 当该参数设置为 true 时，pageNumpages（超过总数时），会查询最后一页。 默认false 时，直接根据参数进行查询。-->

   pagehelper index.jsp org.springframework.web.context.ContextLoaderListener contextConfigLocationclasspath:applicationContext.xml springmvcorg.springframework.web.servlet.DispatcherServlet contextConfigLocationclasspath:springmvc.xml1 springmvc/ encodingFilterorg.springframework.web.filter.CharacterEncodingFilter encodingUTF-8 encodingFilter/*

 package com.jiangfx.controller; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.ModelMap; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; import com.jiangfx.entity.User; import com.jiangfx.service.UserService; @Controller public class UserController { @Autowired private UserService pageService; /** * 分页查询 */ @RequestMapping(value="/list",method=RequestMethod.GET) public String pageList(ModelMap map,@RequestParam(defaultValue="1",required=true,value="pageNo") Integer pageNo){ Integer pageSize=4;//每页显示记录数 //分页查询 PageHelper.startPage(pageNo, pageSize); List userList = pageService.list();//获取所有用户信息 PageInfo pageInfo=new PageInfo(userList); map.addAttribute("pageInfo", pageInfo); return "list"; } }

 package com.jiangfx.service.impl; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.jiangfx.entity.User; import com.jiangfx.mapper.UserMapper; import com.jiangfx.service.UserService; @Service public class UserServiceImpl implements UserService { @Autowired private UserMapper userMapper; /** * 查询所有用户 * @return */ @Override public List list() { return userMapper.getAllUser(); } }

 package com.jiangfx.entity; public class User { private Integer id; private String username; private String sex; private String city; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public String getCity() { return city; } public void setCity(String city) { this.city = city; } @Override public String toString() { return "User [i<strong style="color:transparent">来源gaodai#ma#com搞@@代~&码网</strong>d=" + id + ", username=" + username + ", sex=" + sex + ", city=" + city + "]"; } }

 package com.jiangfx.mapper; import java.util.List; import com.jiangfx.entity.User; public interface UserMapper { //查询所有用户 List getAllUser(); }

   <!-- 查询博客 --> select * from user 

   <title>Insert title here</title> 分页查询

   <title>Insert title here</title>  <table width="200" border="1"> <tr> <th scope="col">ID</th><th scope="col">姓名</th><th scope="col">性别</th><th scope="col">城市</th></tr> <tr> <td>${user.id}</td><td>${user.username}</td><td>${user.sex}</td><td>${user.city}</td></tr></table><p>当前 ${pageInfo.pageNum }页,总${pageInfo.pages } 页,总 ${pageInfo.total } 条记录</p></div></p>第一页 上一页 下一页最后页