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

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 &


Ïà¹ØÎĵµ£º

SqliteÖÐÎÄÅÅÐòÑо¿

×ªÔØÊ±Çë×¢Ã÷³ö´¦ºÍ×÷ÕßÁªÏµ·½Ê½£ºhttp://blog.csdn.net/absurd
×÷ÕßÁªÏµ·½Ê½£ºLi XianJing <xianjimli at hotmail dot com>
¸üÐÂʱ¼ä£º2006-12-19
SqliteÊÇÒ»¸öÓÃCÓïÑÔʵÏÖµÄСÐÍSQLÊý¾Ý¿âÒýÇæ¡£ËüÌå»ýСÇɵ«¹¦ÄÜÇ¿´ó£¬¶ÔÓ²¼þ×ÊÔ´ÒªÇóºÜµÍ¶øÇÒÐÔÄܱíÏÖ׿Խ£¬·Ç³£ÊʺÏÓÚǶÈëʽӦÓû·¾³¡£×î½ü·¢ÏÖsqlite²¢²»Ö§³ÖÖÐÎ ......

ǶÈëʽÊý¾Ý¿âSQLiteÓëJava

ǶÈëʽÊý¾Ý¿âSQLiteÓëJava
SQLite×÷Ϊһ¸ö¿ªÔ´µÄǶÈëʽÊý¾Ý¿â²úÆ·£¬¾ßÓÐϵͳ¿ªÏúС£¬¼ìË÷ЧÂʸߵÄÌØÐÔ£¬ÊÊÓÃÓÚÊÖ»ú¡¢PDA¡¢»ú¶¥ºÐÉ豸µÈµçÆ÷£¬²¢ÇÒ×÷ΪǶÈëʽÊý¾Ý¿âÔÚ¿ÉÏÂÔØµÄÏû·ÑÀàÓ¦ÓóÌÐòÖÐÔËÐеĺܺá£ÕâÆªÎÄÕ½éÉÜǶÈëʽÊý¾Ý¿â²úÆ·SQLiteµÄ¼¼ÊõÌØµã£¬²¢×ÅÖØÌÖÂÛÑо¿ÓëJavaÓïÑÔÖ®¼äµÄ½Ó¿Ú£¬²¢ÒÔʵÀý˵Ã÷ÈçºÎʹÓÃJAVA¿ª· ......

sqliteµÄѧϰ±Ê¼Ç×ªÔØ

ǰÐò£º
Sqlite3 µÄÈ·ºÜºÃÓá£Ð¡ÇÉ¡¢Ëٶȿ졣µ«ÊÇÒòΪ·Ç΢ÈíµÄ²úÆ·£¬°ïÖúÎĵµ×ܾõµÃ²»¹»¡£ÕâЩÌìÔÙ´ÎÑо¿Ëü£¬ÓÖÓÐһЩÊÕ»ñ£¬ÕâÀï°ÑÎÒ¶Ô sqlite3 µÄÑо¿ÁгöÀ´£¬ÒÔ±¸Íü¼Ç¡£
ÕâÀïҪעÃ÷£¬ÎÒÊÇÒ»¸ö¿çƽ̨רעÕߣ¬²¢²»Ï²»¶Ö»Óà windows ƽ̨¡£ÎÒÒÔǰµÄ¹¤×÷¾ÍÊÇΪ unix ƽ̨д´úÂë¡£ÏÂÃæÎÒËùдµÄ¶«Î÷£¬ËäȻûÓÐÑéÖ¤£¬µ«ÊÇÎÒÒѾ¡ ......

sqlite½â¾öÖÐÎÄ·¾¶ÎÊÌâ


// sqlite½â¾öÖÐÎÄ·¾¶ÎÊÌâ,ÒÔǰÑо¿sqliteʱºòÓöµ½µÄÖÐÎÄ·¾¶ÎÊÌâµÄ½â¾ö·½·¨
// AnsiString cbÖеÄ×Ö·û´®Àà,ÆäËü±àÒëÆ÷ÓÃstd::stringÌæ»»¼´¿É.
// MultiByteToWideCharÊÇwindows api
AnsiString fileName;   
int strSize = fileName.Length();
char *ansi = new char[strSize+1];
wchar_t *unico ......

[ת]JavaÁ¬½ÓSQLite dbÊý¾Ý¿âÎļþ

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ