ÇóÖúmysql»òÆäËûÊý¾Ý¿â - MS-SQL Server / ÒÉÄÑÎÊÌâ
ÔÚmysql±¾À´ÊÇ·µ»ØµÄResultSet£¬µ«ÊÇÎÒÒª·µ»ØÒ»¸öList¿ÉÒÔ²»£¿·µ»ØÒ»¸ölist¾ÍÖ±½Ó±»Ç°Ì¨flex½ÓÊܰ󶨵½datagridÖÐÈ¥¡£¡£¡£
ÄѵÀ²»Ò»Ñù£¬Äã°ÑResultSetµÄÖµ°ó¶¨µ½listÉϲ»¾ÍºÃÁË¡£
²»¶® °ï¶¥
ÄÇÆñ²»ÊÇÒªÖ´ÐÐlist.add()·½·¨Å¶£¿ÓÐûµÃÖ±½Ó·µ»ØList µÄÂï
Äã¿´¿´LISTÓÐûÓÐDATASOURCEÕâÑùµÄÊôÐÔ£¬ÎÒÒѾNÄ겻д6.0µÄÁË¡£
ѧϰÁË¡£ µÈ¸ßÈË
Ïà¹ØÎÊ´ð£º
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä
Id value state dattime
101 32.3 0 ......