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

¹ØÓÚSQLite תÌû


×î½üÔÚÏîÄ¿ÖÐÓõ½ÁËSQLite¡£Ö÷ÒªÊǿͻ§¶ËÓõ½£¬ÕâÖÖСÐÍÄÚǶÊý¾Ý¿â»¹ÊÇÂùʵÓõġ£
ÌáÆðSQLiteÎÒ²»×Ô¾õµÄ¾ÍÏëÆðÁË΢Èí³öµÄACCESS¡£ËûÃÇÁ½¸öȷʵÊÇÓпɱÈÐԵġ£Ôø¾­£¬Ð¡ÐÍÍøÕ¾Êý¾Ý¿â£¬ASP¿ÉÒÔÓõ½ACCESS¡£µ«ÊÇ£¬PHPÈ´ÊÇûÓÐÏà¶ÔÓ¦µÄ½â¾ö·½°¸£¬×Ô´ÓSQLiteµÄ³öÏÖ£¬¸øPHPÌṩÁËÒ»¸ö½â¾ö·½°¸¡£
ÔÚ¿Í»§¶ËÀïÃæ£¬ÎÒÓõ½µÄÊý¾Ý±£´æ·½°¸ÓУºCSV¡¢INI¡¢XML¡£ÆäÖÐXMLÊÇ×îÇ¿´óµÄ£¬µ«ÊÇ¿ÉϧµÄÊÇÎÒÓõĽâÎöÆ÷ÊÇTinyxml£¬ÊµÓÃtinyxmlµÄ³õÖÔ¾ÍÊǼòµ¥£¬Ö»ÓÃÓÚÅäÖã¬ËùÒÔÔÙ¸´ÔÓµÄÊÂÇé¾ÍÓÐЩӦ¸¶²»¹ýÀ´¡£ÖÁÉÙ£¬Âß¼­ÉÏÒª¸´ÔÓÉÏÐí¶à¡£
ÎÒ×î½ü£¬¿´ÁËѸÀ×£¬Ëѹ·……һЩÈí¼þµÄĿ¼£¬¶¼ÓÐÒ»¸ösqlite3.dll¡£ÓÚÊǾÍÈ¥Á˽âÁËÏ¡£Ã²ËÆÏÖÔںܶàµÄimÈí¼þÓÃÕâ¸ö×ö¿Í»§¶ËÊý¾Ý¿âµÄÒ²¶àÆðÀ´ÁË¡£¿´ÆðÀ´Õâ¸öÏîÄ¿»¹ÊDz»´íµÄ¡£
SQLiteÓкü¸ÖÖ°æ±¾£¬Èç¹ûÒªÏëÄÚǶµ½Ó¦ÓóÌÐòµ±ÖÐÈ¥£¬ÄǾÍÒªÓÃsqlite-amalgamationÕâ¸ö°æ±¾ÁË¡£Ëü¾ÍÊÇÒ»¸öÍ·Îļþ£¬Ò»¸öcµÄʵÏÖÎļþ£¬Õâ¸öÎļþÀïÃæÓÐÊ®¶àÍòÐдúÂë¡£ÎÒÓÃVS2003±àÒëµÄʱºò£¬±àÒëÆ÷»áÌáÐÑÎÒ£¬ÐÐÊýÓÐЩ³¬³¤ÁË-_-!!
C++ÀïÃæ¶ÔSQLiteµÄ°ü×°Àà¿âÀïÃæ£¬ÎÒ¾õµÃSOCIËãÊǺܲ»´íµÄ£¬Õâ¸öÏîÄ¿²»½ö½öÊǶÔSQLite½øÐÐÁ˰ü×°£¬¶øÇÒ¶ÔÆäËûÊý¾Ý¿â¶¼Óаü×°£¬ÏñMySQL¡¢PostgreSQL¡¢OracleÕâЩÊý¾Ý¿â¶¼Ö§³Ö£¬»¹Ö§³ÖODBC¡£Èç¹û¸ÐÐËȤ¿ÉÒÔ¿´ÎÒ×ªÔØµÄһƪ²©ÎÄ£ºhttp://www.cppblog.com/tx7do/archive/2009/11/27/102054.html
“¹¤ÓûÉÆÆäÊ£¬±ØÏÈÀûÆäÆ÷¡£”
¼ÈÈ»ÊÇÊý¾Ý¿â£¬ÄÇÎÒ×ÔȻҪÓй¤¾ßÄܹ»±à¼­Êý¾Ý¿âÁË¡£ÎÒÕÒÁËÕÒSQLiteµÄÊý¾Ý¿â¹¤¾ß£¬Ò»ËÑÒ»´ó°Ñ¡£ÎÒÊÔÓÃÁ˺öàÖÖ£¬¶¼²»ÊǺܺÃÓá£×îÖÕ²ÅÈ·¶¨ÁËSQLite Expert Professional£¬Õâ¿îÉÌÒµÈí¼þ¡£µ±È»£¬ÎÒºÜÎ޳ܵÄÓÃÁËÆÆ½â°æ¡£ÆÆ½â°æÔÚwww.gougou.comÀïÃæ¾ÍÄÜËÑË÷µ½¡£ÎÒÊÇÇãÏòÓÚÓÿªÔ´Èí¼þµÄ£¬µ«ÊǺÜÎÞÄεÄÊÇ£¬ËäÈ»Ïà¹ØµÄ¹¤¾ßºÜ¶àºÜ¶à£¬µ«ÊǾÍûÓÐÒ»¿îÕæÕýºÃÓõġ£
ÎÒÔÚÓÃSQLite Expert´´½¨Êý¾Ý¿âµÄʱºò£¬·¢ÏÖÓÐÒ»¸öÑ¡Ôñ±àÂëµÄÑ¡Ïµ«ÊǺܿÉϧµÄÊÇÈ«²¿¶¼ÊÇUTFϵµÄ±àÂë……ÎÒϰ¹ßÐÔµÄÑ¡ÔñÁËUTF8£¬Õâ¸öÒ²ÊÇËüµÄĬÈÏÑ¡Ïî¡£ÎÒ´´½¨ÁËÒ»¸ö²âÊÔµÄÊý¾Ý¿â£¬Ëæ±ãŪÁ˸ö±í£¬´òÁ˼¸¸ö×Ö£¬È»ºó±£´æ¡£ÔÙÓÃVS2003×öÁËÒ»¸ö²âÊÔ³ÌÐò£¬½á¹û¶Á½øÀ´µÄÊÇÂÒÂë¡£ºóÀ´ÎÒ°ÑÊý¾Ý¿âÎļþ·Åµ½Ò»¸ö·¾¶ÀïÃæÓÐÖÐÎĵÄ·¾¶Ï£¬½á¹ûËüÕÒ²»µ½Îļþ£¬¿´À´ËüÍêÍêȫȫµÄʹÓÃÁËUTF×Ö·û£¬°üÀ¨¶Ô·¾¶µÄ´¦Àí¡£¿´ÆðÀ´£¬Ö»ÄÜתÂëÁË¡£ÒÔϸ½ÉÏÁ½¸öWindowsϵÄתÂëµÄ·½·¨£º
std::string UTF8ToAnsi( const std::stri


Ïà¹ØÎĵµ£º

[ÊÕ£] ÓÃsqlite Ö´Ðбê×¼ sql Óï·¨

http://www.umgr.com/blog/PostView.aspx?bpId=36294
 1. Ö´ÐÐsqlÓï¾ä
int sqlite3_exec(sqlite3*£¬ const char *sql£¬ sqlite3_callbacksql Óï·¨
£¬ void *£¬  char **errmsg );
Õâ¾ÍÊÇÖ´ÐÐÒ»Ìõ sql Óï¾äµÄº¯Êý¡£
µÚ1¸ö²ÎÊý²»ÔÙ˵ÁË£¬ÊÇÇ°Ãæopenº¯ÊýµÃµ½µÄÖ¸Õ롣˵ÁËÊǹؼüÊý¾Ý½á¹¹¡£
µÚ2¸ö²ÎÊýconst char ......

QtopiaÖÐʹÓÃSQLite×ܽἰSQLiteÖд洢ÖÐÎIJÙ×÷

¡¾¹¤×÷»·¾³£º»ùÓÚÓÑÉÆÖ®±Ûmini2440¿ª·¢°å+Qtopia2.2°æ±¾+RedHat9+SQLite-3.3.6¡¿
1.QtopiaÖÐʹÓÃSQLite
ÓÉÓÚQt2²»Ö§³ÖÊý¾Ý¿â²Ù×÷£¬£¨Qt3°æ±¾¾ÍÌṩÁËÖ§³ÖÊý¾Ý¿â²Ù×÷µÄÀ࣬µ«ÊÇQtopia2±È½Ï¾­µä£¬ÊÇ»ùÓÚQt2µÄ£¬Ã»°ì·¨£¡£©ËùÒÔÔÚQt/Qtopia³ÌÐòÖÐÐèÒªÊý¾Ý¿âʱ£¬¿ÉÒÔ¿¼ÂÇÔÚQtÖÐʹÓÃLinuxϲÙ×÷SQLiteÊý¾Ý¿âµÄ·½·¨¡££¨±í´ïµÄÓе ......

sqlite¿ÉÊÓ»¯IDE¹¤¾ß

 1. SQLite Database Browser ÊÇÒ»¸öSQLiteÊý¾Ý¿â¹ÜÀí¹¤¾ß¡£ÊÇ¿ªÔ´µÄ¡¢Ãâ·ÑµÄ¡£
Home Page
http://sqlitebrowser.sourceforge.net/
 
Download
http://sourceforge.net/project/showfiles.php?group_id=87946
 
Wiki
http://en.wikipedia.org/wiki/SQLite_Database_Browser
 
  2.  ......

Sqlite ǶÈëʽÊý¾Ý¿âÒÆÖ²ºÍʹÓÃ

 
1.    Ô´´úÂëµÄ»ñÈ¡
sqliteÊÇÒ»¸ö¹¦ÄÜÇ¿´ó¡¢Ìå»ýСÔËËãËÙ¶È¿ìµÄǶÈëʽÊý¾Ý¿â£¬²ÉÓÃÁËÈ«CÓïÑÔ·â×°£¬²¢ÌṩÁ˰ËÊ®¶à¸öÃüÁî½Ó¿Ú£¬¿ÉÒÆÖ²ÐÔÇ¿£¬Ê¹Ó÷½±ã¡£
ÏÂÔØµØÖ·£ºhttp://sqlite.org/download.html
sqliteÔ´´úÂ룺sqlite-3.6.17.tar.gz
2.    sqliteÒÆÖ²µ½x86 for linu ......

SQLite Tutorial in PHP

 
SQLite Tutorial in PHP
SQLite is an SQL database manager used locally or on a website, and compatible
in particularly with PHP.
Summary
Installing SQLite and creating a database
.
Installing SQLite. Verifying the installation by creating a base.
Creating and using a SQLite tabl ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ