【loadrunner】连接mysql并进行操作

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

Mconn = lr_mysql_connect(MYSQLSERVER, MYSQLUSERNAME, MYSQLPASSWORD, MYSQLDB, atoi(MYSQLPORT));//创建连接


sprintf(sqQuery, "CREATE TABLE test (id int,uname VARCHAR(40),addr VARCHAR(40));");
    
lr_mysql_query(Mconn, sqQuery);

sprintf(sqQuery, "SELECT * FROM test; ");//查询test1表数据
lr_mysql_query(Mconn, sqQuery);//执行sql语句

sprintf(sqQuery,"INSERT INTO test VALUES(1,'a','11111');");//插入数据
lr_mysql_query(Mconn, sqQuery);


sprintf(sqQuery,"INSERT INTO test VALUES(2,'bb','222222');");//插入数据
lr_mysql_query(Mconn, sqQuery);

sprintf(sqQuery,"UPDATE test SET uname='aaa' WHERE id=1; ");//更改用户名aa为aaa
lr_mysql_query(Mconn, sqQuery);

sprintf(sqQuery,"DELETE FROM test WHERE id=2;");//删除
lr_mysql_query(Mconn, sqQuery);

//断开数据库连接
lr_mysql_disconnect(Mconn);
}