SQLiteѧϰ±Ê¼Ç£¨2£©
ÔÙ˵ÔÚlinuxϽ¨Á¢.a ºÍµãso
µ½ÍøÕ¾ÏÂÔØ sqlite-amalgamation-3.6.22.tar.gz Õâ¸ö°ü£¬·´ÕýÎÒÏÂÁËsqlite3-3.6.22.bin.gz½âѹºó±àÒë²»ÁË¡£
½âѹ£¬ÔËÐÐ
# ./configure --host=armv5l-linux --prefix=/opt/sqlite3/arm --enable-threadsafe.
--host=armv5l-linux±íʾËùÓÃµÄÆ½Ì¨¡£Èç¹ûÊÇx86ƽ̨£¬¾Í²»ÓüÓÕâ¾ä»°£¬×¢Òâ,ÎҵıàÒëÆ÷ÊÇarmv5l-linux-gcc,Èç¹ûÓõıàÒëÆ÷ÊÇarm-linux-gcc,ÄÇôӦ¸ÃÊäÈë--host=arm-linux¡£
--prefix=/opt/sqlite3/arm¡£±íʾ°²×°Â·¾¶£¬Èç¹û²»ÊäÈ룬°²×°Ê±×°µ½Òþ²ØÄ¿Â¼¡£
--enable-threadsafe.ÔÊÐí¶àÏ̡߳£
#make
#make install
ÔÚarm/libÏÂÓÐÁË*.so ºÍ *.a ÁË£¬ÅäºÏsqlite3.h ,¾Í¿ÉÒÔµ÷ÓÃSQLTEµÄ½Ó¿ÚÁË¡£
Ïà¹ØÎĵµ£º
ÒªÓÃASPÀ´²Ù×÷SQLiteÊý¾Ý¿â£¬Ç°ÌáÌõ¼þÊÇÔÚ·þÎñÆ÷Éϵð²×°SQLiteµÄODBCÇý¶¯³ÌÐò£¬¿Éµ½Õâ¸öÕ¾µãÉÏÏÂÔØ°²×°£ºhttp://www.ch-werner.de/sqliteodbc/£¬°²×°ºÃºó¾Í¿ÉÒÔÏñʹÓÃAccessÒ»ÑùÀ´Ê¹ÓÃSQLiteÁË£¡Ï±ßÊÇÒ»¸öSQLiteÊý¾Ý¿â½á¹¹£º
ÒýÓÃÄÚÈÝ
Create TABLE admin(username text,age integer);
ÎÒÃÇÔÙÀ´ÓÃASPÑÝʾÏÂÈçºÎ¶ÔSQLi ......
SQLite3ÊÇSQLiteÒ»¸öȫеİ汾,ËüËäÈ»ÊÇÔÚSQLite 2.8.13µÄ´úÂë»ù´¡Ö®ÉÏ¿ª·¢µÄ,µ«ÊÇʹÓÃÁ˺Í֮ǰµÄ°æ±¾²»¼æÈݵÄÊý¾Ý¿â¸ñʽºÍAPI. SQLite3ÊÇΪÁËÂú×ãÒÔϵÄÐèÇó¶ø¿ª·¢µÄ:
Ö§³ÖUTF-16±àÂë.
Óû§×Ô¶¨ÒåµÄÎı¾ÅÅÐò·½·¨.
¿ÉÒÔ¶ÔBLOBs×ֶν¨Á¢Ë÷Òý.
Òò´ËΪÁËÖ§³ÖÕâÐ©ÌØÐÔÎҸıäÁËÊý¾Ý¿âµÄ¸ñʽ,½¨Á¢ÁËÒ»¸öÓë֮ǰ°æ±¾²»¼æÈݵ ......
»¹Êdzõ̽£¬×öµÄÏîĿҪÓõ½ÇáÇɵı¾µØÊý¾Ý¿â£¬ÓÚÊÇÕÒÁË sqlite 3 ÊÔÓÃÖ®£¬»¹²»´í£¬¹»ÇáÇÉ¡£
ÉÏÕâ¶ùÈ¥ÏÂÔØ³ÌÐòºÍ²é¿´Îĵµ£º http://www.sqlite.org/download.html
Õâ»Ø¿ª·¢ÓõÄÊÇ C#£¬ÓÚÊÇÕÒÁ˸ö.NETµÄ¿â Finisar.SQLite £¬µ½Õâ¶ùÈ¥ÔØ http://adodotnetsqlite.sourceforge.net/
Òª¼ÇµÄÒ²²»ÊÇʲô´ó²»Á˵Ķ«Î÷£¬Ê¾ÀýÍøÕ¾É϶ ......
ÎÒÏÖÔÚʹÓõÄÊÇDatalogic µÄmemorɨÃèÆ÷(intel XScale PXA255@200MHz,ϵͳÄÚ´æ 64M,ϵͳÉÁ´æ
128M)£¬²Ù×÷ϵͳΪWinCE
5.0,Êý¾Ý¿âΪSqlite3£¬ÔÚ.net»·¾³ÏÂÃæÓÐûÓпÉÄÚ½«Ò»¸ö20ÍòÐÐÊý¾ÝµÄtxtÎļþ¶Á³ö²¢Ð´µ½SqliteÊý¾Ý¿âÖÐ?
ÎÒÏÖÔÚµÄ×ö·¨ÊÇ£ºÖðÐжÁ³öÎļþÄÚÈÝ£¬·Ö¸îÊý¾Ýºó×÷Ϊ²ÎÊý£¬ÓÃdc.Parameters.add()·½·¨¼ÓÈëSQLiteC ......