Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÓëJava

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

C#ÓëSqliteÊý¾Ý¿â²Ù×÷ʵÀý

ÕâÊÇÒ»¸öÓйطÖÒ³µÄʵÀý,½ö¹©²Î¿¼(´úÂëÀ´×ÔÍøÂç)
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SQLite;
using System.Threading;
using System.Collections;
us ......

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

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

[ÊÕ£] ÓÃ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 ......

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