???????????????д?????????????????????????????Mysql????????????????????????????????Σ?????????????д?????
?????????????????Mysql ????????LoadRunner??libmysql.dll and ?????????LoadRunner????mysq???????
????Step1??Mysql????????????????????????Mysq??????????????
????IP??192.168.1.100
????????????root
???????????123456
??????????????t3db
?????????????3306
?????????????????????????
????Step2??LoadRunner???????mysql???
???????????????????????????

 

int rc;
int db_connection;
char *server = "192.168.1.100";   // ??????ip???
char *user = "root";              // ?????????????
char *password = "123456";        // ????
char *database = "t3db";          // ?????????
int port = 3306;                  // ??????
int unix_socket = NULL;
int flags = 0;
char** result_row;
int query_result;
char szSql[256];
int MySqlInit()
{
rc = lr_load_dll("libmysql.dll");
db_connection = mysql_init(NULL);
if (db_connection == NULL)
{
lr_error_message("Insufficient memory");
lr_abort();
}
if(rc!=0)
{
lr_error_message("Load MySql.dll Error!");
lr_abort();
}
rc = mysql_real_connect(db_connection??server?? user?? password?? database?? port?? unix_socket?? flags);
if(rc == NULL)
{
lr_error_message("connect mysql error! %s"??mysql_error(db_connection));
mysql_close(db_connection);
lr_abort();
}
return rc;
}
int MySqlUnit()
{
// ???MySQL???
mysql_close(db_connection);
return 0;
}
int InsertValue(char* query)
{
rc = mysql_query(db_connection??query);
if (rc != 0)
{
lr_error_message("%s"?? mysql_error(db_connection));
}
query = NULL;
return rc;
}
int MySqlQuery(char* szSql)
{
rc = mysql_query(db_connection??szSql);
if(rc != 0)
{
lr_error_message("%s"??lr_eval_string("?"));
lr_error_message("%s"?? mysql_error(db_connection));
szSql = NULL;
return -1;
}
query_result = mysql_use_result(db_connection);
if (query_result == NULL)
{
lr_error_message("%s"?? mysql_error(db_connection));
mysql_free_result(query_result);
szSql = NULL;
return -2;
}
result_row = (char **)mysql_fetch_row(query_result);
if (result_row == NULL)
{
lr_error_message("Did not expect the result set to be empty");
mysql_free_result(query_result);
szSql = NULL;
return -3;
}
mysql_free_result(query_result);
szSql = NULL;
return 0;
}