Spring Boot（十四）：Spring Boot + mybatis + Thymeleaf 分页示例（纯底层代码，不是pagehelper）

最近放假在家，终于有时间学习springboot了，当下最流行的java框架，我还没有接触过，有点遗憾，看过尚硅谷雷丰阳老师的springboot基础整合篇，现在轮到项目整合了，在B站发现一个码匠社区项目挺好的，最近刚完成了分页部分的练习，居然没用插件，直接原生代码，有点牛笔。

一、项目架构

二、实现功能

目前我实现了登录，简单的springboot+mybatis的增删改查，使用bootstrap的前台布局，问题列表展示，分页展示等功能。

三、代码实例

我一般是从controller层开始写

indexController

package life.majiang.community.controller;

...

@Controller public class IndexController {

@Autowired

QuestionService questionService;

1@GetMapping(**"/"**)
2**public** String index(@RequestParam(name=**"page"**,defaultValue = **"1"**) Integer page,
3                    @RequestParam(name=**"size"**,defaultValue = **"5"**) Integer size,
4                    Model model) {
5    PaginationDTO pagination = **questionService**.list(page,size);
6    model.addAttribute(**"pagination"**,pagination);
7    **return** **"index"**;
8}

}

QuestionService

1package life.majiang.community.service;
2
3...
4
5@Service
6public class QuestionService {
7
8    @Autowired
9    private QuestionMapper questionMapper;
10
11    @Autowired
12    private UserMapper userMapper;
13
14    public PaginationDTO list(Integer page, Integer size) {
15        PaginationDTO paginationDTO = new PaginationDTO();
16        Integer totalCount = questionMapper.count();
17        paginationDTO.setPagination(totalCount,page,size);
18        if(page<1){
19            page = 1;
20        }
21        if(page>paginationDTO.getTotalPage()){
22            page = paginationDTO.getTotalPage();
23        }
24
25        Integer offset = size * (page-1);
26        List<Question> questions = questionMapper.list(offset,size);
27        List<QuestionDTO> questionDTOList = new ArrayList<>();
28
29        for (Question question:questions){
30            User user = userMapper.getUserBySingleName(question.getCreator());
31            int comments = questionMapper.getComment_count(question);
32            int views = questionMapper.getView_count(question);
33            question.setComment_count(comments);
34            question.setView_count(views);
35            QuestionDTO questionDTO = new QuestionDTO();
36            BeanUtils.copyProperties(question,questionDTO);
37            questionDTO.setUser(user);
38            questionDTOList.add(questionDTO);
39        }
40        paginationDTO.setQuestions(questionDTOList);
41        return paginationDTO;
42    }
43}

QuestionMapper

1package life.majiang.community.mapper;
2
3...
4
5@Mapper
6public interface QuestionMapper {
7    public void insertQuestion(Question question);
8    public String selectQuestionTitle(Question question);
9    public void updateQuestion(Question question);
10    @Select("select * from question limit #{offset},#{size}")
11    public List<Question> list(@Param(value = "offset") Integer offset,
12                               @Param(value = "size") Integer size);
13
14    public Integer count();
15    public int getComment_count(Question question);
16    public int getView_count(Question question);
17    public int getCreatorTitleIsExist(Question question);
18
19    @Select("select * from question where creator=#{creator} limit #{offset},#{size}")
20    List<Question> listByCreator(@Param(value = "creator") String creator, @Param(value = "offset") Integer offset,@Param(value = "size") Integer size);
21}

QuestionMapper,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="life.majiang.community.mapper.QuestionMapper"> <insert id="insertQuestion"> insert into question(creator,title,description,tag,updateTime,comment_count,view_count,like_count) values (#{creator},#{title},#{description},#{tag},now(),1,1,1); </insert> <select id="selectQuestionTitle"** resultType**="String"> select title from question where creator = #{creator}; </select> <update id="updateQuestion"> _ _ </update> <select id="count"** resultType**="Integer"> select count(*) from question; </select> <select id="getComment_count"** resultType**="Integer"> select comment_count from question WHERE creator = #{creator} and title=#{title}; </select> <select id="getView_count"** resultType**="Integer"> select view_count from question WHERE creator = #{creator} and title=#{title}; </select> <select id="getCreatorTitleIsExist"** resultType**="Integer"**> select count(*) from question WHERE creator = #{creator} and title=#{title}; </select> </mapper>

四、实现效果

五、总结

样式有点low，知识点也有点陈旧，但也算是一种学习吧，小白就应该更努力一些，2月15日开始看的，今天19号，看到了P28，又是一个74分钟的视频，真的是有点长，有点烦躁，希望自己能坚持下去。

每一篇博客都是一种经历，程序猿生涯的痕迹，知识改变命运，命运要由自己掌控，愿你游历半生，归来仍是少年。

欲速则不达，欲达则欲速！

更多精彩内容，首发公众号【素小暖】，欢迎关注。

Spring Boot（十四）：Spring Boot + mybatis + Thymeleaf 分页示例（纯底层代码，不是pagehelper）

评论区

相关推荐