1、下载要用到的文件,解压,并添加到LoadRunner的安装目录中。
2、在globals.h中添加
#define MYSQLSERVER "192.168.70.134"
#define MYSQLUSERNAME "devuser"
#define MYSQLPASSWORD "123456"
#define MYSQLDB "my_db"
#define MYSQLPORT "3307"
#include "Ptt_Mysql.h"
3、加载dll
vuser_init()
{
lr_load_dll("libmySQL.dll");
return 0;
}
4、action
Action()
{
char chQuery[128];//查询语句字符串
MYSQL *Mconn;//数据库连接
Mconn = lr_mysql_connect(MYSQLSERVER, MYSQLUSERNAME,MYSQLPASSWORD, MYSQLDB,atoi(MYSQLPORT));
//得到chQuery查询sql语句
sprintf(chQuery, "SELECT t_user.user_id,t_user.user_name,t_user.user_password,t_user.`status` FROM t_user limit 3;");
//执行查询操作,在输出中打印语句,调用dll中的lr_mysql_query方法执行语句
lr_mysql_query(Mconn, chQuery);
//把结果保存到lr的参数中
lr_save_string(row[0][0].cell, "user_id");
lr_save_string(row[1][0].cell, "sN_NAME");
lr_save_string(row[2][0].cell, "sN_REGIONKEY");
//取得参数
lr_output_message(lr_eval_string("=============={user_id}"));
//断开数据库连接
lr_mysql_disconnect(Mconn);
return 0;
}
5、写成函数,以后直接调用
/*********************************************
Action()
{
//删除指定参数的数据
char deleteStatement[128];//删除语句
//条件
lr_save_string("NP000000000000008330","user_id");
//拼接删除语句
sprintf(deleteStatement, "delete from t_user where user_id ='%s';",lr_eval_string("{user_id}"));
//log
lr_log_message ("%s", deleteStatement);
//调用方法执行delete语句
del_data(deleteStatement);
}
**********************************************/
int del_data(char chQuery[128]){
//char chQuery[128];//查询语句字符串
MYSQL *Mconn;//数据库连接
Mconn = lr_mysql_connect(MYSQLSERVER, MYSQLUSERNAME,MYSQLPASSWORD, MYSQLDB,atoi(MYSQLPORT));
//得到chQuery查询sql语句
//sprintf(chQuery, "delete FROM t_user ;");
//执行查询操作,在输出中打印语句,调用dll中的lr_mysql_query方法执行语句
lr_mysql_query(Mconn, chQuery);
//
lr_output_message(lr_eval_string("####################执行完成"));
//断开数据库连接
lr_mysql_disconnect(Mconn);
}