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

WM³ÌÐò²éѯSQLite¿â×Ü˵±í²»´æÔÚ

.netµÄ³ÌÐò£¬ÓõÄSystem.Data.SQLite DLL
¿âÊÇdb3µÄ£¬²éѯʱ×Ü˵no table **
·¾¶Ò²ÊǶԵÄ
¶øÄǸötableÊÇ´æÔÚµÄ
ÔÚPCÉÏÄÜ¿´µ½
ÇëÎÊÕâ¸öÊÇÔõô»ØÊÂÄØ£¿
ÊÖ»úÉÏÎļþʱûÓÐÏà¶Ô·¾¶µÄ¸ÅÄîµÄ£¬

±¨Ê²Ã´´í¶ù??
ÊDz»ÊÇ´´½¨µÄÁ¬½ÓÀàûдºÃ?
¿ÉÒÔÕý³£Á¬½ÓÊý¾Ý¿âô?


ÕâÖÖÇé¿öÓöµ½¹ý£¬Ã»ÕÒµ½Ô­Òò~±È½ÏÓôÃÆ¡£

ÕÒµ½Ô­ÒòÁË£¬¾ÍÏñweiweiloong˵µÄ£¬WinceÉÏûÓе±Ç°Â·¾¶

SQLite±È½ÏÄÕÈ˵ÄÒ»µã¾ÍÊÇ£º
Èç¹ûÕÒ²»µ½Ö¸¶¨Êý¾Ý¿â£¬¾ÍÖØ½¨Ò»¸ö¸ø¶¨Â·¾¶µÄÐÂÊý¾Ý¿â
ÕâÑùÒÔÀ´±íµ±È»Ã»ÓÐÀ²¡£¡£¡£

Á¬½Ó×Ö·û´®ÒªÉèÖþø¶Ô·¾¶


Ïà¹ØÎÊ´ð£º

sqlite »ñÈ¡×î½üÉúÈÕÓû§µÄ·½·¨£¿

1¡¢juliandayÕâ¸öº¯ÊýÖ»ÓдøÉÏÄê·Ý¼ÆËã²Å¿É¿¿£»
2¡¢ÎÒĿǰÓõķ½·¨SELECT £¨jolianday(¡®now¡¯)-jolianday(¡®1981-12-23¡¯)£©%365
3¡¢Õâ¸ö·½·¨¿Ï¶¨ÓÐÎÊÌ⣬µ«ÊµÔÚ²»ÖªµÀÔõôʵÏÖ£»
Òò´ËÏ£Íû¸÷λÈÊÐÖ°ï°ïæ£ ......

SQLITE²åÈëÓï¾ä´íÎó

SQL code:

IF NOT EXISTS(SELECT * from Company WHERE MAC='aa:22:cc:22:ee:ff')
INSERT INTO Company(Mac,CompanyId,CompanyName,FtpParameter ......

sqliteÊý¾Ý¿â¼àÊÓÎÊÌâ(´¥·¢Æ÷?)

SQL´¥·¢Æ÷¿ÉÒÔµ÷ÓÃÍⲿ³ÌÐò£¬sqlite¿ÉÒÔÂð£¿Èç¹ûÏë¼àÊÓÊý¾Ý¿âijһÕűíµÄijһÏîµÄ¸Ä±ä¸ÃÔõô×ö£¿Óô¥·¢Æ÷»¹ÊÇÆäËûʲô·½·¨£¿
Èç¹ûÑ¡ÔñÓô¥·¢Æ÷¸Ã´úÂë¸ÃÔõôд£¿Çë¸ø³ö˼·»ò´úÂ룬ÆäËû»¹ÓÐʲô·½·¨¿ÉÒÔ¼àÊÓÊý¾Ý¿â± ......

sqliteÊý¾Ý¿â²»ÄÜÁ¬Ðø´æÈëÊý¾ÝµÄÎÊÌâ

ÎÒÓÃevc±àдµÄ³ÌÐò£¬½«¶Ô»°¿òÖеÄÊý¾Ý´æÈëÊý¾Ý¿â£¬µÚÒ»´Î¿ÉÒÔ´æÈ룬²»¹ýµÚ¶þ´ÎÊäÈëµÄÊý¾Ý²»ÄÜ´æÈëµ½Êý¾Ý¿âÖС£
ÏÂÃæÊÇÎҵijÌÐò
UpdateData(TRUE); // TODO: Add your control notification handler code here ......

help£¡SQLiteÖвÙ×÷blobÀàÐ͵Ä×ֶεÄÎÊÌâ

ÕâÊÇÎҲ鵽µÄ×ÊÁÏ
http://www.cppprog.com/2009/0108/43.html ÒѾ­´æ½øÍ¼Æ¬ÁË£¬ÏÖÔÚ×öµ½ÕâÒ»²½ÁË£¬
¡°ÕâʱÊý¾Ý¿âµ±ÖÐÒѾ­ÓÐÁËÒ»Ìõ°üº¬BLOB×ֶεÄÊý¾Ý¡£½ÓÏÂÀ´ÎÒÃÇÒª¶ÁÈ¡ÕâÌõÊý¾Ý£º  1.  //ѡȡ¸ÃÌõ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ