C++ µ÷Óà mysql ÖеÄÎÊÌâ
#include "stdafx.h"
#include "winsock2.h"
#include <windows.h>
#include <iostream>
#include <mysql.h>
#include <stdio.h>
#include <conio.h>
using namespace std;
int _tmain(int argc, _TCHAR* argv[])
{
char *host = "localhost";//Êý¾Ý¿âIP
char *user = "root";//Êý¾Ý¿âÕ˺Å
char *pass = "";//Êý¾Ý¿âÃÜÂë
char *db = "map";//µ±Ç°Êý¾Ý¿â
//Êý¾ÝÀàÐÍÉùÃ÷
MYSQL *sock;//Êý¾Ý¿âÁ¬½ÓÖ¸ÕëÉùÃ÷
MYSQL_RES *results;//²éѯ½á¹û¼¯ÉùÃ÷
MYSQL_ROW record;//²éѯ½á¹ûÐÐÉùÃ÷
sock = mysql_init(0);//³õʼ»¯Ö¸Õë
if (sock)
cout < < "Êý¾Ý¿â³ÌÐò³õʼ»¯³É¹¦£¡" < < endl;
else
{
cout < < "Êý¾Ý¿â³ÌÐò³õʼ»¯Ê§°Ü£¡" < < mysql_error(sock) < < endl;
}
//connection
if (mysql_real_connect(sock, host, user, pass, db, 0, NULL, 0))
cout < < "Êý¾Ý¿âÁ¬½Ó³É¹¦!" < < endl;
else
{
cout < < "Êý¾Ý¿âÁ¬½Óʧ°Ü: " < < mysql_error(sock) &
Ïà¹ØÎÊ´ð£º
ÄÚÈÝÉæ¼°£ºC¡¢C++¡¢STL¡¢VC++¡¢MFC¡¢COM¡¢ATL¡¢WindowsÍøÂç±à³Ì¡¢Êý¾Ý¿â±à³Ì¡¢WindowsÇý¶¯±à³Ì¡¢Èí¼þ¹¤³Ì¡¢Windows²Ù×÷ϵͳ±à³Ì£¬µÈµÈ·½Ãæ¡£
ÏÂÔØµØÖ·£ºhttp://www.cctry.com/forumdisplay.php?fid=46
......
ÄÚÈÝÉæ¼°£ºC¡¢C++¡¢STL¡¢VC++¡¢MFC¡¢COM¡¢ATL¡¢WindowsÍøÂç±à³Ì¡¢Êý¾Ý¿â±à³Ì¡¢WindowsÇý¶¯±à³Ì¡¢Èí¼þ¹¤³Ì¡¢Windows²Ù×÷ϵͳ±à³Ì£¬µÈµÈ·½Ãæ¡£
ÏÂÔØµØÖ·£ºhttp://www.cctry.com/forumdisplay.php?fid=46
......
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......