Jmeter-数据库操作

1、下载数据库驱动：postgresql-42.3.4，放到apache-jmeter的lib目录下；

2、添加数据库连接配置元件：JDBC Connection Configuration；

Variable Name for created pool：输入引用的数据库变量；

Dadabase URL：填写pg数据库ip、端口、数据库，dbc:postgresql://ip:5432/dpi-gnss；

JDBC Driver class：选择org.postgresql.Driver；

username/password：输入登录数据库账号和密码；

3、Variable Name of Pool declared in JDBC Connection Configuration：输入引用的数据库变量；

更新插入sql，Query Type选择Update Statement；

 

附1：随机生成11位手机号码：

String[] FirstThreeNumber = {"134","135","136","137","138","139","147","150","152","157","158","159","172","178","182","183","184","187","188","198","130","131","132","145","155","156","166","171","175","176","185","186","166","133","149","153","173","177","180","181","189","199"};

//随机获取前三位手机号的index

int n= (int)(Math.random() * FirstThreeNumber.length);

//获取手机前三位

String yy = FirstThreeNumber[n];

//循环获取手机号后8位

for(int i = 0; i < 8; i++){

    int x = (int)(Math.random() * 9);

    yy = yy + x;

};

vars.put("mobile", yy);

附2：获取当前时间精确到毫秒：

import java.text.SimpleDateFormat;

SimpleDateFormat sdf= new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");
String time =sdf.format(System.currentTimeMillis());
//log.info("time：" + time);
vars.put("time", time);