ÇëÎÊÔõôÁ¬½ÓMYSQLÊý¾Ý¿âºÍÖ´ÐÐSQLÓï¾ä°¡£¿
²»ÖªµÀΪʲôÏÂÁ˱ðÈ˳ÌÐò¶¼±à²»¹ý£¬Ö´ÐбðÈ˱àºÃµÄ³ÌÐò£¬ÔËÐоͳö´í¡£¡£¡£
ËÄÜÖ¸µãÒ»ÏÂÔõôÁ¬½ÓMYSQL°¡¡£Ð»Ð»ÁË¡£
¿ÉÒÔÓÃÌṩµÄAPIº¯Êý
ÍøÉÏËÑÒ»´ó°ÑµÄÀý×Ó
ËÑËØÁËÒ»¸ö
C/C++ code:
mysql_real_connect()ÊÔͼ½¨Á¢µ½ÔËÐÐhostµÄÒ»¸öMySQLÊý¾Ý¿âÒýÇæµÄÒ»¸öÁ¬½Ó¡£Æäº¯ÊýÔÐÎΪ£º
MYSQL *mysql_real_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd, const char *db, unsigned int port, const char *unix_socket, unsigned int client_flag)
ÎÒÒª±àÒ»¶Î³ÌÐòÓÃÀ´Ô¶³ÌÁ¬½ÓÒ»¸ömysqlÊý¾Ý¿â¡£ÎÒÔÚÊý¾Ý¿âµÄ±¾»úÉÏ×öÊÔÑ飬·¢ÏÖmysql_real_connect()µÄµÚ¶þ¸ö²ÎÊýÉèΪ"localhost"ʱ¿ÉÒÔÕý³£Á¬½Ó£¬µ±¸ÄдΪ¸Ã»úÆ÷µÄIPµØÖ·"192.168.100.2"ʱ¾ÍÁ¬½Óʧ°Ü¡£ÎÒÔÚ³ÌÐòÖÐдµÄÔ¾äΪ£º
mysql_real_connect(mysql,"192.168.100.2","root","","mydns",0,NULL,0)¡£
×î³õ£¬ÎÒÒÔΪ½«"localhost"¸ÄΪ"192.168.100.2"Ö®ºóÒª½«µÚÁù¸ö²ÎÊý¶Ë¿ÚºÅдÉÏ£¬µ«»¹ÊDz»ÐС£ÓÉÓÚÎÒÊÇÔÚLinuxÉÏ×öµÄ£¬ËùÒÔÏëÒ²ÐíÐèÒª½«µÚÆß¸ö²ÎÊýunix_socketдÉÏ£¬½á¹û»¹ÊDz»ÐС£ÓÚÊǵ½googleÕÒ½â¾ö·½·¨£¬·¢ÏÖÒªÔ¶³ÌÁ¬½ÓmysqlÐèҪΪmysqlµÄÖ¸¶¨ÕʺÅÉèÖÃÔ¶³ÌÁ¬½ÓµÄȨÏÞ¡£ÔÚÎҵijÌÐòÖУ¬¾ÍҪΪrootÉèÖÃÕâһȨÏÞ¡£ÊÂʵ֤Ã÷£¬ÎÒ֮ǰÁ¬½Óʧ°ÜÕýÊÇÓÉÓÚÕâ¸öÔÒòµ¼Öµġ£µ«ÎÊÌâÊÇ£¬ÍøÉϱ»¹ã·º×ªÌùµÄ·½·¨ÊÇ´íÎóµÄ£¬ÎÒÕÕ×öºó»¹²»ÐУ¬×îºóÎÊÁËͬѧ²Å½â¾öµÄ¡£ÏÂÃæÎÒ¾ßÌå˵һÏ£¬Íû´ó¼Ò²»»áÔÙ±»Î󵼡£
ÔÚmysqlÊý¾Ý¿âÖÐÓÐÒ»¸ömysql¿â£¬ËüÀïÃæ°üº¬Ò»¸öuser±í£¬ÀïÃæ
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......