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

cb2010ÔõôʹÓÃSQLiteÊý¾Ý¿â£¿

×îºÃÊDz»ÐèÒªÁíÍâ°²×°Çý¶¯»ò×é¼þµÄ·½Ê½¡£

ʹÓÃSQLiteµÄAPI, ËüÌṩÁËdll ÐÎʽµÄAPI

ÄѵÀCBÌṩµÄÊý¾Ý×é¼þ²»Ö§³Ö£¿

2010ÊÇÖ§³ÖµÄ¹Ø¼üÊÇÇý¶¯ÒªÑ¡¶Ô£¬ºÃÏñÊÇoffice 11ʲôµÄ

ÒýÓÃ
ÄѵÀCBÌṩµÄÊý¾Ý×é¼þ²»Ö§³Ö£¿

ºÃÏñCB2010ûÓÐÌṩ·ÃÎÊSQLITEµÄ×é¼þ.


ÒýÓÃ
ʹÓÃSQLiteµÄAPI, ËüÌṩÁËdll ÐÎʽµÄAPI


µÚÒ»,ÎÒ²»ÖªµÀÄÄÀïÏÂÔØÕâ¸öDLL
µÚ¶þ,ÓÐûÓо²Ì¬µÄµ÷Ó÷½·¨?


È¥sqlite¹ÙÍøÓÐdllÏÂÔØºÍÔ´´úÂë¡£
cb×Ô´øµÄ×é¼þûÓÐÖ§³ÖsqliteµÄ¡£ÓеÚÈý·½×é¼þ°üÖ§³ÖsqliteµÄ£¬Ãû×ÖÍüÁË¡£

sqliteÓÐ×Ô¼º°ü×°ºÃµÄsqlite3.dll£¬ÌṩÁ˵¼³ö½Ó¿Ú¸øÄãʹÓÃ
http://blog.donews.com/jetport/archive/2007/06/25/1179461.aspx

http://topic.csdn.net/u/20090427/10/47e56aae-0698-487e-903e-e6e1b14d6b72.html

лл¸÷λ´ó´ó»Ø¸´.
ÎÒÏÖÔÚÒѾ­¸ãºÃÁ˾²Ì¬Á´½Ó,²»ÐèÒªDLLÁË.
ÁíÍâÇëÎÊsqliteµÄsqlÓï¾äÊÇutf-8µÄ,»¹ÊÇansiµÄ?



ÒýÓÃ
µ÷Óýӿڲ»Í¬£¬¿ÉÒÔÑ¡ÔñUTF-8£¬Ò²¿ÉÒÔÑ¡ÔñUTF-16£¬Çë²Î¿´SQLiteµÄAPI
ÖÁÓÚÔÚCBÏÂʹÓ㬿ÉÒÔÓÃASQLite C++ ·â×°
Ò²¿ÉÒÔÑ¡Ôñ SQLite µÄ ODBC Çý¶¯ http://www.ch-werner.de/sqliteodbc/
ºÍ DISQLite3 µÈ

µ«ÊÇ SQLite ÔÚCBϵķâ×°£¬ºÃÏñ¶¼²»Ì«ÀíÏ룬ֱ½ÓÓÃAPIµÄ»°£¬»Øµ÷±È½ÏÂé·³£¬²»¹ý¼æÈÝÐԷdz£ºÃ£¬¶øÇÒÊý¾Ý¿â´æÈ¡³¬¿ì£¨ÄÚ´æÄ£Ê½Ï£©


Õâλ´ó´ó£¬Çë¸æËßÎÒSQLÓï¾äµÄUTF-16·½Ê½ÈçºÎµ÷Óã¿

{{----


Ïà¹ØÎÊ´ð£º

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

ÇósqlÓï¾ä£¬sqliteÊý¾Ý¿â

µç»°±¾Æ¥Åä²éѯ£¬Ï£ÍûÒ»ÌõÓï¾ä¸ã¶¨
 
¼ÙÉèºÅÂë±¾(numtable)ÈçÏÂ:

ºÅÂë(num)      ÁªÏµÈË (relationname)     
10086          ÒÆ ......

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


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

    @echo off
    echo ÕýÔÚϵͳÊý¾Ý¿â±¸·Ý£¬ÇëÉÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ