JMeter快速造数之数据导入导出

导入数据

• 输入表格格式如下

• 创建CSV Data Set Config

• 在Body Data中调用

{
"username": "${email}",
"password": "123456",
"client_id": "00bb9dbfc67439a5d42e0e19f448c7de310df4c7fcde6feb5bd95c6fac5a5afc",
"scope": "all",
"react_app_request": true
}

导出数据

• 创建BeanShell PostProcessor
  • 一般数据来源是接口的response内容

import java.io.File;
import java.io.FileWriter;
import java.io.IOException;

import com.csvreader.CsvReader;
import com.csvreader.CsvWriter;
import org.json.JSONObject;
import org.json.JSONArray;

String response=prev.getResponseDataAsString();//取出接口的返回消息
JSONObject jsonstring=new JSONObject(response);//放进json对象里

String token=jsonstring.getString("refresh_token");
String email=jsonstring.getJSONObject("profile").getString("email");
String type=jsonstring.getString("user_type");
String school=jsonstring.getJSONObject("profile").getJSONObject("school").getString("name");
token = "Bearer " + token


String outputFile = "E:/Software/JMeter/tokenInfo.csv";
// before we open the file check to see if it already exists
boolean alreadyExists = new File(outputFile).exists();

try {
// use FileWriter constructor that specifies open for appending
CsvWriter csvOutput = new CsvWriter(new FileWriter(outputFile, true), ',');

// if the file didn't already exist then we need to write out the header line
if (!alreadyExists)
{
csvOutput.write("Email");
csvOutput.write("Token");
csvOutput.write("Type");
csvOutput.write("School");
csvOutput.endRecord();
}
// else assume that the file already has the correct header line

// write out a few records
csvOutput.write(email);
csvOutput.write(token);
csvOutput.write(type);
csvOutput.write(school);
csvOutput.endRecord();

csvOutput.close();
} catch (IOException e) {
e.printStackTrace();
}

备注：可以创建一个Debug PostProcessor进行调试代码

原文地址：https://blog.csdn.net/u010378984/article/details/143512040

免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！