C/C++¶ÔMySQL²Ù×÷
×òÌìÍíÉÏÔÚ¿´C/C++¶ÔÊý¾Ý¿âµÄ²Ù×÷,ÃÍÈ»¼ä¾õµÃÊ®·ÖÇ×ÇУ¬ÒòΪÆäÖкܶຯÊý¶¼ºÍPHPÖжÔMySQL²Ù×÷Ïàͬ£¬ÕâÊDzÅÏëÆðPHPÊÇCÑÝ»¯¶øÀ´µÄ¡£¾¹ýÒ»·¬µ·ÌÚ£¬ÖÕÓÚÍê³ÉÁËÒ»¸ö¼òµ¥µÄ³ÌÐò£¬µ«ÊÇÈÔÈ»´æÔÚ×ÅÒ»¸öÑÏÖØµÄÎÊÌ⣬¾ÍÊÇ´ÓÊý¾Ý¿âÖеõ½µÄ½á¹ûÔÚÆÁÄ»ÉÏÏÔʾµÄÊÇÂÒÂ룬ºÜÈÃÈË·³¡£»¹Íû¸ßÊÖÃǴͽ̣¡
1.ÔÚ»úÆ÷ÉÏ×°ÉÏMySQL £¬¼ÙÉè°²×°ÔÚ C:\MySQL\ÖÐ;
2.ÕâÀïÎÒÃÇÓÃVC6.0À´±àдC++³ÌÐò£¬µ«ÊÇÕâ¸ö֮ǰҪ¶ÔVC6.0×öһЩÉèÖã¬Ò²¾ÍÊǰÑMySQLĿ¼ÏµÄincludeºÍlibĿ¼°üº¬µ½VC6.0µÄdirectoryÑ¡ÏîÖС£¾ßÌåµÄ×ö·¨ÊÇÔÚVC6.0ÖÐ tools(¹¤¾ß)>>option(Ñ¡Ïî)>>directories(Ŀ¼)Õâ¸öÉèÖÃÖÐ°Ñ include files Ìí¼ÓÒ»¸ö·¾¶ C:\MySQL\include £¬ÔÙ¸ølibrary files Ìí¼ÓÒ»¸ö·¾¶C:\MySQL\lib\opt ,ÕâÑùÉèÖÃÒÔºóÄã¾ÍÄܹ»ÔÚ³ÌÐòÖÐÖ±½Óinclude¶ÔÊý¾Ý¿â²Ù×÷µÄÏà¹ØÍ·ÎļþÁË¡£
3.ÏÖÔÚ¿ÉÒÔ¿ªÊ¼Ð´³ÌÐòÁË£¬´úÂëÈçÏ£º
//===========================================================//
// TestMySQL.cpp
// Author : ASpire
// Discrb : for testing C++ in operating mysql
// Time : 2010-3-18
//===========================================================//
/* include header about mysql */
#include "winsock2.h"
#include "mysql.h"
#include <stdio.h>
#define CONN_HOST "localhost"
#define CONN_USER "user"
#define CONN_PWD "password"
#define CONN_DB "luntan"
//----------------------------------------------------------//
MYSQL mysql;
void exiterr(int exitcode)
{
fprintf(stderr,"%s",mysql_error(&mysql));
exit(exitcode);
}
int mysql_test()
{
MYSQL_RES *res;
MYSQL_ROW row;
unsigned int i = 0;
/* init mysql handler */
if(!mysql_init(&mysql))
{
exiterr(-1);
}
/* connect to mysql */
if(!mysql_real_connect(&mysql,CONN_HOST,CONN_USER,CONN_PWD,NULL,MYSQL_PORT,NULL,0))
{
exiterr(-2);
}
/* select db */
if(mysql_select_db(&mysql,CONN_DB))
{
exiterr(-3);
}
/* set db cha
Ïà¹ØÎĵµ£º
C ÓïÑÔµÄÃæÏò¶ÔÏó
ÈçǰËù˵£¬ÃæÏò¶ÔÏóÊÇÒ»ÖÖÈí¼þÉè¼ÆµÄ˼Ï룬ÊÇÓïÑÔÎ޹صġ£ÔÚ±¾½ÚÖУ¬ÎÒ¾ÙÒ»¸öÁ´±í(list) µÄÀý×ÓÀ´ËµÃ÷ÈçºÎÔÚ C ÓïÑÔÖеÄÉè¼Æ³öÓÐÃæÏò¶ÔÏó·ç¸ñµÄ´úÂë¡£
¶¨Òå½Ó¿Ú
½Ó¿ÚÊÇÃæÏò¶ÔÏóÓïÑÔÖеÄÒ»¸ö±È½ÏÖØÒªµÄ¸ÅÄ½Ó¿ÚÖ»¶ÔÍⲿ³ÐŵʵÏָýӿڵÄʵÌå¿ÉÒÔÍê³ÉʲôÑùµÄ¹¦ÄÜ£¬µ«ÊDz»±©Â¶ÊµÏֵķ½Ê½¡£ÕâÑùµÄºÃ´¦ÊÇ ......
¶à¼Ì³Ð£º
C++ÖеÄÀà¿ÉÒÔÖ±½ÓʵÏÖ¶à¼Ì³Ð È磺class D:public A,public B,public C{……};
JavaÖв»ÄÜÖ±½ÓʵÏÖÕâÑùµÄ¶à¼Ì³Ð£¬µ«ÊÇ¿ÉÒÔÓýӿڣ¨interface£©À´¼ä½ÓʵÏÖ È磺
public class A{ ……}
public interface C{
¡¡¡¡public void c1();
¡¡¡¡public void c2();
}
public class C exten ......
ΪÁËÈÃÓû§²»ÐèÒª×Ô¼ºÔËÐÐmysql°²×°³ÌÐò°²×°mysqlÊý¾Ý¿â£¬Èí¼þ·¢²¼Ê±ÐèÒª´ò°üÃâ°²×°°æ±¾µÄmysql¡£´Ómysql¹ÙÍøÉÏÖ±½ÓÏÂÔØµÄÃâ°²×°°æ±¾ÐèÒª¸÷ÖÖÅäÖã¬Èç¹ûÅäÖò»ºÃ£¬ºÜÈÝÒײúÉú¸÷ÖÖ¸÷ÑùµÄÎÊÌâ¡£ÓÈÆäÊÇ´íÎóÂëΪ1067µÄÎÊÌ⣬ÎÒÊÔÑéÁËÍøÉϵĺܶ෽·¨¶¼Ã»Æð×÷Óã¬×îºóÏëÁËÒ»¸ö×î¼òµ¥µÄ·½·¨£º
£¨1£©Ê×ÏÈʹÓð² ......
ÀûÓÃÊÀ½ç×îС×î¿ìµÄC±àÒëÆ÷´òÔì×Ô¼ºµÄC±à¼Æ÷
¼ò½étinycc ÊÀ½çÉÏ×îС±àÒëËÙ¶È×î¿ìµÄCÓïÑÔ±àÒëÆ÷ ¸÷ÏÄܽø¹Ù·½È¥¿´
TCC¹Ù·½ÏÂÔØµØÖ·£ºhttp://ftp.twaren.net/Unix/NonGNU/tinycc/tcc-0.9.25-win32-bin.zip
ÎÒÖªµÀ ´ó¼Ò»ù±¾É϶¼ÓùýWIN—TC°É ÌØ±ðÊÇÉϹý´óѧµÄ CÓïÑÔÈëÃÅʱÓõͼÊÇ
ËûµÄ²Ù×÷½çÃæÈçͼ
¹þ¹þ ¿´ÏÂÍ ......