Çë½Ì£º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ÖнøÐÐÊ÷×´ËùÓÐ×Ó½ÚµãµÄ²éѯ
Ïà¹ØÎÊ´ð£º
ÎÒÓÃevc±àдµÄ³ÌÐò£¬½«¶Ô»°¿òÖеÄÊý¾Ý´æÈëÊý¾Ý¿â£¬µÚÒ»´Î¿ÉÒÔ´æÈ룬²»¹ýµÚ¶þ´ÎÊäÈëµÄÊý¾Ý²»ÄÜ´æÈëµ½Êý¾Ý¿âÖС£ ÏÂÃæÊÇÎҵijÌÐò UpdateData(TRUE); // TODO: Add your control notification handler code here ......
ÈçÏÂÓï¾ä £º select TimeSpan from T_Table where onlineDate = '2009-12-2' Êý¾Ý¿âÀïÃæÓзûºÏÌõ¼þµÄÖµµ«ÊDz鲻³öÀ´ Èç¹û¸Ä³ÉÈçÏ£º select TimeSpan from T_Table where onlineDate = '200 ......
ÎÒÏë×öÒ»¸ösqliteµÄ¼à¿ØÈí¼þ£¬ÊµÊ±ÖªµÀÓû§¶ÔÊý¾Ý±í¶¼×öÁËÄÄЩ²Ù×÷¡£ ÔÚÓû§update Ò»¸öÓû§Êý¾Ý±íֵʱ£¬ÎÒÈçºÎ¿ÉÒÔµÃÖªÓû§updateµÄÄĸö×ֶεÄÖµ£¿ÎÒ±¾À´¸øÓû§±íÌí¼Ó´¥·¢Æ÷À´ÊµÏֵģ¬µ«´¥·¢Æ÷ºÃÏñÖ»Äܵõ½Ó ......
»·¾³£ºQNX 6.3.2 °æ±¾£ºSQLite 2.7.3 ÏÖÏó£ºÔÚÃüÁîÐÐÏÂsqlite½øÈ¥£¬Ö´ÐÐ.table¡¢pragmaÖ®Àà¡¢select¶¼Ìáʾ database is locked Ææ¹ÖµÄÊÇ£¬¼´Ê¹ÊÇд´½¨Ò»¸öÊý¾Ý¿â£¬Ö´ÐÐÉÏÊöÃüÁîÒ²ÊÇÄÇÑù¡£ Áí£ºÔÚһ̨Íê ......
sqliteÖÐÓÐûÓжÔÓÚÊý¾Ý¿â´óС½øÐйÜÀíµÄ½Ó¿Ú£¿±ÈÈ磬´´½¨Êý¾Ý¿âµÄʱºòÖ¸¶¨Êý¾Ý¿â´óС£¬¶ÔÊý¾Ý¿â½øÐвÙ×÷ºó²ì¿´¸ÃÊý¾Ý¿âÊ£ÓàµÄ¿ÉʹÓõĿռä´óСµÈ¡£×î½ü¿´ÁËÒ»ÏÂsqliteµÄÏà¹Ø½Ó¿Ú£¬ÍøÉÏÒ²ËÑË÷ÁËÏ£¬Ã»ÓÐÕÒµ½ÓÐÓõÄ×Ê ......