MYSQL*Mconn;在Richard Bishop大师网站上看到LoadRunner操作Mysql的动态链接库。 操作起来也非常简单,特此记录: 1、 下载压缩包,解压到LoadRunner脚本目录。 2、 DLL直接放脚本根目录,头文件新建include文件夹中。
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); } 这个示例,我想不必须多解释吧。只要修改定义的Mysql连接属性,连接到Mysql数据库只可在LoadRunner中显示结果…… |
|