LoadRunner操作Mysql实例:C语言篇
上一篇 /
下一篇 2011-12-16 14:27:06
/ 个人分类:Linux
在 Richard Bishop 大师网站上看到LoadRunner操作Mysql的动态链接库。 操作起来也非常简单,特此记录:
x
d+l_bb:G!U01、 下载压缩包,解压到LoadRunner脚本目录。51Testing软件测试网0ZU?xoF L;I
2、 DLL直接放脚本根目录,头文件新建include文件夹中。51Testing软件测试网)`/G-OiQDw
.\include下的文件: |
mysql.h、mysql_com.h、mysql_time.h、mysql_version.h、my_alloc.h、my_list.h、Ptt_MySql.h、typelib.h |
.\放置动态链接库文件: |
libmysql.dll51Testing软件测试网*x"J/D|L
3、 编写LoadRunner脚本如下:51Testing软件测试网)gs[k.KBY #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(){ char chQuery[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); } 这个示例,我想不必须多解释吧。只要修改定义的Mysql连接属性,连接到Mysql数据库只可在LoadRunner中显示结果…… mp%xi6}-YB0 |
51Testing软件测试网-gP8q#i3|'?X,y
收藏
举报
TAG: