MSSQLÊý¾Ý¿âÀïµÄ¼Ç¼ת³ÉJSONµÄÎÊÌâ
ÎÒ·¢ÏÖÎÒ°ÑÊý¾Ý¼Ç¼ת³ÉJSONÒ»¸öÎÊÌâ¡£
Èç¹ûÔÚÊý¾Ý¿âÀïÃæÊÇûÓл»ÐеļǼ£¬ÊÇ¿ÉÒÔ˳Àûת»»³ÉJSONµÄ
Èç¹û»»ÐУ¬¾ÍתµÄ²»³É¹¦¡£
ÄÄÃÇÐÖµÜÖªµÀÊÇÕ¦¸ãµÄ£¿
ÎÒµÄÎÊÌâ½â¾öÁË
ÒòΪÎÒÓõÄÊÇMSSQL £¬Ï뽫ÀïÃæµÄÊý¾Ýת³ÉJSON£¬È»ºó×°³ÉExtJsµÄGridPanelÖÐ
ºó¾¹ýÎÒ×Ô¼º×ÐϸµÄÅŲ飬·¢ÏÖ²»ÊÇJSONµÄÎÊÌ⣬¶øÊÇExtJsµÄGridPanel²»Ö§³Ö»»ÐС£
ºóÀ´ÎÒÔÚC#¶ËÓÃ.Replace("\r\n","")´¦Àíһϣ¬¾Í¿ÉÒÔÁË¡£
½Ó·Ö°É
jf
Ïà¹ØÎÊ´ð£º
±ÈÈç
Ò»¸öÊÇÓû§Áбí
UserID
1
2
3
4
Ò»¸öÊǼǼÁбí(ÿ¸öÓû§Ò»Ìì¿ÉÄÜÓжàÌõÊý¾Ý)
UserID Day
1 2009-09-22
1 2009-09-22
1 2009-09-22
2 2009-09-22
2 20 ......
MYSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞÖÆÊÇ:GRANT ALL PRIVILEGES ON *.* TO username'@'IPµØÖ· IDENTIFIED BY 'ÃÜÂë ' WITH GRANT OPTION
ÓÐËÖªµÀÔÚMSSQLÖÐÔõôÉèÖÃIP·ÃÎÊÏÞÖÆ
ÒýÓÃ
MYSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞ ......
ÎÒÉè¼ÆµÄ
Óû§ÐÅÏ¢±í ³±íÊý¾Ý±í ÀúÊ·³±íÊý¾Ý±í
ÎÒµÄÏë·¨ÊÇ Ã¿Ô³õ ϵͳ×Ô¶¯ÔÚ ³±íÊý¾Ý±íÖÐÉú²ú ÓëÓû§¹ØÁªµÄÊý¾Ý ÓÃÓÚ³±íÔ±µÄ¼È룬µ±³±íԱȫ²¿Â¼Èëºó °ÑÊý¾ÝÈ«²¿¸´ÖƵ½ÀúÊ·±íÖРͨʱ ......
ΪʲôMSSQLÖеÄGUIDÀàÐÍÓÐÁ½¸ö{xxxxxx}µÄ¡£²»·½±ã°¡¡£
µØÖ·´«ÖµµÄʱºòÕâÑùºÃ²»ºÃµÄ£¿
ĬÈÏÊä³öP¸ñʽ
-----------
ĬÈÏÊä³öÊÇB¸ñʽ...
ÉÏÃæËµÁË È¡³öÀ´¸ñʽ»¯Ò»ÏÂ
ѧϰÁË.
ÒýÓÃ
ĬÈÏÊä³ ......
´úÂëÈçÏ£º
QSqlDatabase dbconn = QSqlDatabase::database( "sqltest ", false);
if(!dbconn.isVa ......