Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ODBC·ÃÎÊMYSQLÄÚ´æÐ¹Â¶ - VC/MFC / »ù´¡Àà

ÎÒͨ¹ý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));


Ïà¹ØÎÊ´ð£º

mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢

ÎÒÒѾ­°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......

mysql×Ö¶ÎÌáÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......

ÈçºÎÔÚMySQL ServerÖж¨Ê±²åÈëÊý¾Ý - Java / Web ¿ª·¢

ÎÒÏÖÔÚÏëÓÃJSPʵÏÖQQÓÊÏäÀïµÄ¶¨Ê±·¢ËÍ£¬ÎÒÏëͨ¹ýÊý¾Ý¿â½øÐж¨Ê±²åÈëÊý¾Ý¡£
µ«²»ÖªµÀÈçºÎʵÏÖ£¬»òÕß´ó¼ÒÓиüºÃµÄ·½·¨£¬²»Ò»¶¨ËµÊÇÊý¾Ý¿â¡£
Çë´ó¼Ò¸øµãÒâ¼û£¬°ÝлÀ²¡£

quataz¶¨Ê±Æ÷×é¼þÊǸöºÜºÃµÄ½â¾ö·½°¸¡£

È ......

mysqlÁ¬½ÓÎÊÌâ - VB / Êý¾Ý¿â(°üº¬´òÓ¡£¬°²×°£¬±¨±í)

×î½ü³öÏÖÒ»¸öºÜÆæ¹ÖµÄÎÊÌ⣬ÓÃADOÁ¬½ÓMYSQL£¬½«Á¬½ÓOPENµÄʱºò£¬Èç¹ûMYSQLÆô¶¯Ê±¾ÍÁ¬½Ó´íÎó£¬Í¬Ê±×Ô¶¯¹Ø±ÕMYSQL·þÎñ£»ÈôMYSQLûÓÐÆô¶¯¾Í¿ÉÒÔÕý³£OPEN¡£
Ò²¾ÍÊÇÿÁ½´ÎÔËÐбØÈ»»á³ö´íÒ»´Î£¬µ«Ã¿Á½´ÎÔËÐÐÒ²±ØÈ»³É¹¦Ò»´ ......

mysql Óï¾ä´íÎó - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

CREATE PROCEDURE dowhile()
BEGIN
  DECLARE v1 INT DEFAULT 5;
  WHILE v1 > 0 DO
  SET v1 = v1 - 1;
  END WHILE;
END
ÎÒÔËÐÐmysql°ïÖúÀïÃæµÄ³ÌÐò»á±¨´í£¬²»ÖªµÀΪʲô£¬Çë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ