springboot集成pagehelper

最新推荐文章于 2024-06-25 23:14:45 发布

『』

最新推荐文章于 2024-06-25 23:14:45 发布

阅读量146

点赞数

分类专栏： spring boot 文章标签： springboot pagehelper

spring boot 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

1、导入依赖，包括mybatis、jdbc的依赖，如果导入了，就不要重复导入了

<!-- springboot集成mybatis -->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.0.1</version>
</dependency>

<!-- 引入mysql操作类 -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

<!-- springboot集成pagehelper分页 -->
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>1.2.12</version>
</dependency>

2、配置application.properties

# 配置pagehelper

pagehelper.helper-dialect=mysql
# reasonable分页参数合理化,禁用合理化时，如果pageNum<1或pageNum>pages会返回空数据
pagehelper.reasonable=true
pagehelper.support-methods-arguments=true
pagehelper.params=count=countSql

3、编写DAO

<select id="listWithPage" resultType="User">
    SELECT id, username, password
    FROM user
</select>

4、编写service

public PageInfo<User> listWithPage(Integer pageNum, Integer pageSize) {
    //设置分页一定要在sql查询之前
	PageHelper.startPage(pageNum, pageSize);
	//查询
	List<User> userList = userMapper.listWithPage();
	//PageInfo包括查询的数据和分页信息
	PageInfo<User> pageInfo = new PageInfo<>(userList);
	return pageInfo;
}

5、编写controller

@RequestMapping("/listUser")
public String listUser(@RequestParam(name = "pageNum", defaultValue = "1") Integer pageNum,
					   @RequestParam(name = "pageSize", defaultValue = "5") Integer pageSize, ModelMap map) {
	PageInfo<User> pageInfo = userService.listWithPage(pageNum, pageSize);
	map.addAttribute("pageInfo", pageInfo);
	logger.info("查询的数据：{}", JSONObject.toJSON(pageInfo.getList()));
	return "web/userList";
}

6、freemarker结合bootstrap编写页面，注意bootstrap的路径问题（我的放在static目录下）：因为spring boot默认的静态资源访问路径为src/main/resources下面的/static 或 /public 或 /resources 或 /META-INF/resources，因此不用再在路径前加static

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>用户列表界面</title>
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link href="/bootstrap-3.3.7-dist/css/bootstrap.min.css" rel="stylesheet">
    <script src="/bootstrap-3.3.7-dist/js/jquery-3.3.1.min.js"></script>
    <script src="/bootstrap-3.3.7-dist/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
    <div class="row">
        <div class="col-md-6 col-md-offset-3">
            <table class="table table-striped table-bordered table-hover">
                <tr>
                    <td>序号</td>
                    <td>用户名</td>
                    <td>密码</td>
                </tr>
                <#list pageInfo.getList() as item>
                <tr>
                    <td>${item.id}</td>
                    <td>${item.username}</td>
                    <td>${item.password}</td>
                </tr>
                </#list>
            </table>
            <nav aria-label="Page navigation">
                <ul class="pagination">
                    <li>
                        <a href="/listUser?pageNum=${pageInfo.pageNum - 1}&pageSize=${pageInfo.pageSize}" aria-label="Previous">
                            <span aria-hidden="true">&laquo;</span>
                        </a>
                    </li>
                    <li class="active">
                        <span>${pageInfo.pageNum} <span class="sr-only">(current)</span></span>
                    </li>
                    <li>
                        <a href="/listUser?pageNum=${pageInfo.pageNum + 1}&pageSize=${pageInfo.pageSize}" aria-label="Next">
                            <span aria-hidden="true">&raquo;</span>
                        </a>
                    </li>
                </ul>
            </nav>
        </div>
    </div>
</div>
</body>
</html>

7、效果

『』

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
springboot集成pagehelper

1、导入依赖，包括mybatis、jdbc的依赖，如果导入了，就不要重复导入了<dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-sta...
复制链接

扫一扫

专栏目录