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

SQLITE´æÍ¼Æ¬

´ó¼ÒºÃ£¬ÇëÎʸ÷λ´óϺ£¬Ë­ÓÐSQLITE´æÍ¼Æ¬Â·¾¶µÄ´úÂë»òÀý×Ó°¡£¬Çë°ïæ¸øÐ¡µÜ·¢Ò»¸ö£¬tiandaliubin@163.com ÕæµÄºÜ¼±°¡¡£ÏÈллÁË¡£
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

ÒýÓÃ
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
ÕâÀïÄĸöÊÇ´æÍ¼Æ¬µÄ°¡£¬Ó¢ÎIJ»ÊǺܺã¬Äܲ»ÄÜ˵µÄÇå³þÒ»µã

http://www.sqlite.com.cn/MySqlite/3/132.Html

aaa

°ÑͼƬÎļþÒÔ¶þ½øÖÆÊý¾ÝµÈ·½Ê½´æÈësqlite£¬¶ÁÈ¡³öÀ´ºó£¬ÔÙת»»³ÉͼƬ

blob×ֶοÉÒÔ´æ´¢¶þ½øÖÆÊý¾Ý

ÒýÓÃ
°ÑͼƬÎļþÒÔ¶þ½øÖÆÊý¾ÝµÈ·½Ê½´æÈësqlite£¬¶ÁÈ¡³öÀ´ºó£¬ÔÙת»»³ÉͼƬ

ͬÎÊ£¬ÎÒÒ²ÏëÖªµÀ£¬ÎÒÊǰÑͼƬÊý¾Ý´æ½øÈ¥µÄ£¬blob×ֶΣ¬ÇëÎÊoyljerry ÄãËù˵µÄ¶Á³öÀ´×ª»»µÈµÈ£¬ÔÚÄÄÀï¿ÉÒÔÕÒµ½²Î¿¼Ê¾ÀýÂð »òÊÇÄÄÀïÓн²½âÂð£¿
ллÀ²~

ÒýÓÃ
°ÑͼƬÎļþÒÔ¶þ½øÖÆÊý¾ÝµÈ·½Ê½´æÈësqlite£¬¶ÁÈ¡³öÀ´ºó£¬ÔÙת»»³ÉͼƬ
¶ÁÈ¡³öÀ´ºó£¬ÔÙת³ÉͼƬ¡£Õâ²½Äܲ»ÄÜ˵µÄÏêϸһЩ£¬ÔõÑù²ÅÄÜת»»³ÉͼƬ£¿


Ïà¹ØÎÊ´ð£º

ÊìϤSqliteµÄÇë½øÀ´£¡£¡£¡£¡£¡

´ó¼ÒºÃ£¡
  sqlite×Ö¶ÎΪfloatÐ͵ÄÖµÔõÑù·ÃÎÊ£¿
ÊÔ¹ýÓÃsqlite3_column_double£¬È··µ»ØµÄÊý¾Ý²»ÕýÈ·£»
ûÓùý,°ï¶¥.

Ò»Ñù°¡£¬·µ»ØÈ«ÊÇ string

ÄãµÄ´úÂëÊÇʲô£¿
double sqlite3_column_double(sqli ......

Win7ÏÂIIS·ÃÎÊSqliteÊý¾Ý¿â±¨´í

ÎÒÖªµÀ´ó¼Ò¶¼ËµÊÇ64λϵͳϲ»ÄÜÓÃ32λµÄsyste.sqlite.dll¡£Õâ¸öÎÒÒѾ­»»ÁË
VS2008ÖÐÔËÐж¼Ã»ÎÊÌ⣨ͬһϵͳÏ£©
Ò»·Åµ½IISÖоͱ¨´í£º
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°System.Data.SQLite¡±»òËüµÄijһ¸öÒÀÀµÏî¡£ÊÔͼ¼ÓÔØ¸ ......

sqliteÒÆÖ²wince

ÎÒÏëÔÚpdaÉÏÓÃSQLiteÊý¾Ý¿â£¬ÎÒ³ÌÐòÊÇqtдµÄ£¬µ«ÊÇÎÒÓ¦¸ÃÔõÑù½«SQLiteÒÆÖ²µ½winceƽ̨ÉÏÄØ£¬ÎÒÏÖÔÚÓÐÁËSQLite.dllºÍSQLite.lib£¬Ö®ºóÎÒ½»²æ±àÒëÉú³ÉÁË.exeÎļþ£¬ÎªÊ²Ã´ÔÚÄ£ÄâÆ÷Éϲ»ÄÜÔËÐÐÄØ£¿
ÆÚ´ýןßÊֻشð£¬Ð»Ð» ......

sqlite ÎÞ·¨¸ù¾ÝGuid ²éѯÊý¾Ý

GUID£º0C3EDEE8-B14F-4220-8D64-990E00D84AF7

SELECT fldGuid, fldName, fldUserGuid from table
Äܲéѯ fldUserGuid Ϊ£º0C3EDEE8-B14F-4220-8D64-990E00D84AF7 µÄÊý¾ÝÒ»Ìõ

SELECT fldGuid, fldN ......

¹ØÓÚsqliteÖ´ÐÐʱ¼äµÄÒÉÎÊ£¿

Êý¾Ý¿âÖÐÓÐÒ»¸öusers±í¡£
create table users(name text, number text);
Ñ­»·²åÈëÒ»°ÙÌõ£¬²»Ê¹ÓÃÊÂÎñµÄ»°£¬ÔÚÎҵĻúÆ÷ÉÏÐèÒª6s¡£ 
¶øÔÚÎÒÅóÓѵĻúÆ÷ÉÏÕâÑùµÄ²Ù×÷»¨·Ñ²»µ½1s¡£ 
¿ÉÄÜÊÇÄÄ·½ÃæµÄÔ­Òòµ¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ