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