c++ÖвéѯmysqlÊý¾Ý¿âµÄÎÊÌâ ¼±°¡£¡£¡£¡£¡£¡
ÎÒÔÚc++ÖвéѯmysqlÊý¾Ý¿âʱ
ÎÒÕâÑù×ö¾Í¿ÉÒÔ
char szSqlText[500];
sprintf(szSqlText,"select * from anchorid where xdid='1' and pointid='1' and xdupdw='up'");
µ«ÏÂÃæÕâÑù¾Í²»ÐÐ
char szSqlText[500];
sprintf(szSqlText,"select * from anchorid where xdid='%d' and pointid='%d' and xdupdw='up'",xd_id,anchorid1);
ÕâÊÇʲôÔÒò°¡£¿
ÄܰÑxd_idºÍanchorid1µÃÀàÐÍÌù³öÀ´Âð£¿Èç¹ûËûÃÇÀàÐÍÆ¥Å䣬ËûÃǵÃÖµÒ²ÕýÈ·Âð£¿
Ïëµ½µÃ¾ÍÒÔÉÏÁ½µãÁË
Ó¦¸Ã¾ÍÊÇÀàÐͲ»Æ¥ÅäÁË
int anchorid1='1',anchorid2='2',xd_id='1';
ÔÎ ²ËÄñÁË ¶¨Òå´íÁË ¶àÁ˵¥ÒýºÅ
ÏÖÔÚ¿ÉÒÔÁË ¡£¡£¡£ лл¸÷λ
Ïà¹ØÎÊ´ð£º
ÎÊÌâ:¹¤µØÉÏÐèÒª³¤¶ÈΪA1µÄ¸Ö½îX¸ù,³¤¶ÈΪA2µÄ¸Ö½îY¸ù,³¤¶ÈΪA3µÄ¸Ö½îZ¸ù......ÒÔ´ÎÀàÍÆ.
ÆäÖÐA1,A2,A3,...³¤¶ÈÈÎÒâÖ¸¶¨,X,Y,Z,...ÊýÁ¿Ò²ÈÎÒâÖ¸¶¨.
µ«²Ö¿âÖеĸֽîΪ±ê×¼³¤¶È,Ö»ÓÐ9Ã׺Í15Ã×Á½ÖÖ³¤¶È,ÊýÁ¿² ......
дÁ˸ö²âÊÔ³ÌÐòÈçÏÂ
struct hostent *hp;
char AlarmDevIP[20];
int x2;
hp = gethostbyname("www.google.com");
if (hp)
{
......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
´ó¼ÒºÃ:
ÎÒÊǸãCµÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ:
#include <stdio.h>
#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"
......