一、jdbc请求

二、beanshell拼装json字符串

import java.util.ArrayList;
import java.util.Map;
import java.util.HashMap;
import com.alibaba.fastjson.JSONObject;
import com.alibaba.fastjson.JSONArray;

Map FinnalMap = new HashMap();
List units = new ArrayList();

FinnalMap.put("warehouseCode","111");
FinnalMap.put("companyCode","11");


ArrayList list = vars.getObject("User_sqlResult");
log.info(list.toString());
log.info("hello");

for(int i=0; i<list.size();i++){
	Map unit = new HashMap();
	order = list.get(i);
	log.info(order.get("SOREFERENCE1"));
	unit.put("orderCode",order.get("SOREFERENCE1"));