利用postman完成数据的分页查询功能（springboot）

刺骨的言语ヽ痛彻心扉 2023-09-28 21:55 4阅读 0赞

**postman简介：** postman工具是用来做网络接口测试的，用它来模拟网络请求，上传数据，然后得到后台项目返回的响应。Postman可以模拟表单提交，也能模拟Ajax请求，测试网络接口变得非常容易。

第一步，代码分析

@RequestMapping("findAllSimplePage")
    @ResponseBody
    // @RequestBody(required=false) 表示map对象可以不传入
    public String findAllSimplePage(@RequestBody(required = false) Map<String,Object> requestMap){
        
        int page = 1;
        int size = 5;
        if (requestMap != null){
        
            if (requestMap.get("page").toString() != null){
        
                page = Integer.parseInt(requestMap.get("page").toString());  // Integer.parseInt是Integer类中提供的一个静态方法,用于将传入的string类型字符串根据要求转为相应进制的int值, 如果没有要求进制则按10进制计算
            }
            if (requestMap.get("size").toString() != null){
        
                page = Integer.parseInt(requestMap.get("size").toString());
            }
        }
        PageInfo<User> pageInfo = csi.findAllSimplePage(page,size);
        List<User> users = pageInfo.getList();   // 等待dump
        long total = pageInfo.getTotal();        // 等待dump
        JSONObject result = new JSONObject();    // JSONObject-lib包是一个beans,collections,maps,java arrays和xml和JSON互相转换的包,将实体对象转换成Json字符串。
        result.put("rows",users);
        result.put("total",(int)total);
        return result.toJSONString();  // toJSONString()默认忽略值为null的属性.
    }

第二步，打开IDEA，执行程序后查看端口号为8080（http）。  
![在这里插入图片描述][00c8b8d863574696ae4b8ac49db9a373.png]

第三步，打开postman，初始界面如下。  
![在这里插入图片描述][a61d3bf8114044e1a482470139750574.png]

第四步，点击postman上方的➕，新建一个postman数据传输的操作界面，不输入任何的参数，点击send后，可以发现输入什么传出什么。  
接口的URL地址组成：http://127.0.0.1：端口号/控制器/方法。  
![在这里插入图片描述][696691161095442b977565bc58073637.png]

**相关链接：**  
[IntelliJ IDEA中构建Spring Boot的项目][IntelliJ IDEA_Spring Boot]  
[Spring Boot中的配置文件（application.properties、application.yml与pom.xml）][Spring Boot_application.properties_application.yml_pom.xml]  
[ORM、JPA、Spring Data JPA和常用的五种访问数据库方式][ORM_JPA_Spring Data JPA]

[SpringBoot–页面显示列表功能][SpringBoot]  
[SpringBoot–列表添加详情功能][SpringBoot 1]  
[SpringBoot–列表添加新增功能][SpringBoot 2]  
[SpringBoot–列表更新功能][SpringBoot 3]  
[SpringBoot–列表删除功能][SpringBoot 4]

[SpringBoot的控制层注解(@Controller与@RestController)][SpringBoot_Controller_RestController]  
[SpringBoot的业务层注解(@Resource、@Autowired与@Qualifier)][SpringBoot_Resource_Autowired_Qualifier]  
[SpringBoot的映射（@RequestMapping、@GetMapping与@PostMapping）][SpringBoot_RequestMapping_GetMapping_PostMapping]  
[SpringBoot的函数参数（JavaBean对象、@RequestParam与@RequestBody）][SpringBoot_JavaBean_RequestParam_RequestBody]  
[SpringBoot的返回数据（@ResponseBody、返回templates下的网页 与 返回公共网页）][SpringBoot_ResponseBody_templates_ _]

[利用postman完成JSON串的发送功能（springboot）][postman_JSON_springboot]  
[利用postman完成数据的分页查询功能（springboot）][postman_springboot]  
[利用postman完成向数据库中添加数据的功能（springboot）][postman_springboot 1]

[Please refer to dump files (if any exist) \[date\].dump, \[date\]-jvmRun\[N\].dump and \[date\].dumpstream.][Please refer to dump files _if any exist_ _date_.dump_ _date_-jvmRun_N_.dump and _date_.dumpstream.]  
[Preparing: insert into user(uuid,username,gender,age,phone,address) values(?,?,?,?,?,?,?)][Preparing_ insert into user_uuid_username_gender_age_phone_address_ values]  
[Could not autowire. No beans of ‘UserMapper‘ type found.][Could not autowire. No beans of _UserMapper_ type found.]  
[Error starting ApplicationContext. To display the conditions report re-run your application with][]  
[Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is`com.mysql.cj.jdb][Loading class _com.mysql.jdbc.Driver_. This is deprecated. The new driver class is_com.mysql.cj.jdb]  
[Plugin ‘org.springframework.boot:spring-boot-maven-plugin:‘ not found][Plugin _org.springframework.boot_spring-boot-maven-plugin_ not found]  
[Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource could][Failed to configure a DataSource_ _url_ attribute is not specified and no embedded datasource could]  
[This application has no explicit mapping for /error, so you are seeing this as a fallback.][This application has no explicit mapping for _error_ so you are seeing this as a fallback.]  
[BootStrap-SpringBoot的使用过程中前端table表格无法加载出数据。][BootStrap-SpringBoot_table]

[00c8b8d863574696ae4b8ac49db9a373.png]: https://img-blog.csdnimg.cn/00c8b8d863574696ae4b8ac49db9a373.png
[a61d3bf8114044e1a482470139750574.png]: https://img-blog.csdnimg.cn/a61d3bf8114044e1a482470139750574.png
[696691161095442b977565bc58073637.png]: https://img-blog.csdnimg.cn/696691161095442b977565bc58073637.png
[IntelliJ IDEA_Spring Boot]: https://blog.csdn.net/blbyu/article/details/126745392
[Spring Boot_application.properties_application.yml_pom.xml]: https://blog.csdn.net/blbyu/article/details/126747098
[ORM_JPA_Spring Data JPA]: https://blog.csdn.net/blbyu/article/details/126739840
[SpringBoot]: https://blog.csdn.net/blbyu/article/details/126749514
[SpringBoot 1]: https://blog.csdn.net/blbyu/article/details/126749700
[SpringBoot 2]: https://blog.csdn.net/blbyu/article/details/126749722
[SpringBoot 3]: https://blog.csdn.net/blbyu/article/details/126749745
[SpringBoot 4]: https://blog.csdn.net/blbyu/article/details/126760296
[SpringBoot_Controller_RestController]: https://blog.csdn.net/blbyu/article/details/126744746
[SpringBoot_Resource_Autowired_Qualifier]: https://blog.csdn.net/blbyu/article/details/126744825
[SpringBoot_RequestMapping_GetMapping_PostMapping]: https://blog.csdn.net/blbyu/article/details/126744866
[SpringBoot_JavaBean_RequestParam_RequestBody]: https://blog.csdn.net/blbyu/article/details/126744903
[SpringBoot_ResponseBody_templates_ _]: https://blog.csdn.net/blbyu/article/details/126744442
[postman_JSON_springboot]: https://blog.csdn.net/blbyu/article/details/126533207
[postman_springboot]: https://blog.csdn.net/blbyu/article/details/126533491
[postman_springboot 1]: https://blog.csdn.net/blbyu/article/details/126532840
[Please refer to dump files _if any exist_ _date_.dump_ _date_-jvmRun_N_.dump and _date_.dumpstream.]: https://blog.csdn.net/blbyu/article/details/126497411
[Preparing_ insert into user_uuid_username_gender_age_phone_address_ values]: https://blog.csdn.net/blbyu/article/details/126532138
[Could not autowire. No beans of _UserMapper_ type found.]: https://blog.csdn.net/blbyu/article/details/126532911
[Error starting ApplicationContext. To display the conditions report re-run your application with]: https://blog.csdn.net/blbyu/article/details/126468130
[Loading class _com.mysql.jdbc.Driver_. This is deprecated. The new driver class is_com.mysql.cj.jdb]: https://blog.csdn.net/blbyu/article/details/126588912
[Plugin _org.springframework.boot_spring-boot-maven-plugin_ not found]: https://blog.csdn.net/blbyu/article/details/126589582
[Failed to configure a DataSource_ _url_ attribute is not specified and no embedded datasource could]: https://blog.csdn.net/blbyu/article/details/126595381
[This application has no explicit mapping for _error_ so you are seeing this as a fallback.]: https://blog.csdn.net/blbyu/article/details/126595503
[BootStrap-SpringBoot_table]: https://blog.csdn.net/blbyu/article/details/126624043