sqliteÒÆÖ²ÎÊÌâ
ÎÒÏÖÔÚÊÖÍ·ÓÐÕâôһ¸öÎÊÌ⣬ÎÒÏëÈÃÒ»¸ö²Ù×÷sqlite3µÄ³ÌÐòÔÚÒ»¸öARM°å×ÓÉÏÅÜÆðÀ´£¬°å×ÓÉϵÄosÊÇwince5.0¡£
ÎÒÊÇÕâô×öµÄ£¬ÎÒÏÈ´Ósqlite3Ö÷Ò³ÏÂÔØÔ´ÂëÏÂÀ´£¬ÓÐÕâô3¸öÎļþ£ºsqlite3.c¡¢sqlite3.h¡¢sqlite3ext.h £¬»¹ÓÐÒ»¸ö½Ðsqlitedll-3_6_16.zipµÄѹËõ°ü£¬ÀïÃæ°üÀ¨sqlite3.def¡¢sqlite3.dll£¨¹ÙÍøÏÂÔØÌáʾ˵Õâ¸ödllÊÇfor windowsµÄ£©
È»ºó¸ù¾ÝÒÆÖ²QtµÄ¾Ñ飬ÎÒÏëÓ¦¸ÃÊÇÔÚ½»²æ±àÒëÇ°£¬½«LINKÊôÐÔÄÚµÄÒÀÀµÏî¼ÓÉÏARMƽ̨µÄsqlite3.libÎļþ£¨Õâ¸ö¿âÎļþ£¬ÎÒÓÃvcÏÂbinĿ¼ÖеÄlib.exe³ÌÐò¸ù¾Ýsqlite3.defÎļþ£¬È»ºóÖ¸¶¨MACHINE:ARMÉú³ÉµÄ£©£¬È»ºó½«±àÒëÉú³ÉºÃµÄexe³ÌÐòÓëÏà¹ØµÄdll¿½±´µ½°å×ÓÉϼ´¿É¡£
ÓÚÊÇÎÒÒ²¾ÍÕâô×öÁË£¬½«ËùÐèÒªµÄdllÓëÉú³ÉµÄexe¿½±´µ½°å×ÓÉÏÔËÐУ¬½á¹ûÌáʾ¸ÃÓ¦ÓóÌÐò²»ÊÇÓÐЧµÄwindows ceµÄÓ¦ÓóÌÐò¡£ÎÒ²ÂÏëÎÊÌâ¿ÉÄܳöÔÚsqlite3.dllÉÏ£¬ËùÒԾͽ«¸Õ²ÅÄǸö³ÌÐòÈ¥µô¶ÔÊý¾Ý¿âµÄËùÓвÙ×÷£¬ÒÔ¼°Ïà¹ØµÄÒÀÀµÏÔÙ´ÎÉú³Éexe¿½±´µ½°å×ÓÉÏ£¬½á¹ûÔËÐгɹ¦¡£
ÓÚÊÇÎÒÎÊÁ˼¸¸öʦÐÖ£¬È·ÈÏÁËÒ»´ÎÎҵIJÂÏ룺ÐèÒª¶ÔӦƽ̨ÉϵÄdll¡£ÓÚÊÇÎÒÏëµ½ÄãÉÏ¿ÎÌáµ½¿ÉÒÔÓÃIDEÉú³Édll£¬ÓÚÊÇÎÒʹÓÃvs¡¢evc£¬½á¹û×ÜÊǸ÷ÖÖ´íÎóµ¼ÖÂʧ°Ü¡£
²»ÖªµÀÎÒÕâô¸ö˼·¶Ô²»¶Ô£¬ÊÇ·ñÊÇÐèÒª×Ô¼ºÉú³ÉËùÐèµÄdll£¿Í¨¹ý¹Ù·½ÌṩµÄÕâЩԴ´úÂëºÍÎļþÓÖÈçºÎÉú³ÉËùÐèµÄdllÄØ£¿ÊÇ·ñÓÐÏà¹ØµÄÎĵµ×ÊÁÏ¿ÉÒԲο¼£¿
ss
×Ô¼º±àÒë¾ÍºÃÁË£¬
¾ßÌå¿´ÎҵIJ©ÎÄ°É¡£¡£ºÇºÇ
http://blog.csdn.net/ExclusivePig/archive/2009/09/18/4566255.aspx
Ï£Íû¶ÔÄãÓÐËù°ïÖú
ÒѾ½â¾ö£¬ÓÐÎÊÌâ¿ÉÒÔ·¢luohui8891@gmail.comºÍÎÒ¹µÍ¨¡£
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚ¿ªÊ¼×öÒ»¸öÐÂÏîÄ¿,ÐèÒªÊÇÓÃEVC+SqliteµÄ»·¾³,µ«ÎÒûÓùýSqlite,Çë´ó¼Ò¸øµã½¨Òé,лл!!
sqlite ºÜ¼òµ¥£¬Ö±½Óµ½ËüµÄ¹ÙÍøÏÂÔØ sqlite3.exe ¾ÍÐÐÁË£¬ÆäËüʲô¶¼²»ÐèÒª¡£
È»ºó¾ÍÊÇÏÂÔØÄãÐèÒªµÄÇý¶¯¡£
µ±ÄúµÄ ......
ÔõôÈÃsqliteÖ§³ÖÖÐÎÄ,˽â¾öÁ˾͸øËû100·Ö
ÄѵÀSQLITE²»Ö§³ÖÖÐÎÄÂ𣿣¿£¿£¿£¿£¿£¿£¿
¶ÁÈ¡³öÀ´Ê±ÂÒÂë
ÕâÑùÊÔÊÔ
C# code:
using System.Data;
using System.Data.SQLite;
//...
using (SQLiteConnec ......
mdb.execDML(L"insert into faultcode values('stu.szNumber', 'stu.szName','stu.szReason', 'stu.szStep')");
ÎÒÏë°Ñ½á¹¹Ìå±äÁ¿stu.szNumberÖеÄÄÚÈÝ´æ´¢µ½Êý¾Ý ......
visual studioÏÂÔÚwmÄ£ÄâÆ÷À³ÌÐò²Ù×÷sqlite¶¼Ê§°Ü£¬µ«ÔÚÊÖ»úÉÏûÎÊÌ⣬´ó¼ÒÆձ鶼ÊÇÕâÑùÂð£¿ËÓнâ¾ö°ì·¨£¿±Ï¾¹ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔЧÂʱȽϸߡ£
¶÷£¬²»»á°¡£¬PPCµÄÄ£ÄâÆ÷ÊÇ¿ÉÒԵİ¡..
ÒýÓÃ
¶÷£¬²»»á°¡£¬PPCµÄÄ ......
C# code:
public static bool UpdateFriendUrl(int id, string cnName, string jpName, string logoUrl, string site, int order)
{
string sql = "update FriendUrl set SiteNameCN=@SiteNameC ......