SQLITE´æÍ¼Æ¬
´ó¼ÒºÃ£¬ÇëÎʸ÷λ´óϺ£¬ËÓÐSQLITE´æÍ¼Æ¬Â·¾¶µÄ´úÂë»òÀý×Ó°¡£¬Çë°ïæ¸øÐ¡µÜ·¢Ò»¸ö£¬tiandaliubin@163.com ÕæµÄºÜ¼±°¡¡£ÏÈллÁË¡£
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
ÕâÀïÄĸöÊÇ´æÍ¼Æ¬µÄ°¡£¬Ó¢ÎIJ»ÊǺܺã¬Äܲ»ÄÜ˵µÄÇå³þÒ»µã
http://www.sqlite.com.cn/MySqlite/3/132.Html
aaa
°ÑͼƬÎļþÒÔ¶þ½øÖÆÊý¾ÝµÈ·½Ê½´æÈësqlite£¬¶ÁÈ¡³öÀ´ºó£¬ÔÙת»»³ÉͼƬ
blob×ֶοÉÒÔ´æ´¢¶þ½øÖÆÊý¾Ý
ͬÎÊ£¬ÎÒÒ²ÏëÖªµÀ£¬ÎÒÊǰÑͼƬÊý¾Ý´æ½øÈ¥µÄ£¬blob×ֶΣ¬ÇëÎÊoyljerry ÄãËù˵µÄ¶Á³öÀ´×ª»»µÈµÈ£¬ÔÚÄÄÀï¿ÉÒÔÕÒµ½²Î¿¼Ê¾ÀýÂð »òÊÇÄÄÀïÓн²½âÂð£¿
ллÀ²~
¶ÁÈ¡³öÀ´ºó£¬ÔÙת³ÉͼƬ¡£Õâ²½Äܲ»ÄÜ˵µÄÏêϸһЩ£¬ÔõÑù²ÅÄÜת»»³ÉͼƬ£¿
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¡
sqlite×Ö¶ÎΪfloatÐ͵ÄÖµÔõÑù·ÃÎÊ£¿
ÊÔ¹ýÓÃsqlite3_column_double£¬È··µ»ØµÄÊý¾Ý²»ÕýÈ·£»
ûÓùý,°ï¶¥.
Ò»Ñù°¡£¬·µ»ØÈ«ÊÇ string
ÄãµÄ´úÂëÊÇʲô£¿
double sqlite3_column_double(sqli ......
ÎÒÖªµÀ´ó¼Ò¶¼ËµÊÇ64λϵͳϲ»ÄÜÓÃ32λµÄsyste.sqlite.dll¡£Õâ¸öÎÒÒѾ»»ÁË
VS2008ÖÐÔËÐж¼Ã»ÎÊÌ⣨ͬһϵͳÏ£©
Ò»·Åµ½IISÖоͱ¨´í£º
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°System.Data.SQLite¡±»òËüµÄijһ¸öÒÀÀµÏî¡£ÊÔͼ¼ÓÔØ¸ ......
ÎÒÏëÔÚpdaÉÏÓÃSQLiteÊý¾Ý¿â£¬ÎÒ³ÌÐòÊÇqtдµÄ£¬µ«ÊÇÎÒÓ¦¸ÃÔõÑù½«SQLiteÒÆÖ²µ½winceƽ̨ÉÏÄØ£¬ÎÒÏÖÔÚÓÐÁËSQLite.dllºÍSQLite.lib£¬Ö®ºóÎÒ½»²æ±àÒëÉú³ÉÁË.exeÎļþ£¬ÎªÊ²Ã´ÔÚÄ£ÄâÆ÷Éϲ»ÄÜÔËÐÐÄØ£¿
ÆÚ´ýןßÊֻشð£¬Ð»Ð» ......
GUID£º0C3EDEE8-B14F-4220-8D64-990E00D84AF7
SELECT fldGuid, fldName, fldUserGuid from table
Äܲéѯ fldUserGuid Ϊ£º0C3EDEE8-B14F-4220-8D64-990E00D84AF7 µÄÊý¾ÝÒ»Ìõ
SELECT fldGuid, fldN ......
Êý¾Ý¿âÖÐÓÐÒ»¸öusers±í¡£
create table users(name text, number text);
Ñ»·²åÈëÒ»°ÙÌõ£¬²»Ê¹ÓÃÊÂÎñµÄ»°£¬ÔÚÎҵĻúÆ÷ÉÏÐèÒª6s¡£
¶øÔÚÎÒÅóÓѵĻúÆ÷ÉÏÕâÑùµÄ²Ù×÷»¨·Ñ²»µ½1s¡£
¿ÉÄÜÊÇÄÄ·½ÃæµÄÔÒòµ¼ ......