（十一）Loadrunner编写mysql增删改查脚本

1、库文件下载

链接：https://pan.baidu.com/s/1cJz-eofNsDrPea2m-14Q1Q

提取码：towe

将下载的文件分别添加到Loadrunner bin目录和include目录下

 

2、编写脚本

1）Vuser_init脚本

#define MYSQLSERVER "192.168.68.130" #define MYSQLUSERNAME "root" #define MYSQLPASSWORD "123456" #define MYSQLDB "wlsql" #define MYSQLPORT "3306" #include "Ptt_Mysql.h" vuser_init() { return 0; }

2）Action脚本

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, "select * from student; ");//查询student表数据 lr_mysql_query(Mconn, sqQuery);//执行sql语句     mysql_query(Mconn,lr_eval_string("SET NAMES gbk")); //解决中文乱码问题 sprintf(sqQuery,"insert into student (StuName,sex,Birth,Department,Address) values ('wl','女',1989,'计算机','湖北武汉');");//插入数据 lr_mysql_query(Mconn, sqQuery); sprintf(sqQuery,"update student t set t.sex = '男' where t.stuname = 'wl'; ");//更改性别 lr_mysql_query(Mconn, sqQuery); sprintf(sqQuery,"delete from student where stuname = 'wl';");//删除 lr_mysql_query(Mconn, sqQuery); //断开数据库连接 lr_mysql_disconnect(Mconn); return 0; }

3、参考脚本

链接：https://pan.baidu.com/s/1HS0kUWft6VKeXwWe_V0o7g

提取码：l8jh

说明：loadrunner 编写数据库脚本比较简单，都是套用格式，会写即可。