|
近期从网上看到一段连接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 |
|