1、庫文件下載地址：http://files.cnblogs.com/files/xiaoxitest/MySQL_LoadRunner_libraries.zip

分別庫文件和代碼添加到Loadrunner bin目錄和include目錄下

2、vuser_init文件添加代碼：

#include?"Ptt_Mysql.h"??

#include?"mysql.h"??

#include?"mysql_com.h"??

#include?"mysql_time.h"??

#include?"mysql_version.h"??

#include?"typelib.h"??

#include?"my_list.h"??

#include?"my_alloc.h"??

#define?MYSQLSERVER?"172.16.1.220"??

#define?MYSQLUSERNAME?"dbuser"??

#define?MYSQLPASSWORD?"1qaz@wsx"??

#define?MYSQLDB?"sroa_lyt"??

#define?MYSQLPORT?"3309"??

char?chQuery[1024];??

int?statu=1;??

int?status=0;??

MYSQL?*Mconn;??

char?sql_query[256],?sql_sub_query[50];??

int?i=0,?res=0,?conn_fail=0,?conn_iter=0;??

char?response[50];//?to?go???

vuser_init()??

{??

????lr_load_dll?("libmysql.dll");??

????lr_start_transaction("mysql_conn");?//設(shè)置一個(gè)連接數(shù)據(jù)庫的事務(wù)??

????????/*------------------------------------------------------------------------*/??

????/*?Initialise?MySQL?*/??

????if(!(Mconn?=?mysql_init(NULL)))??

????{??

????????lr_message("Error?-1:?Cannot?initialize?MySQL?-?%s",?mysql_error(Mconn));??

????????//return?-1;??

????????statu?=?0;??

????????lr_end_transaction("mysql_conn",?LR_FAIL);?//初始化數(shù)據(jù)庫失敗判定事務(wù)失敗??

????}??

????????/*------------------------------------------------------------------------*/??

????do??

????{??

????????/*?Connect?to?database?*/??

????????if?(!mysql_real_connect(Mconn,?MYSQLSERVER,?MYSQLUSERNAME,?MYSQLPASSWORD,?MYSQLDB,?atoi(MYSQLPORT),?NULL,?0))??

????????{??

????????????conn_fail?=?-2;??

????????????conn_iter++;??

????????????sleep(100);??

????????}??

????????else??

????????????conn_fail?=?0;??

????}??

????while(conn_fail?<?0?&&?conn_iter?<?10);??

????if?(conn_fail?<?0)??

????{??

????????lr_message("Error?-2:?%s",?mysql_error(Mconn));??

????????//mysql_close(Mconn);??

????????//return?-2;??

????????statu?=?0;??

????????lr_end_transaction("mysql_conn",?LR_FAIL);?//連接數(shù)據(jù)庫失敗判定事務(wù)失敗??

????}??

????else??

????{??

????????//lr_message("MySql?-?Good?Connection");??

????????//mysql_close(Mconn);??

????????statu?=?1;??

????????lr_end_transaction("mysql_conn",?LR_PASS);?//連接數(shù)據(jù)庫成功，事務(wù)通過。??

????}??

????return?0;??

}?

3、Action文件添加代碼

Action()??

{??

????if(statu){?//成功連接數(shù)據(jù)庫后才進(jìn)行執(zhí)行sql的操作??

????????lr_start_transaction("mysql_select");??

????????sprintf(chQuery,?"SELECT?id,?lb,?title,?nr,?attachment_id,?attachment_name,?pic_name,?fbsj,?fbbm,?fbr,?vcount?FROM?sroa_lyt.oa_news;");//查詢論壇用戶??

????????//sprintf(chQuery,"UPDATE?lr_test?SET?password?=?"%s"?WHERE?username='tom'",lr_eval_string?("{pwd}"));??

????????/*?

????????sprintf(chQuery,"update?pre_ucenter_members?set?username='dd'?where?username='qq'?");//更改用戶名qq為dd?

????????sprintf(chQuery,"delete?from?pre_ucenter_members?ORDER?BY?uid?desc?LIMIT?1");//刪除最后添加的一條數(shù)據(jù)?

????????*/??

????????status?=?lr_mysql_query(Mconn,?chQuery);??

????????if(status!=0){?//判斷sql是否執(zhí)行成功??

????????????lr_end_transaction("mysql_select",LR_FAIL);??

????????}else{??

????????????lr_end_transaction("mysql_select",LR_PASS);??

????????}??

??

????????lr_start_transaction("mysql_insert");??

????????sprintf(chQuery,"insert?into?oa_news(id,?lb,?title,?nr,?attachment_id,?attachment_name,?pic_name,?fbsj,?fbbm,?fbr,?vcount)?values(9,9,'qq@qq.com','test','','','teste','',6,'test',0)");//插入數(shù)據(jù)??

????????status?=?lr_mysql_query(Mconn,?chQuery);??

????????if(status!=0){?//判斷sql是否執(zhí)行成功??

????????????lr_end_transaction("mysql_insert",LR_FAIL);??

????????}else{??

????????????lr_end_transaction("mysql_insert",LR_PASS);??

????????}??

????}???

????return?0;??

}??

4、vuser_end文件添加代碼：?

vuser_end()??

{??

????lr_mysql_disconnect(Mconn);?//關(guān)閉數(shù)據(jù)庫連接??

????return?0;??

}?

轉(zhuǎn)載于:https://www.cnblogs.com/wx170119/p/8682102.html

總結(jié)

以上是生活随笔為你收集整理的性能测试Loadrunner与Mysql的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。