ÎÒͨ¹ýODBC·ÃÎÊMYSQL,µ«ÊÇÿ´ÎÖ´Ðж¼»áÔö´ó100K×óÓÒ£¬Òª1´ÎÁ½´ÎÒ²¾ÍÎÞËùνÁË£¬µ«ÊǹؼüÊÇ1ÃëÖ´ÐÐ2-3´Î£¬Ö´ÐÐ1ÌìÏëÏë¶¼¸Ðµ½Ðĺ®ÁË£¬ËÄܰïæ¿´ÏÂÄĶùй¶µÄ£¬Ôõô¸Ä·¨
C/C++ code:
#define LOGIN_TIMEOUT 30
#define MAXBUFLEN 255
//global
SQLHENV henv = NULL;
SQLHDBC hdbc = NULL;
SQLHSTMT hstmt = NULL;
SQLRETURN result;
void DBConnect(HWND hwnd)
{
SQLCHAR ConnStrIn[MAXBUFLEN] = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=127.0.0.1;UID=root;PWD=;DATABASE=test;CharSet=gbk;";
SQLCHAR ConnStrOut[MAXBUFLEN];
result = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
result = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);
result = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
result = SQLSetConnectAttr(hdbc, SQL_LOGIN_TIMEOUT, (void*)LOGIN_TIMEOUT, 0);
result = SQLDriverConnect(hdbc,NULL,
ConnStrIn,SQL_NTS,
ConnStrOut,MAXBUFLEN,
(SQLSMALLINT *)0,SQL_DRIVER_NOPROMPT);
if(SQL_ERROR==result)
{
PostQuitMessage(0);
return;
}
}
void DBDisconnect(HWND hwnd)
{
SQLFreeStmt(hstmt,SQL_CLOSE);
SQLDisconnect(hdbc);
SQLFreeHandle(SQL_HANDLE_DBC,hdbc);
SQLFreeHandle(SQL_HANDLE_ENV,henv);
}
void DoNotSelectJob(HWND hwnd)
{
TCHAR buff[256];
ZeroMemory(buff,sizeof(buff)/sizeof(TCHAR));
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......