51Testing软件测试论坛

标题: LoadRunner连接mysql的一段代码 [打印本页]

作者: 过客一个 时间: 2009-9-7 15:14
标题: LoadRunner连接mysql的一段代码
近期从网上看到一段连接mysql的代码，对其中的mysql.h头文件中应该包含哪些东西不太懂，大家发表一下意见。。。看看应该包含哪些东西？代码如下：：：
#include "stdafx.h"
#include "MonitorTest.h"
#include "stdlib.h"
#include "winsock.h"
#include "mysql.h"
#include "stdio.h"

//stdio.h头文件必须要放在stdafx.h头文件后

MYSQL conn;
MYSQL_RES *p_res_ptr=NULL;
MYSQL_ROW sqlrows;

BOOL APIENTRY DllMain( HANDLE hModule,
                     DWORD  ul_reason_for_call,
                     LPVOID lpReserved
   )
{
switch (ul_reason_for_call)
{
      case DLL_PROCESS_ATTACH:
      case DLL_THREAD_ATTACH:
      case DLL_THREAD_DETACH:
      case DLL_PROCESS_DETACH:
      break;
}
return TRUE;
}

int init_mysql_connection(char *str_server,char *str_username,char *str_pwd,char *str_db)
{

mysql_init(&conn);
printf("\nSuccess to initate MySQL connection\n");
if (!mysql_real_connect(&conn,str_server,str_username,str_pwd,str_db,0,NULL,0))
{
      printf( "Failed to connect to MySQL: Error: %s\n", mysql_error(&conn));
      return 1;
}
else
{
      printf("\nLogged on to %s sucessfully\n",str_server);
      return 0;
}

}
int close_mysql_connection()
{
mysql_free_result(p_res_ptr);
printf("\nClose connection");
mysql_close(&conn);
return 0;
}

int get_mysql_query_data(char *str_query,char *str_data)
{
mysql_real_query(&conn, str_query, (UINT)strlen(str_query));
MYSQL_RES * res ;
MYSQL_ROW row;
res = mysql_use_result( &conn ) ;
row = mysql_fetch_row( res );
strcpy(str_data,row[1]);
mysql_free_result(res);
return 0;

}//此函数的参数str_query，查询后的结果必须唯一，主要用来查看show status的变量值

//////////////////////////////////////////////////////////////////////////////////

MonitorTest.def

LIBRARY    "MonitorTest"
DEscrīptION  'MonitorTest Windows Dynamic Link Library'

EXPORTS
init_mysql_connection @1
close_mysql_connection  @2
get_mysql_query_data @3

欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/)