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

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++¡¢VC++ ¾«Æ·µç×ÓÊé·¢²¼À²£¡

ÄÚÈÝÉæ¼°£ºC¡¢C++¡¢STL¡¢VC++¡¢MFC¡¢COM¡¢ATL¡¢WindowsÍøÂç±à³Ì¡¢Êý¾Ý¿â±à³Ì¡¢WindowsÇý¶¯±à³Ì¡¢Èí¼þ¹¤³Ì¡¢Windows²Ù×÷ϵͳ±à³Ì£¬µÈµÈ·½Ãæ¡£

ÏÂÔØµØÖ·£ºhttp://www.cctry.com/forumdisplay.php?fid=46

......

C¡¢C++¡¢VC++ ¾«Æ·µç×ÓÊé·¢²¼À²£¡

ÄÚÈÝÉæ¼°£ºC¡¢C++¡¢STL¡¢VC++¡¢MFC¡¢COM¡¢ATL¡¢WindowsÍøÂç±à³Ì¡¢Êý¾Ý¿â±à³Ì¡¢WindowsÇý¶¯±à³Ì¡¢Èí¼þ¹¤³Ì¡¢Windows²Ù×÷ϵͳ±à³Ì£¬µÈµÈ·½Ãæ¡£

ÏÂÔØµØÖ·£ºhttp://www.cctry.com/forumdisplay.php?fid=46

......

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

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

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

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. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ