JMeter 如何用数据库查询结果作为java测试入参

2022-03-01 本文已影响0人 clicsug

在自动化测试时，经常会用到上一步接口（或sql查询）的结果作为下一个测试节点的入参，那使用jmeter做测试时如何传参呢?
在上一篇建好的测试计划的基础上，我们来配置参数
首先在jdbc request中配置好sql脚本入出参变量：

image.png

建一个java测试类，接收两个参数 state和suggest_operate

package com.jd.xc.jmeter;
import com.sun.org.apache.xpath.internal.operations.Bool;
import org.apache.jmeter.config.Argument;
import org.apache.jmeter.config.Arguments;
import org.apache.jmeter.protocol.java.sampler.JavaSamplerClient;
import org.apache.jmeter.protocol.java.sampler.JavaSamplerContext;
import org.apache.jmeter.samplers.SampleResult;
public class QlBlockerTest implements JavaSamplerClient {
    private Integer state;
    private String suggest;
    public void setupTest(JavaSamplerContext javaSamplerContext){ }

    public SampleResult runTest(JavaSamplerContext javaSamplerContext) {
        SampleResult sampleResult = new SampleResult();
        sampleResult.setSampleLabel("qlBlocker");
        state = javaSamplerContext.getIntParameter("state");
        suggest = javaSamplerContext.getParameter("suggest_operate");
        sampleResult.sampleStart();
        System.out.println("运单当前状态"+state+" 拦截结果"+suggest);
        sampleResult.setSamplerData("运单当前状态"+state+" 拦截结果"+suggest);
        sampleResult.setDataType(SampleResult.TEXT);
        sampleResult.setResponseMessageOK();
        sampleResult.setResponseCodeOK();
        sampleResult.sampleEnd();
        sampleResult.setSuccessful(Boolean.TRUE);
        sampleResult.setResponseData("运单当前状态"+state+" 拦截结果"+suggest,"UTF-8");
        return sampleResult;
    }
    public void teardownTest(JavaSamplerContext javaSamplerContext) {
    }
    public Arguments getDefaultParameters() {
        Arguments params = new Arguments();
        params.addArgument("state","4");
        params.addArgument("suggest","pass");
        params.addArgument("suggest_operate","passOk");
        return params;
    }
}

将java类打成jar包jmeterTestCase-1.0-SNAPSHOT.jar，然后将jar包放到jmeter的\lib\ext路径下，重启jmeter
新建java请求取样器如下图所示，在下拉框中选中我们创建的java类