maven依赖
<!-- 分页插件 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.12</version>
</dependency>
<!--测试类-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<scope>test</scope>
</dependency>
<!--数据库连接池-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.6</version>
</dependency>
<!--数据库-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.21</version>
</dependency>
<!--themeleaf模板引擎-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<!--web-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.4</version>
</dependency>
Service 层分页
@Service
public class TypeServiceImpl implements TypeService {
@Autowired
private TypeMapper typeMapper;
@Override
public List<Type> getAllType(int page,int size) {
//PageHelper的startPage方法传入页数page和每页的数量size
//它和调用的Mapper方法中间不能放其他语句,否则会出错 这个我是看其他博客上说的没有测试过
PageHelper.startPage(page,size);
List<Type> types=typeMapper.getListType();
return types;
}
}
Cotroller层
@Controller
@RequestMapping("/admain")
public class TypeController {
@Autowired
private TypeService typeService;
@GetMapping("/types")
public String pages(@RequestParam(name="page",required = true,defaultValue = "0")int page,
@RequestParam(name="size",required = true,defaultValue = "5")int size,Model model){
List<Type> typeList=typeService.getAllType(page, size);
//将查询到的数据放入PageInfo中,里面定义了许多方便使用的页面的方法
PageInfo pageInfo=new PageInfo(typeList);
model.addAttribute("pageInfo",pageInfo);
return "admain/types";
}
}