Sqlite ǶÈëʽÊý¾Ý¿âÒÆÖ²ºÍʹÓÃ
1. Ô´´úÂëµÄ»ñÈ¡
sqliteÊÇÒ»¸ö¹¦ÄÜÇ¿´ó¡¢Ìå»ýСÔËËãËÙ¶È¿ìµÄǶÈëʽÊý¾Ý¿â£¬²ÉÓÃÁËÈ«CÓïÑÔ·â×°£¬²¢ÌṩÁ˰ËÊ®¶à¸öÃüÁî½Ó¿Ú£¬¿ÉÒÆÖ²ÐÔÇ¿£¬Ê¹Ó÷½±ã¡£
ÏÂÔØµØÖ·£ºhttp://sqlite.org/download.html
sqliteÔ´´úÂ룺sqlite-3.6.17.tar.gz
2. sqliteÒÆÖ²µ½x86 for linux
l ½âѹÎļþ
//´´½¨Ò»¸öÎļþ¼Ð£¬½«Ô´´úÂë·ÅÔÚÕâ¸öÎļþ¼ÐÖС£
mkdir /work/sqlite
cp sqlite-3.6.17.tar.gz /work/sqlite
//½âѹÎļþ
cd /work/sqlite
tar xvzf sqlite-3.6.17.tar.gz
l ÅäÖÃ
//½¨Á¢x86Ŀ¼
mkdir sqlite_x86
//´ò¿ªÎļþ
cd sqlite-3.6.17
//ÅäÖÃsqlite
./configure --prefix=/work/sqlite/sqlite_x86 --disable-tcl
l ±àÒë
make
l °²×°
make install
l ²âÊÔ
µ±°²×°Íê³ÉÒԺ󣬰²×°Îļþ»á°²×°ÔÚ/work/sqlite/sqlite_x86Ŀ¼ÖУ¬Ò»ÖÖ²úÉúÁË£¬lib,includeºÍbinÈý¸öÎļþ¼Ð£¬·Ö±ðÊÇ¿âÎļþ£¬Í·ÎļþºÍ¿ÉÖ´ÐÐÎļþ¡£
µ½ÕâÀïÊDz»ÊÇÓеãÔ¾Ô¾ÓûÊÔÁË£¬Êǵģ¬ÎÒÃÇ¿ÉÒÔ²âÊÔsqliteÁË£¬µ±Îļþ°²×°ºó£¬ÎÒÃÇ¿ÉÒÔÖ±½Óͨ¹ý°²×°ºÃµÄsqlite3À´ÊµÏÖ¡£
cd sqlite_x86/bin
./sqlite3 test.db //´ò¿ª»ò´´½¨test.dbÊý¾Ý¿âÎļþ
create table test (id integer primary key, value text); //´´½¨±í¸ñºÍ×Ö¶ÎÃû
insert into test (value) values('hxl'); //Ìí¼ÓÒ»ÌõÊý¾Ý
insert into test (value) values('sqlite'); //Ìí¼ÓÒ»ÌõÊý¾Ý
insert into test (value) values('test'); //Ìí¼ÓÒ»ÌõÊý¾Ý
insert into test (value) values('for'); //Ìí¼ÓÒ»ÌõÊý¾Ý
insert into test (value) values('linux'); //Ìí¼ÓÒ»ÌõÊý¾Ý
//µ½´ËÊý¾Ý¿â»ù±¾¼ÒÀï¾ÍÍê³ÉÁË£¬À´¿´¿´Êý¾Ý¿âÀïÃæµÄÎļþ°É
.mode col
.headers on //´òÓ¡³öÊý¾Ý¿âµÄ±íÍ·
select * from test; //ÏÔʾÊý¾Ý¿âÖеÄËùÓÐÎļþ
.exit //Í˳ö
3. sqliteÒÆÖ²µ½arm
l ÅäÖÃ
//½¨Á¢x86Ŀ¼
mkdir ../../sqlite_arm
//´ò¿ªÎļþ
cd ../../sqlite-3.6.17
//ÅäÖÃsqlite
./configure --prefix=/work/sqlite/sqlite_arm --disable-tcl —host=arm-linux
l ±àÒë
make
l &
Ïà¹ØÎĵµ£º
1¡¢SQLite¼ò½é
¡¡¡¡SQLiteµÚÒ»¸öAlpha°æ±¾µ®ÉúÓÚ2000Äê5ÔÂ. ÖÁ½ñÒѾÓÐ4¸öÄêÍ·ÁË. SQLiteÒ²ÓÀ´ÁËÒ»¸ö°æ±¾ SQLite 3ÒѾ·¢²¼.
¡¡
¡¡SQLiteÊÇÒ»¿îÇáÐ͵ÄÊý¾Ý¿â£¬ÊÇ×ñÊØACIDµÄ¹ØÁªÊ½Êý¾Ý¿â¹ÜÀíϵͳ£¬ËüµÄÉè¼ÆÄ¿±êÊÇǶÈëʽµÄ£¬¶øÇÒĿǰÒѾÔںܶàǶÈëʽ²úÆ·ÖÐʹÓÃÁËËü£¬ËüÕ¼ÓÃ×Ê
Ô´·Ç³£µÄµÍ£¬ÔÚǶÈëʽÉ豸ÖУ¬¿ÉÄÜÖ»ÐèÒª ......
ǶÈëʽÊý¾Ý¿âSQLiteÓëJava
SQLite×÷Ϊһ¸ö¿ªÔ´µÄǶÈëʽÊý¾Ý¿â²úÆ·£¬¾ßÓÐϵͳ¿ªÏúС£¬¼ìË÷ЧÂʸߵÄÌØÐÔ£¬ÊÊÓÃÓÚÊÖ»ú¡¢PDA¡¢»ú¶¥ºÐÉ豸µÈµçÆ÷£¬²¢ÇÒ×÷ΪǶÈëʽÊý¾Ý¿âÔÚ¿ÉÏÂÔØµÄÏû·ÑÀàÓ¦ÓóÌÐòÖÐÔËÐеĺܺá£ÕâÆªÎÄÕ½éÉÜǶÈëʽÊý¾Ý¿â²úÆ·SQLiteµÄ¼¼ÊõÌØµã£¬²¢×ÅÖØÌÖÂÛÑо¿ÓëJavaÓïÑÔÖ®¼äµÄ½Ó¿Ú£¬²¢ÒÔʵÀý˵Ã÷ÈçºÎʹÓÃJAVA¿ª· ......
×î½üÓÉÓÚÏîÄ¿ÐèÒª£¬ ÒªÔÚwince4.2, wince5.0, mobileÈýÖÖ»úÐÍÉÏÃæ×ö´óÊý¾ÝÁ¿µÄ²éѯ£¬³õ²½¹À¼ÆÔÚ50W-500WÌõ¼Ç¼֮¼ä¡£
ÓÉÓÚÒÔǰ×ömobile5µÄÊý¾Ý¿âÏîÄ¿Ö÷ÒªÊDzÉÓÃC#À´Ð´£¬¶øÇÒÊý¾ÝÁ¿Ò²¶¥¶à¼¸ÍòÌõ£¬ËùÒÔ£¬ÎªÁËÈ·±£ÏîÄ¿ºóÆÚÉÙ×ßÍä·£¬ÎÒÌØÒâ×öÁËÒ»ÏÂÒÆ¶¯Êý¾Ý¿âÐÔÄܲâÊÔ¡£ÏÂÃæÊÇÕâÖܵŤ×÷¼Ç¼¡£¹©´ó¼Ò²Î¿¼¡£
Ò». ÓÉÓÚwince4.2 ......
JavaÁ¬½ÓSQLiteÊý¾Ý¿âÏê½â ÏÂÔØSQLiteÊý¾Ý¿âµÄJDBC ÕâÀï¸ø³öÒ»¸öÖÐÎÄÕ¾µãµÄURL: ÉèÖû·¾³±äÁ¿£º ½«ÏÂÔØµ½µÄ°ü½âѹºóµÃµ½jar°ü sqlitejdbc-v033-nested.jar ·Åµ½%JAVA_HOME%\lib Ï£¬²¢ÇÒ½«ÆäÌí¼Óµ½classpathϵͳ»·¾³±äÁ¿ÖÐ,ÎÒµÄclasspathϵͳ»·¾³±äÁ¿ÏÖÔÚΪ: .;%JAVA_HOME%\lib;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\li ......
SQLite ×÷Ϊһ¸öÇáÁ¿¼¶Ç¶ÈëʽÊý¾Ý¿â£¬»¹ÊǷdz£ºÃÓõġ£ÓêºÛ¼«Á¦ÍƼö~~~~~~
½ñÌìÓиöÅóÓѲâÊÔ SQLite£¬È»ºóµÃ³öµÄ½áÂÛÊÇ£ºSQLite ЧÂÊÌ«µÍ£¬ÅúÁ¿²åÈë1000Ìõ¼Ç¼£¬¾ÓÈ»ºÄʱ 2 ·ÖÖÓ£¡
ÏÂÃæÊÇËû·¢¸øÎҵIJâÊÔ´úÂë¡£ÎÒÔÎ~~~~~~
using System.Data;
using System.Data.Common;
using System.Data.SQLite;
......