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

Çë½Ì£ºVCÖеÄTree¿Ø¼þÓëSQLiteÊý¾Ý±íµÄʹÓÃÎÊÌâ

ÎÒÒª°ÑÊý¾Ý±íÖеÄÊý¾Ý£¬ÒÔÊ÷µÄÐÎʽÏÔʾÔÚ¶Ô»°¿òÖС£
±ÈÈ磺
Ö»ÒªÊý¾Ý±íÖÐÓÐ3¸ö×ֶΡ¢id¡¢parentid¡¢name
ÇëÎÊÎÒÈçºÎдһЩ´úÂ뽫Êý¾Ý±íÖеÄÄÚÈÝÌîµ½Ê÷¿Ø¼þÖÐÈ¥ 

ÒýÓÃ
Ò»°ãÊÇÓõݹéµÄ·½·¨À´ÊµÏÖ£¬µ±È»Ò²¿ÉÒ԰ѵݹéË㷨ת»»³ÉÑ­»·¡£ ´ÓÖ÷Ö÷½áµã¿ªÊ¼ select * from xxx where parentid is null
È»ºóÖð¸öÏÔʾ¡£

ÏÂÃæÀý×ÓÖÐÓÐÒ»¸öÆäËüÊý¾Ý¿âÖеÄËã·¨£¬»òÐí¿ÉÒԲο¼Ò»ÏÂ

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/02/4142971.aspx
MySQLÖнøÐÐÊ÷×´ËùÓÐ×Ó½ÚµãµÄ²éѯ


лл°¡ ÎÒÑо¿Ò»Ï ²»¶®ÔÙÎÊ

×îºóʹÓÃÁ˾²Ì¬·½·¨½¨Á¢ÁËÊ÷×´½á¹¹
ºÇºÇ
ÎÄÕÂÊÕ²ØÁË ÒÔºóÓ¦¸Ã»¹ÓÐÓõõ½µÄµØ·½
лл
ÒýÓÃ
Ò»°ãÊÇÓõݹéµÄ·½·¨À´ÊµÏÖ£¬µ±È»Ò²¿ÉÒ԰ѵݹéË㷨ת»»³ÉÑ­»·¡£ ´ÓÖ÷Ö÷½áµã¿ªÊ¼ select * from xxx where parentid is null
È»ºóÖð¸öÏÔʾ¡£

ÏÂÃæÀý×ÓÖÐÓÐÒ»¸öÆäËüÊý¾Ý¿âÖеÄËã·¨£¬»òÐí¿ÉÒԲο¼Ò»ÏÂ

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/02/4142971.aspx
MySQLÖнøÐÐÊ÷×´ËùÓÐ×Ó½ÚµãµÄ²éѯ



Ïà¹ØÎÊ´ð£º

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";
                ......

ÊìϤSqliteµÄÇë½øÀ´£¡£¡£¡£¡£¡

´ó¼ÒºÃ£¡
  sqlite×Ö¶ÎΪfloatÐ͵ÄÖµÔõÑù·ÃÎÊ£¿
ÊÔ¹ýÓÃsqlite3_column_double£¬È··µ»ØµÄÊý¾Ý²»ÕýÈ·£»
ûÓùý,°ï¶¥.

Ò»Ñù°¡£¬·µ»ØÈ«ÊÇ string

ÄãµÄ´úÂëÊÇʲô£¿
double sqlite3_column_double(sqli ......

Sqlite intת»»ÎªÊ®Áù½øÖÆ

sqlliteÀïÃæÓÐʲô·½·¨°Ñintת»»ÎªÊ®Áù½øÖÆ´æ´¢µÄÄØ?
ÀýÈç,strftime('%s', 'now') µÃµ½1263777947,µ±Ç°µÄÃëÊý,ÎÒÏë´æ´¢ÎªËüµÄÊ®Áù½øÖƱíʾ"4B53B89B"
лл..

ÆäʵÎÒÊÇÏëstrftime ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ