1、下载loadrunner连接mysql时需要的库,解压后文件分别放到loadrunner安装目录的bin、incloud文件夹下
下载地址:http://download.csdn.net/download/x00yan00/10008235
2、在loadrunner脚本中编写如下:
#define MYSQLSERVER "192.168.1.110"
#define MYSQLUSERNAME "root"
#define MYSQLPASSWORD "123456"
#define MYSQLDB "test"
#define MYSQLPORT "3306"
#include "Ptt_Mysql.h"
vuser_init()
{
}
Action()
{
char sqQuery[512]; //定义一个字符数组存储查询的sql语句
int i;
MYSQL *Mconn; //mysql连接字符串
lr_load_dll("libmysql.dll");