LoadRunner操作Mysql实例：C语言篇

上一篇 / 下一篇 2011-11-21 14:50:24 / 个人分类：性能测试

查看( 884 ) / 评论( 0 ) / 评分( 0 / 0 )

操作起来也非常简单，特此记录：

1、下载压缩包，解压到LoadRunner脚本目录。

2、 DLL直接放脚本根目录，头文件新建include文件夹中。

.\include下的文件:

mysql.h、mysql_com.h、mysql_time.h、mysql_version.h、my_alloc.h、my_list.h、Ptt_MySql.h、typelib.h

.\放置动态链接库文件：

libmysql.dll

3、编写LoadRunner脚本如下：

#include "Ptt_Mysql.h"

#define MYSQLSERVER "192.168.10.31"
#define MYSQLUSERNAME "higkoo"
#define MYSQLPASSWORD "123456"
#define MYSQLDB    "mysql"
#define MYSQLPORT 3306

MYSQL*Mconn;

vuser_init(){
   lr_load_dll("libmysql.dll");
   Mconn=lr_mysql_connect(MYSQLSERVER,MYSQLUSERNAME,MYSQLPASSWORD,MYSQLDB,MYSQLPORT);
}

Action(){
       charchQuery[128];

   sprintf(chQuery,"SELECT `Host`, `User`, `Password` FROM mysql.`user` order by Password desc limit 2;");

   lr_mysql_query(Mconn,chQuery);

   lr_save_string(row[0][0].cell,"Host");
   lr_save_string(row[1][0].cell,"User");
   lr_save_string(row[2][0].cell,"Password");

   lr_output_message(lr_eval_string("Host: {Host}; User: {User}; Password:{Password}"));

   lr_save_string(row[0][1].cell,"Host");
   lr_save_string(row[1][1].cell,"User");
   lr_save_string(row[2][1].cell,"Password");

   lr_output_message(lr_eval_string("Host: {Host}; User: {User}; Password:{Password}"));
}

vuser_end(){
   lr_mysql_disconnect(Mconn);
}