ÓÃ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µÄʱºò¶¼ÊÇÖ±½Ó·µ»Ø½á¹ûµÄ£¬²»ÖªµÀ½ÓÏÂÀ´µÄ²½ÖèÊÇʲôÁË¡£
лл£¬ÊDz»ÊÇËùÓзûºÏ²éѯµÄ½á¹û¾Í¶¼´æÔÚrowÀïÁË£¿ÎÒ¿´Õâ¸öÊÇchar **ÀàÐ͵ġ£¡£¡£
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......