一、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"));