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

Çë½ÌʹÓÃTree¿Ø¼þºÍSQLiteÊý¾Ý¿âµÄÎÊÌâ

ÎÒÏëÒª½«sqliteÊý¾Ý¿âÖеÄÊý¾Ý£¬ÒÔÊ÷¿Ø¼þµÄÐÎʽ¶Á³ö£¬²¢ÇÒÏÔʾÔÚ¶Ô»°¿òÉÏÃæ£¬²»ÖªµÀÔõô×ö£¬À´Çë½Ìһϡ£
ps£º¿´µ½ÓÐʹÓÃÊ÷¿Ø¼þºÍaccessµÄ£¬ÀïÃæÓÐÊý¾Ý¿âÒýÇæÀ´Á¬½ÓÊý¾Ý¿âºÍ³ÌÐò£¬ÎÒ²»ÖªµÀSQLiteÈçºÎÓë³ÌÐòÁ¬½ÓÆðÀ´
SQLiteÊÇ·ñ¿ÉÒÔÓÃADOÁ¬½Ó
¼ÈÈ»ÒѾ­¿´µ½Á¬ACCESSµÄ£¬ÄÇôӦ¸ÃÉÔ×÷¸Ä¶¯¾Í¿ÉÒÔÁ˰ɡ£

Õâ¸ö¸úʹÓÃÄĸöÊý¾Ý¿âû¹ØÏµ°É?
¹Ø¼üÊÇÄã×Ô¼ºµÄ±í½á¹¹Éè¼ÆÒªºÏÀí


Ïà¹ØÎÊ´ð£º

ÈçºÎö¾ÙsqliteÖеÄËùÓÐ±í¼°Æä×ֶΣ¿£¿

ÎÒÓÐÒ»·ÝsqliteÊý¾Ý¿âÎļþ£¬µ«²»ÖªµÀÀïÃæµÄ±íÃû£¬ÈçºÎö¾Ù³öËùÓеıíÃûÒÔ¼°Æä×Ö¶ÎÃû£¿£¿

¹Ø¼üÊÇsqliteµÄsqlÓï¾äÈçºÎд£¿ÎÒÊÔÁËһЩsqlÓï¾ä²»ÐУ¬ÌØÀ´ÇóÖú¡£

×Ö¶ÎÃû¡¡ÔòÎÞ·¨Ïó±íÃûÒ»Ñù´ÓÊý¾Ý¿âϵͳ±íÖÐÖ±½Ó ......

sqlite£¬updateµÄÎÊÌâ

ÎÒÏë×öÒ»¸ösqliteµÄ¼à¿ØÈí¼þ£¬ÊµÊ±ÖªµÀÓû§¶ÔÊý¾Ý±í¶¼×öÁËÄÄЩ²Ù×÷¡£

ÔÚÓû§update Ò»¸öÓû§Êý¾Ý±íֵʱ£¬ÎÒÈçºÎ¿ÉÒÔµÃÖªÓû§updateµÄÄĸö×ֶεÄÖµ£¿ÎÒ±¾À´¸øÓû§±íÌí¼Ó´¥·¢Æ÷À´ÊµÏֵ쬵«´¥·¢Æ÷ºÃÏñÖ»Äܵõ½Ó ......

ÓйØSQliteµÄÒ»¸öÎÊÌâ

³ÌÐò´úÂëÈçÏ£º
sqlTime = "select SUM(onlineTimeSpan) from T_OnlineTimeSum where ipAddress = :a AND onlineDate BETWEEN :b AND :c";
                ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ