Jmeter将从数据库中获取到的数据写入csv中（一列）

1.添加一个数据库请求；

2.添加一个JSR223 Sampler（推荐，可以调试）

import java.io.File;
import java.io.FileWriter;
import java.io.BufferedReader;
import java.io.IOException;
import org.apache.jmeter.util.JMeterUtils;
//log.info("第五步LLLLLLLLLLLLLLLLLLLLLLLLLLLLL======================================");
String path = "D:UnionIP.csv";
File file = new File(path);
FileWriter fstream = new FileWriter(file,true);
BufferedWriter out = new BufferedWriter(fstream);
//log.info("第五步LLLLLLLLLLLLLLLLLLLLLLLLLLLLL======================================");
String num = vars.get("IP_#");
//log.info(num + "======================================");
int sum = Integer.parseInt(num);
//log.info("第七步LLLLLLLLLLLLLLLLLLLLLLLLLLLLL======================================");
for(int i=1;i<= sum;i++){
//log.info("第八步LLLLLLLLLLLLLLLLLLLLLLLLLLLLL======================================");	
       str=vars.get("IP_"+i);
	//将数据写入磁盘文件中
	log.info("第九步LLLLLLLLLLLLLLLLLLLLLLLLLLLLL======================================");
	out.write(str);
	out.write("\r\n");
//log.info("第13步LLLLLLLLLLLLLLLLLLLLLLLLLLLLL======================================");  
        }
        out.close();
        fstream.close();