Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ù×÷ºÃÏñ²»Ì«¶Ô


Ïà¹ØÎÊ´ð£º

SQLITEÏÂÈçºÎɾ³ýÄÚÈÝÖеĵÚÒ»¸ö<br>

SQLITEÏÂÈçºÎɾ³ýÄÚÈÝÖеĵÚÒ»¸ö<br>
SQLITEϲ»ºÃÓà
Ìáʾ: 
sqlite error 
no such function: stuff 
Ôõô½â¾ö?
SQL code:
--------------------------------------------- ......

SQLiteÖÐÎÄÂÒÂëÎÊÌâ

ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éÑ¯Ê ......

sqliteÔÚlinuxÉϵÄʹÓÃ

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

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

c# + sqlite ³ö´í£¡£¡£¡ - .NET¼¼Êõ / C#

c# + sqlite ³ö´í£¡£¡£¡
File opened that is not a database file
file is encrypted or is not a database
ºÍÒÔǰһÑùµÄд£¬ÔõôÕâ´Î¾ÍÊDz»Ðа¡£¡£¡£¡
ÎÒ¿ì²»ÐÐÁË£¬´ó¼Ò°ï°ïÎÒ°¡£¡£¡£¡
¼û¹ýһƪÎÄÕÂÊÇ˵Õâ¸ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ