WM³ÌÐò²éѯSQLite¿â×Ü˵±í²»´æÔÚ
.netµÄ³ÌÐò£¬ÓõÄSystem.Data.SQLite DLL
¿âÊÇdb3µÄ£¬²éѯʱ×Ü˵no table **
·¾¶Ò²ÊǶԵÄ
¶øÄǸötableÊÇ´æÔÚµÄ
ÔÚPCÉÏÄÜ¿´µ½
ÇëÎÊÕâ¸öÊÇÔõô»ØÊÂÄØ£¿
ÊÖ»úÉÏÎļþʱûÓÐÏà¶Ô·¾¶µÄ¸ÅÄîµÄ£¬
±¨Ê²Ã´´í¶ù??
ÊDz»ÊÇ´´½¨µÄÁ¬½ÓÀàûдºÃ?
¿ÉÒÔÕý³£Á¬½ÓÊý¾Ý¿âô?
ÕâÖÖÇé¿öÓöµ½¹ý£¬Ã»ÕÒµ½ÔÒò~±È½ÏÓôÃÆ¡£
ÕÒµ½ÔÒòÁË£¬¾ÍÏñweiweiloong˵µÄ£¬WinceÉÏûÓе±Ç°Â·¾¶
SQLite±È½ÏÄÕÈ˵ÄÒ»µã¾ÍÊÇ£º
Èç¹ûÕÒ²»µ½Ö¸¶¨Êý¾Ý¿â£¬¾ÍÖØ½¨Ò»¸ö¸ø¶¨Â·¾¶µÄÐÂÊý¾Ý¿â
ÕâÑùÒÔÀ´±íµ±È»Ã»ÓÐÀ²¡£¡£¡£
Á¬½Ó×Ö·û´®ÒªÉèÖþø¶Ô·¾¶
Ïà¹ØÎÊ´ð£º
1¡¢juliandayÕâ¸öº¯ÊýÖ»ÓдøÉÏÄê·Ý¼ÆËã²Å¿É¿¿£»
2¡¢ÎÒĿǰÓõķ½·¨SELECT £¨jolianday(¡®now¡¯)-jolianday(¡®1981-12-23¡¯)£©%365
3¡¢Õâ¸ö·½·¨¿Ï¶¨ÓÐÎÊÌ⣬µ«ÊµÔÚ²»ÖªµÀÔõôʵÏÖ£»
Òò´ËÏ£Íû¸÷λÈÊÐÖ°ï°ïæ£ ......
SQL code:
IF NOT EXISTS(SELECT * from Company WHERE MAC='aa:22:cc:22:ee:ff')
INSERT INTO Company(Mac,CompanyId,CompanyName,FtpParameter ......
SQL´¥·¢Æ÷¿ÉÒÔµ÷ÓÃÍⲿ³ÌÐò£¬sqlite¿ÉÒÔÂð£¿Èç¹ûÏë¼àÊÓÊý¾Ý¿âijһÕűíµÄijһÏîµÄ¸Ä±ä¸ÃÔõô×ö£¿Óô¥·¢Æ÷»¹ÊÇÆäËûʲô·½·¨£¿
Èç¹ûÑ¡ÔñÓô¥·¢Æ÷¸Ã´úÂë¸ÃÔõôд£¿Çë¸ø³ö˼·»ò´úÂ룬ÆäËû»¹ÓÐʲô·½·¨¿ÉÒÔ¼àÊÓÊý¾Ý¿â± ......
ÎÒÓÃevc±àдµÄ³ÌÐò£¬½«¶Ô»°¿òÖеÄÊý¾Ý´æÈëÊý¾Ý¿â£¬µÚÒ»´Î¿ÉÒÔ´æÈ룬²»¹ýµÚ¶þ´ÎÊäÈëµÄÊý¾Ý²»ÄÜ´æÈëµ½Êý¾Ý¿âÖС£
ÏÂÃæÊÇÎҵijÌÐò
UpdateData(TRUE); // TODO: Add your control notification handler code here ......
ÕâÊÇÎҲ鵽µÄ×ÊÁÏ
http://www.cppprog.com/2009/0108/43.html ÒѾ´æ½øÍ¼Æ¬ÁË£¬ÏÖÔÚ×öµ½ÕâÒ»²½ÁË£¬
¡°ÕâʱÊý¾Ý¿âµ±ÖÐÒѾÓÐÁËÒ»Ìõ°üº¬BLOB×ֶεÄÊý¾Ý¡£½ÓÏÂÀ´ÎÒÃÇÒª¶ÁÈ¡ÕâÌõÊý¾Ý£º 1. //ѡȡ¸ÃÌõ ......