批量请求-参数准备：查询表数据整理成一定的格式

private String getParam(String name){
    List<BaotouImportData> baotouImportData = hgzInvoiceApplyMapper.selectImportDataByName(name);
    String res = "";
    for (BaotouImportData bm : baotouImportData) {
        //<p>硅：硅钙合金 硅含量的测定 高氯酸脱水重量法YB/T 5312-2016</p> <p>钙：硅钙合金 钙含量的测定 EDTA滴定法YB/T 5313-2016</p> <p>磷：硅钙合金 磷含量的测定 磷钼蓝分光光度法YB/T 5315-2016</p>
        res = res+"<p>"+bm.getSampleName()+"："+bm.getDetect()+"</p>";
    }
    return res;
}


public List<BaotouImportDataVo> selectImportData() {
    List<String> names = hgzInvoiceApplyMapper.selectImportDataName();
    List<BaotouImportDataVo> res = new ArrayList<>();
    String[] strarr = new String[]{"300","300","400","500","500","600","700","800"};
    String[] disarr = new String[]{"6","6","7","8","9"};
    for (String name : names) {
        BaotouImportDataVo baotouImportDataVo = new BaotouImportDataVo();

        baotouImportDataVo.setCheckmallWaresName(name);
        baotouImportDataVo.setCheckmallWaresBrand("");
        baotouImportDataVo.setCheckmallWaresModel("");
        baotouImportDataVo.setCheckmallWaresPattern("委托检测");
        baotouImportDataVo.setCheckmallWaresFunctions("按照相应标准进行测试。如有其它要求，联系客服。");
        baotouImportDataVo.setWaresServiceBrief("按照相应标准进行测试。如有其它要求，联系客服。");

        String param = this.getParam(name);
        baotouImportDataVo.setWaresServiceParam(param);

        baotouImportDataVo.setWaresSampleRequirements("<p> 请电话咨询</p><p> </p>");
        baotouImportDataVo.setCheckmallWaresMethod("实验室根据检测项目自主选择");
        baotouImportDataVo.setCheckmallWaresEquipment("实验室根据检测项目自主选择");
        baotouImportDataVo.setIsFreeMail("0");
        baotouImportDataVo.setCheckmallWaresLogo("");
        baotouImportDataVo.setServiceCategorySuperId(2);
        baotouImportDataVo.setServiceCategoryId(2204080518127860L);






        List<Map<String,Object>> serviceProject = new ArrayList<>();

        Map<String,Object> map2 = new HashMap<>();
        map2.put("checkmallFirstRankName",name);
        //"secondRank":
            List<BaotouImportData> baotouImportData = hgzInvoiceApplyMapper.selectImportDataByName(name);
            List<Map<String,String>> secondRank = new ArrayList<>();
            for (BaotouImportData baotouImportDatum1 : baotouImportData) {
                Map<String,String> map1 = new HashMap<>();
                map1.put("checkmallSecondRankName",baotouImportDatum1.getSampleName());
                //取随机值
                Random ra =new Random();
                int i = ra.nextInt(7)+1;
                int j = ra.nextInt(4)+1;
                map1.put("price",strarr[i]);//几百到一千
                map1.put("serviceCycle","7");//周期：7
                map1.put("serviceUnitType","4");//次
                //取随机值
                map1.put("discountStatus",disarr[j]);//6-9
                secondRank.add(map1);
            }
        map2.put("secondRank",secondRank);

        serviceProject.add(map2);
        baotouImportDataVo.setServiceProject(serviceProject);
        res.add(baotouImportDataVo);
    }


    return res;
}

/**
 * importdata对象 baotou_import_data
 *
 * @author ruoyi
 * @date 2022-04-26
 */
@ApiModel("importdataTest")
@Data
public class BaotouImportDataVo
{
    private static final long serialVersionUID = 1L;

    /** $column.columnComment */
    @ApiModelProperty(value = "${column.columnComment}", dataType = "Integer")
    private String checkmallWaresName;

    /** 项目名称 */
    @ApiModelProperty(value = "项目名称", dataType = "String")
    private String checkmallWaresBrand;

    /** 样品名称 */
    @ApiModelProperty(value = "样品名称", dataType = "String")
    private String checkmallWaresModel;
    private String checkmallWaresPattern;

    /** 参考检测标准 */
    @ApiModelProperty(value = "参考检测标准", dataType = "String")
    private String checkmallWaresFunctions;
    private String waresServiceBrief;
    private String waresServiceParam;
    private String waresSampleRequirements;
    private String checkmallWaresMethod;
    private String checkmallWaresEquipment;
    private String isFreeMail;
    private String mallWaresStatus;
    private String checkmallWaresLogo;
    private Integer serviceCategorySuperId;
    private Long serviceCategoryId;
    private List<Map<String,Object>> serviceProject;






}

　　手动录入数据，改成批量提交，提高效率：

1、添加一遍数据，记录下请求接口与参数格式（F12--network）

2、使用postman带上参数请求该接口（准备以接口的方式录入数据）

3、准备参数两种方式

　　3.1 java代码方式获取excel中的数据，整理成请求的格式

　　3.2 使用工具将excel数据导入数据库，通过查询数据库的方式拿到数据，整理成请求的格式

4、postman批量请求接口