MyBatis分页的简单实现

使用spring+springmvc+mybatis实现简单的分页查询
spring+springmvc+mybatis的整合配置就不在赘述了

1.需要下载pagehelper-3.2.1.jar
2.po层—News.java

package com.ssm.po;

import java.util.Date;

public class News {

    private int id;
    private int academyId;
    private String title;
    private Date time;
    private String content;
    private String address;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public int getAcademyId() {
        return academyId;
    }

    public void setAcademyId(int academyId) {
        this.academyId = academyId;
    }

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public Date getTime() {
        return time;
    }

    public void setTime(Date time) {
        this.time = time;
    }

    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

}

3.mapper层—NewsMapper.java

public List<News> listAllNews();

**4.mapper的配置文件—NewsMapper.xm**l

<!--列出所有新闻信息 -->
    <select id="listAllNews" resultType="News">
        select id,academyId,title,time,content,address from news
    </select>

5.mybatis的配置信息—sqlMapConfig.xml
在mybatis的配置中添加pagehelper的插件配置

<plugins>
        <plugin interceptor="com.github.pagehelper.PageHelper">
            <!-- 设置数据库类型 -->
            <property name="dialect" value="mysql"/>
        </plugin>
    </plugins>

6.service层的开发—NewsService.java

public List<News> listAllNews();

7.service的实现类—NewsServiceImpl.java

    @Autowired
    private NewsMapper newsMapper;

    @Override
    public List<News> listAllNews() {
        // TODO Auto-generated method stub
        return newsMapper.listAllNews();
    }

8.测试类的开发

private static ApplicationContext applicationContext;

    private static NewsMapper newsMapper;

    private static NewsService newsService;

    @BeforeClass
    public static void setUpBeforeClass() throws Exception {
        applicationContext = new ClassPathXmlApplicationContext(
                "classpath:spring/applicationContext-dao.xml");
        newsMapper = (NewsMapper) applicationContext.getBean("newsMapper");

    }

// 列出所有新闻信息
    @Test
    public void testListAllNews() {

        PageHelper.startPage(1, 5);
        List<News> listNews = newsMapper.listAllNews();
        for (News news : listNews) {
            System.out.println(news.getId() + "--" + news.getTime() + "---"
                    + news.getAcademyId() + "--" + news.getTitle() + "--"
                    + news.getContent() + "--" + news.getAddress());
        }
        System.out.println(listNews.size());
    }

@AfterClass
    public static void tearDownAfterClass() throws Exception {
    }

9.测试结果

总结：上述步骤只是简单的实现了分页功能，而且需要手动设置页数的大小，无法灵活的进行分页。