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

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

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

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


Ïà¹ØÎÊ´ð£º

ÓùýSQLiteµÄÅóÓѺÍÍæ¹ýÅú´¦ÀíµÄÅóÓѽøÀ´¿´Ò»ÏÂ.


    żÏ뱸·ÝÊý¾Ý±í£¬Ð´ÁËÒ»¸öÅú´¦Àí£¬ÓÐÏֳɵÄÊý¾Ý¿â¡£µ«ÊÇÅú´¦Àíдµ½Ò»°ë²»»áÁË£¬»¹Çë°ïæ¿´¿´£¬ÔõôÍùÏ¡£¡£¡£

    @echo off
    echo ÕýÔÚϵͳÊý¾Ý¿â±¸·Ý£¬ÇëÉÔ ......

winceÏÂʹÓÃsqliteµÄ¿ìËÙ²éѯ£¿

´ó¼ÒºÃ£º
      ×î½üÔÚwinceÏÂʹÓÃsqlite£¬µ«ÊÇÓÉÓÚ±íµÄÄÚÈÝÁ¿´ó£¬ËùÒÔ²éѯЧÂʺܵͣ¬²»ÖªµÀʲôÎÊÌâ¼°Ôõô½â¾ö¡£
      ÎҵıíµÄ½á¹¹ÈçÏ£º
      name&nbs ......

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ºÅ