Java之Spring Boot+Vue+Element UI前后端分离项目（中-功能完善-实现查询） 【博客论坛项目高仿优快云】（一篇文章精通系列

public PageResult queryBlogByPage(String title, Integer page, Integer rows) {

PageHelper.startPage(page, rows);//自动创建好分页的条件

System.out.println(“----------”);

List list = blogMapper.queryBlogByPage(title);

PageResult pageResult = new PageResult();

pageResult.setItems(list);//设置数据

//解析分页结果

PageInfo pageInfo = new PageInfo(list);//得到分页信息

pageResult.setTotal(pageInfo.getTotal());//设置总条数

long l = pageInfo.getTotal() / pageInfo.getPageSize();

pageResult.setTotalPage(Integer.parseInt(l+1+“”));

return pageResult;

}

}

（4）完善BlogMapper

package cn.itbluebox.springbootcsdn.mapper;

import cn.itbluebox.springbootcsdn.domain.Blog;

import org.apache.ibatis.annotations.Select;

import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface BlogMapper extends Mapper {

@Select(“select * from blog where title like ‘%${title}%’”)

List queryBlogByPage(String title);

}

（5）完善SpringBoot优快云Application

package cn.itbluebox.springbootcsdn;

import org.springframework.boot.SpringApplication;

import org.springframework.boot.autoconfigure.SpringBootApplication;

import tk.mybatis.spring.annotation.MapperScan;

@SpringBootApplication

@MapperScan(“cn.itbluebox.springbootcsdn.mapper”)

public class SpringBoot优快云Application {

public static void main(String[] args) {

SpringApplication.run(SpringBoot优快云Application.class, args);

}

}

2、运行测试

访问：http://localhost:9090/blog/queryBlogByPage?title=&page=1&rows=5

二 、实现查询博客功能（前端功能实现）

---

1、修改App.vue