jmeter编写java、Python代码连接查询mongodb

1、在编译工具中编写调试java或python代码

import com.mongodb.*;

public class mongoTest {
    public static void main(String[] args){
        try {
            MongoClientURI mongoURI = new MongoClientURI("mongodb://root:root***@192.168.2.10:27017/?authSource=admin");
            MongoClient mongoClient = new MongoClient(mongoURI);
            DB db = mongoClient.getDB("iot_eba_system");
            System.out.println("数据库连接成功");
            DBCollection dbCollection = db.getCollection("device_type");
            System.out.println("集合连接成功");
            BasicDBObject seleceObj = new BasicDBObject();
            seleceObj.put("device_group_id","20a60b49dc8bbaa5c3cf07db784");
            DBObject result = dbCollection.findOne(seleceObj);
            System.out.println(result.toString());
            System.out.println(result.get("_id"));
        } catch (Exception e) {
            System.err.println(e.getClass().getName() + ": " + e.getMessage());
        }
    }
}

# -*- encoding: utf-8 -*-
import pymongo
from pymongo import MongoClient
from bson.objectid import ObjectId

def mongoTest(device_group_id):

    # 进行连接
    client = pymongo.MongoClient("mongodb://root:root***@192.168.2.10:27017/admin")

    # 指定数据库
    db = client.iot_eba_system

    # 指定集合
    collection = db.device_type

    # 获取device_type表_id
    id = collection.find_one({"device_group_id":device_group_id}, {"_id":1})
    print(id)
    return id
    #  断开连接
    client.close()

if __name__ == '__main__':
    mongoTest("20a60b49dc8bbaa5c3cf07db784")

2、将java脚本导出为jar包，放入到指定目录；然后新建bat文件，录入以下脚本
d:
cd D:\yong.zhang\apache-jmeter-5.3\script
java -jar mongoTest.jar

如果是用Python编写的脚本，新建bat后录入以下脚本
python D:\python\worksapce\argrace_intelligentCommunityTest\func\mongo_test.py %1

3、新增OS Process Sampler
java

python

4、最后用正则表达式取返回值即可