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

VC ODBC Á¬½Ó MYSQL δËì

#include <WinSock2.h>
#include <Windows.h>
#include <tchar.h>

#include <mysql.h>

#include <sql.h>
#include <sqlext.h>
#include <sqltypes.h>

#include <iostream>

using namespace std;

int _tmain(int argc, _TCHAR* argv[])
{
SQLHENV sql_hEvn = 0;
SQLHDBC sql_hDBC = 0;
SQLHSTMT sql_hStmt = 0;

SQLWCHAR szDNS[1024] = {0};
SQLSMALLINT nSize = 0;

SQLRETURN sqlRet = 
SQLAllocHandle(SQL_HANDLE_ENV,
SQL_NULL_HANDLE,
&sql_hEvn);
sqlRet = 
SQLSetEnvAttr(sql_hEvn,
SQL_ATTR_ODBC_VERSION,
(void*)SQL_OV_ODBC3,
0);
sqlRet = 
SQLAllocHandle(SQL_HANDLE_DBC,
sql_hEvn,
&sql_hDBC);

// if 0 - use SQLDriverConnect
// if 1 - use SQLConnect
#if 1
sqlRet = 
SQLConnect(sql_hDBC,
(SQLWCHAR*)"wzdftpd",
14,//SQL_NTS,
(SQLWCHAR*)"root",
8,//SQL_NTS,
(SQLWCHAR*)"root",
8//SQL_NTS
);

#else
sqlRet =
SQLDriverConnect(sql_hDBC,
0,
(SQLWCHAR*)"DSN=wzdftpd;UID=root;PWD=root;",
SQL_NTS,
szDNS,
1024,
&nSize,
SQL_DRIVER_COMPLETE);
#endif

if (


Ïà¹ØÎÊ´ð£º

ÔõôÔÚeclipseÏÂÏòmysql²åÈë±äÁ¿°¡ - Java / JavaÏà¹Ø

String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡­¡­µ½µ×¸Ãզд°¡

Íò·Ö¸Ðл£¡

String SQL=&q ......

ÈçºÎʹÓÃMySQL - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......

MysqlȨÏÞ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

MysqlÖÐÊÇ·ñÓÐÕâÑùµÄȨÏÞÉèÖÃ
ÓÐÒ»¸öÁд洢µÄÊÇÊÖ»úºÅ£¬Ä³Ò»Óû§µÄȨÏÞÔÚ¶ÁÈ¡µÄʱºòÖ»ÏÔʾǰ¼¸Î»£¬ºó¼¸Î»ÓÃÆäËû×Ö·ûÀýÈç*´úÌæ¡£ÀýÈç123456¶Á³öÀ´ÊÇ123***
£¿
¿ÉÒÔ×ö¸öÊÓͼ£¬È»ºó²»¸øÕâ¸öÕ˺űíµÄȨÏÞ£¬½ö¸øÕâ¸öVI ......

MYSQLµ÷¶ÈµÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ


3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......

ASPÁ¬½ÓMySQLÊý¾Ý¿âµÄÎÊÌâ

ͨ¹ýODBCÁ¬½ÓMySQLÊý¾Ý¿â£¬Á¬½Ó³É¹¦£¬µ«²»ÄܲéѯÊý¾Ý£¬²»ÖªµÀΪʲô
'Á¬½ÓmysqlÊý¾Ý¿â
str = "dsn=test;driver={MySQL odbc 3.51 Driver};server=localhost;port=3306;uid=root;pwd=;database=officesyst ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ