¹ØÓÚ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ÓëJava
SQLite×÷Ϊһ¸ö¿ªÔ´µÄǶÈëʽÊý¾Ý¿â²úÆ·£¬¾ßÓÐϵͳ¿ªÏúС£¬¼ìË÷ЧÂʸߵÄÌØÐÔ£¬ÊÊÓÃÓÚÊÖ»ú¡¢PDA¡¢»ú¶¥ºÐÉ豸µÈµçÆ÷£¬²¢ÇÒ×÷ΪǶÈëʽÊý¾Ý¿âÔÚ¿ÉÏÂÔØµÄÏû·ÑÀàÓ¦ÓóÌÐòÖÐÔËÐеĺܺá£ÕâÆªÎÄÕ½éÉÜǶÈëʽÊý¾Ý¿â²úÆ·SQLiteµÄ¼¼ÊõÌØµã£¬²¢×ÅÖØÌÖÂÛÑо¿ÓëJavaÓïÑÔÖ®¼äµÄ½Ó¿Ú£¬²¢ÒÔʵÀý˵Ã÷ÈçºÎʹÓÃJAVA¿ª· ......
ǰÐò£º
Sqlite3 µÄÈ·ºÜºÃÓá£Ð¡ÇÉ¡¢Ëٶȿ졣µ«ÊÇÒòΪ·Ç΢ÈíµÄ²úÆ·£¬°ïÖúÎĵµ×ܾõµÃ²»¹»¡£ÕâЩÌìÔÙ´ÎÑо¿Ëü£¬ÓÖÓÐһЩÊÕ»ñ£¬ÕâÀï°ÑÎÒ¶Ô sqlite3 µÄÑо¿ÁгöÀ´£¬ÒÔ±¸Íü¼Ç¡£
ÕâÀïҪעÃ÷£¬ÎÒÊÇÒ»¸ö¿çƽ̨רעÕߣ¬²¢²»Ï²»¶Ö»Óà windows ƽ̨¡£ÎÒÒÔǰµÄ¹¤×÷¾ÍÊÇΪ unix ƽ̨д´úÂë¡£ÏÂÃæÎÒËùдµÄ¶«Î÷£¬ËäȻûÓÐÑéÖ¤£¬µ«ÊÇÎÒÒѾ¡ ......
SQLite ×÷Ϊһ¸öÇáÁ¿¼¶Ç¶ÈëʽÊý¾Ý¿â£¬»¹ÊǷdz£ºÃÓõġ£ÓêºÛ¼«Á¦ÍƼö~~~~~~
½ñÌìÓиöÅóÓѲâÊÔ SQLite£¬È»ºóµÃ³öµÄ½áÂÛÊÇ£ºSQLite ЧÂÊÌ«µÍ£¬ÅúÁ¿²åÈë1000Ìõ¼Ç¼£¬¾ÓÈ»ºÄʱ 2 ·ÖÖÓ£¡
ÏÂÃæÊÇËû·¢¸øÎҵIJâÊÔ´úÂë¡£ÎÒÔÎ~~~~~~
using System.Data;
using System.Data.Common;
using System.Data.SQLite;
......
1. Ô´´úÂëµÄ»ñÈ¡
sqliteÊÇÒ»¸ö¹¦ÄÜÇ¿´ó¡¢Ìå»ýСÔËËãËÙ¶È¿ìµÄǶÈëʽÊý¾Ý¿â£¬²ÉÓÃÁËÈ«CÓïÑÔ·â×°£¬²¢ÌṩÁ˰ËÊ®¶à¸öÃüÁî½Ó¿Ú£¬¿ÉÒÆÖ²ÐÔÇ¿£¬Ê¹Ó÷½±ã¡£
ÏÂÔØµØÖ·£ºhttp://sqlite.org/download.html
sqliteÔ´´úÂ룺sqlite-3.6.17.tar.gz
2. sqliteÒÆÖ²µ½x86 for linu ......
1¡¢Èç¹ûʹÓÃsqlite3ʱ³öÏÖÈçÏ´íÎó£º
/!\ FAILSAFE /!\ Thu Jul 30 22:16:15 +0800 2009
Status: 500 Internal Server Error
unknown error
c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `initialize'
c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `dlopen'
&nb ......