（十一）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 编写数据库脚本比较简单，都是套用格式，会写即可。