springboot用thymeleaf模板的paginate分页完整代码

 <!--支持 Web 应用开发，包含 Tomcat 和 spring-mvc。 -->      org.springframework.bootspring-boot-starter-web      org.springframework.bootspring-boot-starter-testtest<!--模板引擎-->      org.springframework.bootspring-boot-starter-thymeleaf<!--Mybatis--> org.mybatismybatis-spring1.2.2 org.mybatismybatis3.2.8 org.mybatis.generatormybatis-generator-core1.3.2<!-- mybatis pagehelper --> com.github.pagehelperpagehelper3.6.3<!--Mysql / DataSource--> org.apache.tomcattomcat-jdbc mysqlmysql-connector-java<!--springboot 集成Mybatis所需jar配置 end-->

 spring.datasource.platform=mysql spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8 spring.datasource.username=root spring.datasource.password=root spring.datasource.driverClassName=com.mysql.jdbc.Driver # Advanced configuration... spring.datasource.max-active=50 spring.datasource.max-idle=6 spring.datasource.min-idle=2 spring.datasource.initial-size=6 #create table spring.jpa.hibernate.ddl-auto=validate spring.thymeleaf.prefix=classpath:/templates/ spring.thymeleaf.suffix=.html spring.thymeleaf.mode=HTML5 spring.thymeleaf.encoding=UTF-8 spring.thymeleaf.content-type=text/html spring.thymeleaf.cache=false

 @SpringBootApplication @MapperScan("com.boot.mapper") public class Application { //定义一个全局的记录器，通过LoggerFactory获取 private final static Logger logger = LoggerFactory.getLogger(Application.class); //----------------------------mybaits配置start------------------------------------------- //DataSource @Bean @ConfigurationProperties(prefix="spring.datasource") public DataSource dataSource() { return new org.apache.tomcat.jdbc.pool.DataSource(); } //SqlSessionFactory @Bean public SqlSessionFactory sqlSessionFactoryBean() throws Exception { SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean(); sqlSessionFactoryBean.setDataSource(dataSource()); PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver(); sqlSessionFactoryBean.setMapperLocations(resolver.getResources("classpath:mapper/*.xml")); return sqlSessionFactoryBean.getObject(); } @Bean public PlatformTransactionManager transactionManager() { return new DataSourceTransactionManager(dataSource()); } //------------------------------mybaits配置end--------------------------------- public static void main(String[] args){ System.out.println("Hello World!"); SpringApplication.run(Application.class, args); } } 

 private Integer id; private String name; private String password;

 @RestController public class UserController { @Autowired UserService uSer; @RequestMapping("userlist") public Object userlist(@RequestParam(value="pageon",defaultValue="1")int pageon ,ModelAndView mv){ mv.addAllObjects(uSer.UserList(pageon)); return mv; } }

 public Map UserList(int pageon) { // TODO Auto-generated method stub Map map=new HashMap(); Page page=new Page(pageon); page.setRowcountAndCompute(userMapper.selectPageListCount(null)); map.put("page", page); map.put("list", userMapper.selectPageList(map)); return map; }

  select id, name, password from user order by id limit #{page.start},#{page.row}  select count(1) from user 

 package com.boot.utils; import java.io.Serializable; public class Page implements Serializable { /** * */ private static final long serialVersionUID = 1L; publi<div style="color:transparent">来源gaodai.ma#com搞#代!码网</div>c int getPageon() { return pageon; } public void setPageon(int pageon) { this.pageon = pageon; } public int getRowcount() { return rowcount; } public void setRowcount(int rowcount) { this.rowcount = rowcount; } public int getPagecount() { return pagecount; } public void setPagecount(int pagecount) { this.pagecount = pagecount; } public int getRow() { return row; } public void setRow(int row) { this.row = row; } public Page(int pageon, int row, int rowcount) { pageNumber = 11; this.pageon = pageon; this.row = row; this.rowcount = rowcount; compute(); } public Page(int pageon, int row) { pageNumber = 11; this.pageon = pageon; this.row = row; } public Page(int pageon) { pageNumber = 11; this.pageon = pageon; } public Page() { pageNumber = 11; } public int getPageNumber() { return pageNumber; } public void setPageNumber(int pageNumber) { this.pageNumber = pageNumber; } public void compute() { if (rowcount <= 0) return; if (row  pagecount) pageon = pagecount; if (pageon  rowcount) end = rowcount; } public int getStart() { return start; } public void setStart(int start) { this.start = start; } public int getEnd() { return end; } public void setEnd(int end) { this.end = end; } public void setRowcountAndCompute(int rowcount) { this.rowcount = rowcount; compute(); } protected int pageon; protected int rowcount; protected int pagecount; protected int row; protected int start; protected int end; protected int pageNumber; }

   <title>用户列表</title> <div style="width: 1000px"> <table style="border-width: 1px;border-style: dashed"> <tr> <td>ID</td><td>姓名</td><td>密码</td></tr><p> <tr> <td>ID</td><td>姓名</td><td>密码</td></tr></p></table><div id="page"></div><div></div></div>

 <div id="page"></div><div></div>