Jmeter進(jìn)階三:把數(shù)據(jù)庫的結(jié)果處理后保存到本地的文件

import java.io.BufferedWriter;

import java.io.FileWriter;

import java.io.Writer;

import java.util.Random;

import java.util.Arrays;

FileWriter fstream = new FileWriter("D:\\Jmeter\\測試集_rita\\添加產(chǎn)品.csv",false);?

// 1. 設(shè)置為true時,從第2行開始插入數(shù)據(jù);設(shè)置為false時,從第一行開始插入數(shù)據(jù)。

// 2. 設(shè)置為true時,后面運(yùn)行時不會覆蓋原先的數(shù)據(jù);設(shè)置為false時,會覆蓋原先的數(shù)據(jù)。

BufferedWriter out = new BufferedWriter(fstream);

Object result=vars.getObject("pro_res");

log.info("結(jié)果是"+ result);

int len = result.size();

log.info("個數(shù)是"+ len);

String p_ids="";

String p_types="";

String p_grades="";

String p_commerce_types="";

String p_air_conditioning_types="";

for(int i=0;i<len;i++){

????String p_id= result.get(i).get("product_id").toString();

????String p_type=result.get(i).get("product_types").toString();

????String p_type2 = p_type.replace(","," ");? //寫入文件時是以“,”區(qū)分單元格的,所以得替換原先的符號

????String[] p_type3 = p_type2.split(" ");

????String p_grade= result.get(i).get("grades").toString();

????String p_grade2=p_grade.replace(","," ");

????String[] p_grade3 = p_grade2.split(" ");

????String p_commerce_type= result.get(i).get("commerce_types").toString();

????String p_commerce_type2=p_commerce_type.replace(","," ");

????String[] p_commerce_type3 = p_commerce_type2.split(" ");

????String p_air_conditioning_type=result.get(i).get("air_conditioning_types").toString();

????String p_air_conditioning_type2=p_air_conditioning_type.replace(","," ");

????String[] p_air_conditioning_type3 = p_air_conditioning_type2.split(" ");


?????log.info("p_ids為" + p_id);

????log.info("p_types為" + p_type2);

????log.info("p_grades為" + p_grade2);

????log.info("p_commerce_types為" + p_commerce_type2);

????log.info("p_air_conditioning_types為" + p_air_conditioning_type2);

????log.info("長度為" + p_type3.length);

????log.info("長度為" + p_grade3.length);

????log.info("長度為" + p_commerce_type3.length);

????log.info("長度為" + p_air_conditioning_type3.length);


? ? Random random = new Random();

????int i = random.nextInt(p_type3.length);

????int j = random.nextInt(p_grade3.length);

????int k = random.nextInt(p_commerce_type3.length);

????int l = random.nextInt(p_air_conditioning_type3.length);


????out.write(p_id + ",");

????if (p_type3.length == 1){

????????out.write(null + ","); //當(dāng)屬性為空時,需要傳null

????}else{

????????out.write(p_type3[i].toString() + ",");

????}

????if (p_grade3.length == 1){

????????out.write(null + ",");

????}else{

????????out.write(p_grade3[j].toString() + ",");

????}

????if (p_commerce_type3.length == 1){

????????out.write(null + ",");

????}else{

????????out.write(p_commerce_type3[k].toString() + ",");

????}

????if (p_air_conditioning_type3.length == 1){

????????out.write(null + ",");

????}else{

????????out.write(p_air_conditioning_type3[l].toString() + ",");

????}

}

out.close();

fstream.close();

最后編輯于
?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者
【社區(qū)內(nèi)容提示】社區(qū)部分內(nèi)容疑似由AI輔助生成,瀏覽時請結(jié)合常識與多方信息審慎甄別。
平臺聲明:文章內(nèi)容(如有圖片或視頻亦包括在內(nèi))由作者上傳并發(fā)布,文章內(nèi)容僅代表作者本人觀點,簡書系信息發(fā)布平臺,僅提供信息存儲服務(wù)。

友情鏈接更多精彩內(nèi)容