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

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ºÍÎÒ¹µÍ¨¡£


Ïà¹ØÎÊ´ð£º

sqlite ²»Ö§³Ölast()?


Java code:

stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery("select * from table");//±¨´íµÄÐÐ
rs.last()

ÓÃrs.last( ......

ʹÓ÷ÉÐÅÐéÄâ.net»·¾³£¬ÔÚʹÓÃSQLiteʱΪʲô±¨´íÄØ

C# code:

System.Data.SQLite.SQLiteConnection conn = new SQLiteConnection(@"acs.db");
try
{
conn.Open();
}
......

sqliteÊý¾Ý¿â²»ÄÜÁ¬Ðø´æÈëÊý¾ÝµÄÎÊÌâ

ÎÒÓÃevc±àдµÄ³ÌÐò£¬½«¶Ô»°¿òÖеÄÊý¾Ý´æÈëÊý¾Ý¿â£¬µÚÒ»´Î¿ÉÒÔ´æÈ룬²»¹ýµÚ¶þ´ÎÊäÈëµÄÊý¾Ý²»ÄÜ´æÈëµ½Êý¾Ý¿âÖС£
ÏÂÃæÊÇÎҵijÌÐò
UpdateData(TRUE); // TODO: Add your control notification handler code here ......

WM³ÌÐò²éѯSQLite¿â×Ü˵±í²»´æÔÚ

.netµÄ³ÌÐò£¬ÓõÄSystem.Data.SQLite DLL
¿âÊÇdb3µÄ£¬²éѯʱ×Ü˵no table **
·¾¶Ò²ÊǶԵÄ
¶øÄǸötableÊÇ´æÔÚµÄ
ÔÚPCÉÏÄÜ¿´µ½
ÇëÎÊÕâ¸öÊÇÔõô»ØÊÂÄØ£¿
ÊÖ»úÉÏÎļþʱûÓÐÏà¶Ô·¾¶µÄ¸ÅÄîµÄ£¬

±¨Ê²Ã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ