如何在JMeter中运行Java代码并将vairables从Java代码传递到JMeter脚本

Question

我正在通过添加Beanshell预处理器读取xlsx文件。当我在Eclispe中运行代码时，它工作得很好。

import java.io.File;
import java.io.FileInputStream;

import java.io.IOException;
import java.util.Iterator;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class url {

    public static void main(String[] args) throws IOException {

        FileInputStream file=new FileInputStream(new File("C:\\temp\\project.xlsx"));

        XSSFWorkbook workbook=new XSSFWorkbook(file);
        XSSFSheet sheet=workbook.getSheetAt(0);
        Iterator<Row>rowIterator=sheet.iterator();

        int count=1;
        while(rowIterator.hasNext()){
            Row row=rowIterator.next();
            Iterator<Cell> cellIterator=row.cellIterator();
            while(cellIterator.hasNext()){
                Cell cell=cellIterator.next();
                String TextInCell=cell.toString();
                String cellContent1="Cricket";
                String cellContent2="Football";
                String cellContent3="F1";
                String cellContent4="Badminton";
                String cellContent5="Misslenous";

                if(TextInCell.contains(cellContent1)){
                    String var=cell.getRichStringCellValue().toString();
                    String Category = cellContent1;

                }else if(TextInCell.contains(cellContent2)){
                    String var=cell.getRichStringCellValue().toString();
                    String Category = cellContent2;

                }else if(TextInCell.contains(cellContent3)){
                    String var=cell.getRichStringCellValue().toString();
                    String Category = cellContent3;

                }else if(TextInCell.contains(cellContent4)){

                    String var=cell.getRichStringCellValue().toString();
                    String Category = cellContent4;
                    System.out.println(var + "----"+Category );

                }else{
                    String var=cell.getRichStringCellValue().toString();
                    String Category = cellContent5;

                }

            }

        }

    }


}

Answer 1

>

Beanshell不是非常Java化的，您需要修改代码以匹配Beanshell约定：

• 删除“class”和“main”方法
• 从迭代器
中删除
• 从迭代器
中删除
• 显式强制转换对象，如Row Row=(Row)rowiterator.next()；