ÇóÖúmysql»òÆäËûÊý¾Ý¿â - MS-SQL Server / ÒÉÄÑÎÊÌâ
ÔÚmysql±¾À´ÊÇ·µ»ØµÄResultSet£¬µ«ÊÇÎÒÒª·µ»ØÒ»¸öList¿ÉÒÔ²»£¿·µ»ØÒ»¸ölist¾ÍÖ±½Ó±»Ç°Ì¨flex½ÓÊܰ󶨵½datagridÖÐÈ¥¡£¡£¡£
ÄѵÀ²»Ò»Ñù£¬Äã°ÑResultSetµÄÖµ°ó¶¨µ½listÉϲ»¾ÍºÃÁË¡£
²»¶® °ï¶¥
ÄÇÆñ²»ÊÇÒªÖ´ÐÐlist.add()·½·¨Å¶£¿ÓÐûµÃÖ±½Ó·µ»ØList µÄÂï
Äã¿´¿´LISTÓÐûÓÐDATASOURCEÕâÑùµÄÊôÐÔ£¬ÎÒÒѾNÄ겻д6.0µÄÁË¡£
ѧϰÁË¡£ µÈ¸ßÈË
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......
ÏÂÃæÊÇXML³õʼÎļþÄÚÈÝ
XML code:
<upd:Update xmlns:lar="http://schemas.microsoft.com/msus/2002/12/LogicalApplicabilityRules" xmlns:cmd="http://schemas.microsoft.com/msus/2002/12/Up ......