分页查询与SpringBoot3.x的pageHelper配置问题

在Spring Boot 3.x中，使用MyBatis进行分页查询时，可以使用PageHelper插件。以下是配置和使用PageHelper的步骤：

1. 在pom.xml中添加PageHelper依赖：

<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>最新版本</version>
</dependency>

2. 在application.properties或application.yml中配置PageHelper参数（如果有特殊需求）：

# application.properties
pagehelper.helperDialect=mysql
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql

3. 在MyBatis的Mapper接口中使用PageHelper进行分页：

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
 
@Repository
public interface YourMapper {
    @Select("SELECT * FROM your_table")
    PageInfo<YourEntity> selectByPage(int pageNum, int pageSize);
}

4. 在Service层调用Mapper方法进行分页查询：

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
@Service
public class YourService {
 
    @Autowired
    private YourMapper yourMapper;
 
    public PageInfo<YourEntity> queryByPage(int pageNum, int pageSize) {
        PageHelper.startPage(pageNum, pageSize);
        return yourMapper.selectByPage(pageNum, pageSize);
    }
}

5. 在Controller中调用Service层的分页方法：

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
 
@RestController
public class YourController {
 
    @Autowired
    private YourService yourService;
 
    @GetMapping("/queryByPage")
    public PageInfo<YourEntity> queryByPage(@RequestParam int pageNum, @RequestParam int pageSize) {