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

ÇóMFCͨ¹ýODBCÁ¬½ÓMYSQLÀý×Ó

RT

ÒýÓÃ
//³õʼ»¯dsn
MyODBC::MyODBC(DataBaseType db_type,const char* driver,const char* dsn,
const char* server,const char* db_name,const char* description,USHORT port)
{
m_erro = 0;
m_row_count = 0;
memset(m_sql_state,0,sizeof(m_sql_state));

memset(m_dsn,0,sizeof(m_dsn));
strncpy(m_dsn,dsn,sizeof(m_dsn) - 1);

m_db_type = db_type;

memset(m_db_name,0,sizeof(m_db_name));
strncpy(m_db_name,db_name,sizeof(m_db_name) - 1);

memset(m_driver,0,sizeof(m_driver));
strncpy(m_driver,driver,sizeof(m_driver) - 1);

memset(m_description,0,sizeof(m_description));
strncpy(m_description,description,sizeof(m_description) - 1);

memset(m_ip,0,sizeof(m_ip));
strncpy(m_ip,server,sizeof(m_ip) - 1);

char szPort[20];
memset(szPort,0,sizeof(szPort));
sprintf(szPort,"%d",port);
m_port = port;

char szAttributes[sizeof(m_dsn) + sizeof(m_ip) + sizeof(m_db_name) + sizeof(m_description) + 1];
memset(szAttributes,0,sizeof(szAttributes));
char* p = szAttributes;

sprintf(szAttributes,"DSN=%s\nServer=%s\nDatabase=%s\nDescription=%s",m_dsn,m_ip,m_db_name,m_description);
PR_DEBUG("this is port:%d\ndriver:%s\nAttributes:\n%s",port,driver,szAttributes);
while( *p )
{
if( *p ==


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......

Sqlserver Óï¾äת³ÉMySqlÓï¾ä

Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......

mysql root¸ÄÁËÃÜÂ룬ÓÖ×Ô¶¯±äÁË

¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
  1.ÒÔϵͳ¹ ......

mysqlÊý¾ÝÕÒ»ØÄÑÌ⣬¸ß·Ö£¬¼±£¡£¡£¡

ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ