<!-- mybatis分页插件 -->

    <dependency>

        <groupId>com.github.pagehelper</groupId>

        <artifactId>pagehelper</artifactId>

        <version>4.2.1</version>

    </dependency>

    <bean name="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

        <property name="dataSource" ref="dataSource" />

        <property name="mapperLocations" value="classpath:com/wode/mapper/*.xml" />

        <property name="plugins">

            <array>

                <bean class="com.github.pagehelper.PageHelper">

                    <property name="properties">

                        <value>

                            dialect=mysql

                        </value>

                    </property>

                </bean>

            </array>

        </property>

    </bean>

@Service

public class MsgService {

    @Resource

    private MsgMapper msgMapper;

    public PageInfo<Msg> queryMsgByUserId(String userId, int currentPage){

        //参数一是起始页（1.2.3.4...），参数二是每页显示的条数

        PageHelper.startPage(currentPage, IConstant.MSG_PAGE_SIZE);

        List<Msg> msgList = msgMapper.queryMsgByUserId(userId);

        PageInfo<Msg> pageJson = new PageInfo<Msg>(msgList);

        return pageJson;

    }

}