1.GET请求,通过导入csv文件来处理 GET http://localhost:8080/web/addstudent?sno={{sno}}&name={{name}}&sex={{sex}}
2.POST请求，通过导入json文件来处理。 示例中的excel表格数据通过http://tools.jb51.net/code/excel_col2json/ 转换成json格式 POST http://localhost:8080/web/addstudent2 {"sno":"{{sno}}","name":"{{name}}","sex":"{{sex}}"} //注意带上双引号，否则入参的请求会报错
Data File 赋值的参数通过"{{参数}}"来实现。
集合运行器让我们导入CSV或JSON文件，然后在HTTP请求和脚本中使用来自数据文件的值。这些变量称为数据变量。要在Postman UI中使用它们，必须遵循与环境或全局变量相同的语法。使用相同的语法可以帮助您使用虚拟环境值在Postman内部测试单个请求。当你运行测试用例集，你不需要改变任何东西。
在点击下方蓝色的 Run按钮之前，可以先点击 箭头所指的 Preivew按钮先预览一下数据的格式是否正确。
代码语言：javascript复制//model:
public class Student implements Serializable{
private static final long serialVersionUID = -339516038496531943L;
private String sno;
private String name;
private String sex;
public String getSno() {
return sno;
}
public void setSno(String sno) {
this.sno = sno;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
}
//controller: (演示功能：通过接口将学号，姓名，性别添加到数据库中)
@RequestMapping(value = "/addstudent", method = RequestMethod.GET)
public int saveStudent(String sno,String name,String sex) {
Student student = new Student();
student.setSno(sno);
student.setName(name);
student.setSex(sex);
return this.studentService.add(student);
}
@RequestMapping(value = "/addstudent2", method = RequestMethod.POST)
public int saveStudent2(@RequestBody Student student) {
return this.studentService.add(student);
}实际在导入的时候，选择csv或者json文件都可以。以上仅仅是演示两种情况。 link： https://www.pianshen.com/article/8437624650/
demo数据1： 初始化表格json.json
[ {"sno":"006","name":"test11","sex":1}, {"sno":"007","name":"test12","sex":0}, {"sno":"008","name":"test13","sex":1}, {"sno":"009","name":"test14","sex":1}, {"sno":"010","name":"test15","sex":1}, {"sno":"011","name":"test16","sex":1}, {"sno":"012","name":"test17","sex":1}, {"sno":"013","name":"test18","sex":1}, {"sno":"014","name":"test19","sex":1}, {"sno":"015","name":"test20","sex":1}, {"sno":"016","name":"test21","sex":1}, {"sno":"017","name":"test22","sex":1}, {"sno":"018","name":"test23","sex":1}, {"sno":"019","name":"test24","sex":1}, {"sno":"020","name":"test25","sex":1} ]
demo数据2： 初始化表格.xlsx (第一行带上表头，即字段名称)
