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

ÓÃMYSQLµÄAPI£¬¹ØÓÚSQLʹÓõÄÎÊÌ⣬Çë´ïÈ˰ïæ½â»ó¡£

C/C++ code:
char chSQL[1024] = {0};
MYSQL mysql;
strcat(chSQL, "select LOGIN_PWD from SYS_USER_TBL where LOGIN_NAME = '");
strcat(chSQL, chName);
strcat(chSQL, "'");
mysql_real_query(&mysql, chSQL, strlen(chSQL));


²»ÖªµÀÒÔÉϲéѯÓдíû£¿È»ºó²»ÖªµÀÔõôÅжÏÊÇ·ñ²éѯµ½PWD,Èç¹û²éµ½£¬PWDµÄÖµÔõô·µ»Ø£¿Çë´ïÈËÖ¸µãÒ»¶þ£¬Ð»Ð»¡£
ÊÔÊÔ²»¾ÍÖªµÀÁË

´úÂë¶¼²»»áд£¬ÔõôÊÔѽ£¿£¿Õâ¸öº¯Êý·µ»ØµÄºÃÏñÊÇÒ»¸öINTÐ͵ģ¬ÒÔǰÓÃSQLµÄʱºò¶¼ÊÇÖ±½Ó·µ»Ø½á¹ûµÄ£¬²»ÖªµÀ½ÓÏÂÀ´µÄ²½ÖèÊÇʲôÁË¡£


ÒýÓÃ
mysql_real_query(&mysql, chSQL, strlen(chSQL));
MYSQL_RES * res;
MYSQL_ROW row ;
res = mysql_store_result
row = mysql_fetch_row( res ) ;




лл£¬ÊDz»ÊÇËùÓзûºÏ²éѯµÄ½á¹û¾Í¶¼´æÔÚrowÀïÁË£¿ÎÒ¿´Õâ¸öÊÇchar **ÀàÐ͵ġ£¡£¡£


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ