Mybatis的pagehelper使用遇到的坑

下面是maven中配置pagehelp: 用的是5.1.2版本

<!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper -->
<dependency>
   <groupId>com.github.pagehelper</groupId>
   <artifactId>pagehelper</artifactId>
   <version>5.1.2</version>  <!--我这里用的是5.1.2版本-->
</dependency>

下面是spring-mybatis.xml的配置文件:

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="mapperLocations" value="classpath:com/demo/mapping/*.xml"></property>
        <property name="configLocation" value="classpath:conf/mybatis-config.xml"></property>
</bean>

下面是mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING" />
        <setting name="cacheEnabled" value="true" />
    </settings>
    <typeAliases>
        <typeAlias alias="Blog" type="com.demo.pojo.Blog" />
    </typeAliases>
    <plugins>
        <!--注意这里要写成PageInterceptor, 5.0之前的版本都是写PageHelper, 5.0之后要换成PageInterceptor-->
        <plugin interceptor="com.github.pagehelper.PageInterceptor">
            <!--<property name="helperDialect" value="mysql" />-->
            <property name="reasonable" value="true" />
        </plugin>
    </plugins>
</configuration>

下面是BlogMapper.xml:

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.demo.dao.BlogMapper" >
  <cache eviction="FIFO" flushInterval="60000" size="512" readOnly="true" />
  <resultMap id="BaseResultMap" type="com.demo.pojo.Blog" >
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="authorid" property="authorid" jdbcType="INTEGER" />
    <result column="title" property="title" jdbcType="VARCHAR" />
    <result column="creattime" property="creattime" jdbcType="VARCHAR" />
  </resultMap>
  <resultMap id="ResultMapWithBLOBs" type="com.demo.pojo.Blog" extends="BaseResultMap" >
    <result column="mainbody" property="mainbody" jdbcType="LONGVARCHAR" />
  </resultMap>
  <select id="selectAllByList" resultMap="ResultMapWithBLOBs">
       select 
  <include refid="Base_Column_List" />
    ,
  <include refid="Blob_Column_List" />
    from blog
  </select>
</mapper>

下面是BlogMapper.java:

package com.demo.dao;
import com.demo.pojo.Blog;
public interface BlogMapper {
    //注意这里返回的类型是List, 而我们在BlogMapper.xml中写的返回类型是ResultMapWithBLOBs类型
    List<Blog> selectAllByList(); 
}

下面是BlogService.java:

package com.demo.service;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import com.demo.dao.BlogMapper;
import com.demo.pojo.Blog;
@Service(value="blogService")
public class BlogService {    
    @Resource
    private BlogMapper blogMapper;    
    public List<Blog> selectBlogByList() {
        List<Blog> blog = this.blogMapper.selectAllByList();
        return blog;
    }
}

下面是BlogController.java:

package com.demo.controller;

import java.io.IOException;
import java.io.PrintWriter;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;
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.demo.pojo.Blog;
import com.demo.service.BlogService;

@Controller
@RequestMapping(value = "/blog")
public class BlogController {    
    private static final Logger LOG = LogManager.getLogger(BlogController.class);    
    @Autowired
    private BlogService blogService;    
    @RequestMapping(value="/pagehelper", method = RequestMethod.GET)
    public String blogPageHelper(HttpServletRequest request, @RequestParam(required=true,defaultValue="1") Integer page,
            @RequestParam(required=false,defaultValue="4") Integer pageSize, ModelMap model) {
        // 我这里起始的默认值是第1页, 每页的大小是4个, 读者可以根据需要改变      
        LOG.info("page="+page+",pageSize="+pageSize); // 开始的打印结果: page=1,pageSize=4, 之后的page根据传入的值变化
            
        PageHelper.startPage(page, pageSize); //开始起始页
        List<Blog> blogList = blogService.selectBlogByList(); // 获取数据
        PageInfo<Blog> p = new PageInfo<Blog>(blogList); // 实例化PageInfo
        model.addAttribute("blogList", blogList);
        model.addAttribute("page", p); // 设置属性到前端页面
        return "blog/pagehelper";
    }
}

下面是前端的页面,即pagehelper.html:
前端页面我使用的是thymeleaf框架, 读者可以参考我的另一篇博客: thymeleaf 模板语言简介

<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8" />
<script type="text/javascript" th:src="@{/static/js/jquery-1.11.3.min.js}"></script>
<script type="text/javascript" th:src="@{/static/js/springDemo.js}"></script>
<link rel="stylesheet" th:href="@{/static/css/springDemo.css}" />
<title>SpringMVC + Mybatis + Spring</title>
</head>
<body>
    <div>
        <table class="example">
         <caption>Blog</caption>
            <thead>
                <tr>
                    <th>number</th>
                    <th>index</th>
                    <th>id</th>
                    <th>title</th>
                    <th>mainbody</th>
                    <th>creattime</th>
                </tr>
            </thead>
            <tbody th:remove="all-but-first">
                <tr th:each="blog,blogStat:${blogList}">
                    <td th:text="${blogStat.count}">1</td>
                    <td th:text="${blogStat.index}">0</td>
                    <td th:text="${blog.id}">title</td>
                    <td th:text="${blog.title}">title</td>
                    <td th:text="${blog.mainbody}">mainbody</td>
                    <td th:text="${blog.creattime}">creattime</td>
                </tr>
            </tbody>
            <tbody th:remove="all-but-first">  <!--我这里ui显示比较简单,就是为了方便显示-->
                <tr>
                    <td colspan="2"><p th:text="'Total:' + ${page.pages}">Total page</p></td>
                    <td><a th:href="@{/blog/pagehelper(page=1)}">first</a></td>
                    <td><a th:href="@{/blog/pagehelper(page=${page.nextPage})}">next</a></td>
                    <td><a th:href="@{/blog/pagehelper(page=${page.prePage})}">prex</a></td>
                    <td><a th:href="@{/blog/pagehelper(page=${page.lastPage})}">last</a></td>
                </tr>
            </tbody>
        </table>    
    </div>
</body>
</html>