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

help£¡SQLiteÖвÙ×÷blobÀàÐ͵Ä×ֶεÄÎÊÌâ

ÕâÊÇÎҲ鵽µÄ×ÊÁÏ
http://www.cppprog.com/2009/0108/43.html ÒѾ­´æ½øÍ¼Æ¬ÁË£¬ÏÖÔÚ×öµ½ÕâÒ»²½ÁË£¬
¡°ÕâʱÊý¾Ý¿âµ±ÖÐÒѾ­ÓÐÁËÒ»Ìõ°üº¬BLOB×ֶεÄÊý¾Ý¡£½ÓÏÂÀ´ÎÒÃÇÒª¶ÁÈ¡ÕâÌõÊý¾Ý£º  1.  //ѡȡ¸ÃÌõÊý¾Ý
  2. sqlite3_prepare(db, "select * from list;", -1, &stat, 0);
  3. sqlite3_step(stat);
  4. //µÃµ½¼Í¼ÖеÄBLOB×Ö¶Î
  5. const void * test = sqlite3_column_blob(stat, 1);
  6. //µÃµ½×Ö¶ÎÖÐÊý¾ÝµÄ³¤¶È
  7. int size = sqlite3_column_bytes(stat, 1);
  8. //¿½±´¸Ã×Ö¶Î
  9. sprintf(buffer2, "%s", test);¡±
ÇëÎÊ ±àÒëµÄʱºò ×îºóµÄbuffer2䶨Ò壬ÓдíÎó£¬ÎÒÓ¦¸ÃÈçºÎÐ޸ģ¿ÎÒÏë°ÑͼƬÏÔʾ³öÀ´£¬Ó¦¸ÃÏÔʾµ½Ê²Ã´¿Ø¼þÖÐÂð£¿Ó¦¸ÃÔõôÏÔʾ³öÀ´°¡£¿

´ó¼Ò°ïæ¿´¿´£¡¸Ð¼¤°¡£¡£¡ÎÊÌâ½â¾ö¿ÉÒÔ¼Ó ·Ö~~
»¹ÊÇÕâ¸öÎÊÌâÓ¦¸Ã·¢µ½±ðµÄʲô°æ£¿


ÒýÓÃ
buffer2 Ϊ¶¨Ò壬ÐèÒªÏȶ¨Òå¡£

buffer2 Ó¦¸ÃÊÇÒ»¸ö×Ö·ûÖ¸ÕëÀàÐ͵ÄÒ»¸öÄÚ´æÇøÓò£¬¿ÉÒÔʹÓÃÊý×飬»òÕßmollocÒ»¿éÄÚ´æ¡£

ÕâÐèÒª¿´ÄãËù¶ÁÈ¡µÄ×Ö·û´®µÄ³¤¶È¶ø¶¨¡£

ÀýÈ磺

char buffer2[100];
»ò
char * buffer2;
buffer2 = (char *)molloc(100);

ÎÒÕâÀï¼ÙÉè×î´ó³¤¶ÈÊÇ100


ÁíÍâÒ»¸öÒÉÎÊ£¬Êý¾Ý¿âÀï´æµÄÊÇͼƬµÄurl»¹ÊÇͼƬÊý¾Ý£¿
Èç¹ûÊÇͼƬ·¾¶£¬ÄÇÄã¿ÉÒÔÓÃÉÏÃæµÄ·½·¨¶ÁÈ¡£¬µ«»¹µÃÄã×Ô¼ºÈ¥ÏÂÔØÍ¼Æ¬²¢ÏÔʾ¡£

Èç¹ûÊÇͼƬÊý¾Ý£¬ÄÇÄãÉÏÃæµÚ9ÐеIJÙ×÷ºÃÏñ²»Ì«¶Ô


Ïà¹ØÎÊ´ð£º

.net·ÃÎÊSQLiteÎÊÌâ

ÎÒ°²×°ÁËÒ»¸ösqlite developer,Ò»¸ö¿ÉÊÓ»¯µÄ¹¤¾ß¡£
½Ó×Å£¬ÎÒÓÖ°²×°ÁËSQLite.NET,²¢ÔÚVSÀïÃæÌí¼ÓºÃÁËdll¡£
ÏÖÔÚ£¬ÎÒÔÚsqlite developerÀï´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬¿âÖаüº¬ÎÒ×Ô¼º¶¨ÒåµÄÒ»ÕÅ±í¡£

ÎÊÌ⣺ÈçºÎ ......

sqliteÔÚlinuxÉϵÄʹÓÃ

ÒªÔÚlinuxÉÏʹÓÃsqliteÊDz»ÊÇÒªÏȱàÒë°²×°£¿Ôõô°²×°£¿
c#+sqlite+linuxµÄÏà¹ØÓ¦ÓÃÓÐûÓÐһЩÏà¹Ø×ÊÁÏ£¿
linux ÉÏÄÜÔËÐУ㣡¡?

Äã¿ÉÒÔÏÂÔØ±àÒëºÃµÄ£¬Ò²¿ÉÒÔÏÂÔØÔ´´úÂëÔÙ×Ô¼º±àÒë
http://www.sqlite.org/downl ......

Çë½ÌÒ»¸ö¹ØÓÚSqliteÊý¾Ý¿âµÄÎÊÌâ

¹ØÓÚjuliandayº¯ÊýµÄÎÊÌ⣬ÎÒÏÖÔÚ±íAÖÐÒ»¸ö×Ö¶Îbʱ¼äÀàÐÍ£¬ÈçºÎbΪ½ñÌìµÄÊý¾Ý£¿Ð»Ð»

select * from ±íÃû where datediff(d,getdate(),×Ö¶Îb)=0 ÕâÑùÄã¿´Ðв»£¿

ÎÒÓõÄÊÇsqliteÊý¾Ý¿â£¬Ëü²»Ö§³ÖdatediffµÄ¡ ......

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

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

vb.netÈçºÎ²Ù×÷sqliteÊý¾Ý¿â - .NET¼¼Êõ / VB.NET

±ÈÈ磺
1¡¢Á¬½ÓÊý¾Ý¿â£»
2¡¢½¨±í£¬insert ¡¢update,delete,selectÈçºÎд£¿
ÊDz»ÊÇÒªÏÂÔØ ADO.NET 2.0 ÒýÇæ£¿
sqliteʹÓÃÊÖ²á

ллqshurufa£¬ÎÒÏëÖªµÀÈçºÎͨ¹ývb.netʵÏÖ£¬¾ÍÊÇÓï¾äզд£¿

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