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);