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

SQLiteÊý¾Ý¿âµÄ¹Ò½Ó¼°³£ÓÃÃüÁî

°²×°:
¹Ù·½ÍøÕ¾ÏÂÔØ×îеÄsqlite°æ±¾
¹Ù·½ÍøÕ¾: http://www.sqlite.org/
ÏÂÔØµØÖ·Îª: http://www.sqlite.org/download.html
¹Ù·½µÄÏÂÔØÒ³ÃæÌṩÁËºÜ¶à°æ±¾µÄÏÂÔØ…ÕâÀï½éÉÜÒ»ÏÂ;
Source Code: Ô´´úÂë°æ±¾µÄÏÂÔØ
Documentation:  Ïà¹ØÎĵµ
Precompiled Binaries for Linux / Precompiled Binaries For Mac OS X /
Precompiled Binaries For Windows
Linux/Mac/Win°æ±¾µÄÔ¤±àÒë°æ±¾
Èç¹ûÄãÖ»ÊÇÊý¾Ý¿âµÄÓû§ÄÇôÏÂÔØÒѾ­±àÒëºÃµÄ°æ±¾¼´¿É! ÕâÀïÎÒÊÇWinÓû§,ÏÂÔØµÄÎļþΪ: sqlite3.exe
½«Õâ¸öÎļþ·Åµ½Ò»¸öĿ¼ÖÐ,ÕâÑù¾ÍÍê³ÉÁËÈ«²¿µÄsqliteÊý¾Ý¿âµÄ°²×°!
н¨:
ÔÚÃüÁîÌáʾ·ûÏÂ($ΪshellÌáʾºÅ), ²âÊÔµÄsqlite3.exe·¾¶Îªe:\sqlite3\sqlite3.exe
ÍøÉÏÒ²ÌṩÁ˺ܶ෽·¨,µ«ºÃÏó¶¼ÓеãÎÊÌâ,¾­¹ýÃþË÷½áÂÛΪÒÔϼ¸ÖÖ·½·¨,µ«²»È·¶¨ÊÇ·ñÊܲÙ×÷ϵͳϵͳӰÏì!
Éú³ÉÊý¾Ý¿âÎļþºó¹Ò½Ó
$> sqlite3.exe test.db ;
$> sqlite3.exe test.db
Ö±½Ó¹Ò½ÓÉú³É
$> sqlite3.exe test.db;
Ñ¡ÔñÐÔ¹Ò½Ó ÌôÑ¡ÒѾ­´æÔÚµÄÊý¾ÝÎļþ¹Ò½Ó
$> sqlite3.exe test.db »òÕß
$> sqlite3.exe e:\sqlite3\test.db
¹Ò½ÓºÃÊý¾Ý¿âºó,¾Í¿ÉÒÔͨ¹ýÃüÁîÐеÄÐÎʽ¶ÔËù¹Ò½ÓµÄÊý¾Ý¿â²Ù×÷ÁË!
   Cmd ½øÈëÃüÁîÐÐ
   1)
   ´´½¨Êý¾Ý¿âÎļþ:
   >SQLite3 d:\test.db »Ø³µ
   ¾ÍÉú³ÉÁËÒ»¸ötest.dbÔÚdÅÌ¡£
   ÕâÑùͬʱҲSQLite3¹ÒÉÏÁËÕâ¸ötest.db
   2)
   ÓÃ.help¿ÉÒÔ¿´¿´ÓÐʲôÃüÁî
   >.help »Ø³µ¼´¿É
   3)¿ÉÒÔÔÚÕâÀïÖ±½ÓÊäÈëSQLÓï¾ä´´½¨±í¸ñ ÓÃ;½áÊø£¬È»ºó»Ø³µ¾Í¿ÉÒÔ¿´µ½ÁË
   4)¿´¿´Óд´½¨Á˶àÉÙ±í
   >.tables
   5)¿´±í½á¹¹
   >.schema ±íÃû
   6)¿´¿´Ä¿Ç°¹ÒµÄÊý¾Ý¿â
   >.database
   7)Èç¹ûÒª°Ñ²éѯÊä³öµ½Îļþ
   >.output ÎļþÃû
   > ²éѯÓï¾ä£»
   ²éѯ½á¹û¾ÍÊä³öµ½ÁËÎļþc:\query.txt
   °Ñ²éѯ½á¹ûÓÃÆÁÄ»Êä³ö
   >.output stdout
   8)°Ñ±í½á¹¹Êä³ö£¬Í¬Ê±Ë÷ÒýÒ²»áÊä³ö
     .dump ±íÃû
   9)Í˳ö
   >.exit »òÕß.quit
sqlite¹Ù·½°ïÖúÌáʾÐÅÏ¢£º
sqlite> .help
.help
.bail ON|OFF 


Ïà¹ØÎĵµ£º

sqliteºÍpdo mysqlµÄÊý¾Ý¿â²Ù×÷

½ñÌìµÄѧϰÄÚÈÝÊÇsqliteºÍPDO mysql¡£
ÓÃ×Ô¼ºµÄ»°ËµËµÁ½¸ö¶«Î÷°É£º
sqliteËãÊÇÒ»ÖÖ²»ÏµÍ³µÄÊý¾Ý¿â´æ´¢·½Ê½£¬ËüµÄ´æ·Å¸ñʽÊÇÒ»¸ö.dbºó׺µÄÎļþ£¬ÔÚphpÖÐËü´æ·ÅÔÚµ±Ç°µÄĿ¼Ï£¬Ã²ËƲ»ÓÃÓû§ÃûÃÜÂ룬°²È«ÐԽϵͣ¬È´±È½Ï·½±ã¡£PHP5ÖÐ×Ô´øµÄһЩϵͳº¯Êý£¬¶¼ÊÇÒÔsqlite_¿ªÍ·µÄ¡£
PDOÈ«³ÆPHP Data Object£¬¹ËÃû˼Òå¾ÍÊÇPHPµÄÒ ......

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

ÓÃvs2008±àÒë³ösqlite dllºÍlib (ͼ½â)

1£º´ÓsqliteµÄ¹ÙÍøÉÏÏÂÔØÔ´Âë http://www.sqlite.org/download.html
2£º´ò¿ªvs2008¹¤³Ìн¨Ò»¸ö¿ÕµÄdll¹¤³Ì¡£
3£º°Ñsqlite3.h,sqlite3.cpp,sqlite3.def·Ö±ð¼ÓÈëµ½head file ºÍsource fileÏ¡£
4£º±àÒë³ÌÐò¡£ ÕâʱֻÄܵõ½sqlite3.dllÎļþ¡£
5£º´ò¿ªvs2008×Ô´øµÄÃüÁîÐУº Çе½sqlite3.defËùÔÚµÄĿ¼¡£
 
6£ºÔËÐÐ ......

SQLite DatabaseÅжÏÊÇ·ñ´æÔÚ¡¢Ð½¨¡¢É¾³ý.....

¡¡Android SQLite Database±¾´òËã·â×°SQLiteµÄ£¬µ«ÊÇ£¬·¢ÏÖʵ¼ÊÉÏAndroidÒѾ­·â×°ÁËÒ»²ã£¬ÓÈÆäÊÇÊý¾ÝµÄÔö¡¢É¾¡¢²é¡¢¸ÄÉÏ£¬¸üÊÇÈç´Ë£¬ËùÒÔ£¬ÎÒºóÀ´Ö»·â×°ÁËÒ»¸öÁ¬½Ó²ã£¬¸ºÔð´ò¿ª¡¢½¨Á¢Êý¾Ý¿â£¬²¢·µ»ØÒ»¸öSQLiteµÄʵÀýÓÃÀ´Íê³ÉÔö¡¢É¾¡¢²å¡¢¸ÄµÈ²Ù×÷¡£
//----------- DBHelper -------------
package utility.db;
import ja ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ