sqliteÄÚ´æÊý¾Ý¿âʹÓÃÓиÐ
SQLite²»½ö¿ÉÒÔ°ÑÊý¾Ý¿â ·ÅÔÚÓ²ÅÌÉÏ£¬»¹¿ÉÒÔ·ÅÔÚÄÚ´æÖУ¨sqlite3_open(":memory:", &db)£©£¬¾²âÊÔ£¬Í¬ÑùÌõ¼þÏÂÊý¾Ý¿â·ÅÔÚÄÚ´æÖбȷÅÔÚÓ²ÅÌÉϲåÈë¼Ç¼ËÙ¶È¿ì²î²»¶à3±¶¡£µ«Êý¾Ý¿â·ÅÔÚÄÚ´æÖÐʱÓÐÈçÏÂȱÏÝ£º
1¡¢¶Ïµç»ò³ÌÐò±ÀÀ£ºóÊý¾Ý¿â¾Í»áÏûʧ£¬ÄãÐèÒª¶¨ÆÚAttachµ½Ó²ÅÌÉϱ¸·Ý£»
2¡¢ÔÚÄÚ´æÖеÄÊý¾Ý¿â²»Äܱ»±ðµÄ½ø³Ì·ÃÎÊ(ÒòΪûÃû×Ö£¬ÒÔºó¿ÉÄÜÖ§³Ö)£¬¼´Ê¹ÔÚ¶àÏß³ÌÏ£¬Ò²µÃʹÓÃͬһ¾ä±ú£»
3¡¢²»Ö§³ÖÏñÔÚÓ²ÅÌÉϵĶÁд»¥³â´¦Àí£¬×Ô¼º¼ÓËø°É¡£
¿´À´£¬×·ÇóËÙ¶ÈÒª¸¶³ö´ú¼Û°¡£¡
Ïà¹ØÎĵµ£º
QT¶ÁдSqliteÊý¾Ý¿â
//.h
/****************************************************************************
**
** Date : 2010-05-08
** Author : furtherchan
** If you have any questions , please contact me
**
****************************************************************** ......
android µÄsqlite Ö÷¼üÓësimpleCursorAdapter
×î½üÔÚÔÚ×öÒ»¸öСÀý×Óʱ£¬³öÏÖÒ»¸öСÎÊÌ⣬¾ÍÊDz»ÄÜÏÔʾ´ÓÊý¾Ý¿âÖвé³öµÄÊý¾Ý£¬ºóÀ´ÔÚÍøÉϲéÁËÒ»²é£¬²ÅÖªµÀÔÀ´ÊÇÕâ¸öÎÊÌâ¡£
ÔÚʹÓÃsimpleCursorAdapterÏÔʾsqliteÊý¾Ýʱ£¬±ØÐë×¢ÒâsqliteµÄÖ÷¼üÃüÃû¡£ÓÉÓÚsimpleCursorAdapterµÄ·½·¨Ö»Ê¶±ð_id£¬ËùÒÔ£¬µ±ÄãÓõ½sql ......
Step-1: Ê×ÏÈ將.mp3檔°¸·ÅÈëProjectµÄ/res/raw/裡£¬ÈçÏ£º
³Ìʽһ開ʼ執ÐУ¬½¨Á¢Ò»個資ÁÏ庫£¬º¬ÓÐBLOB欄룬ÈçÏÂÖ®Ö¸Á
sql ......
ÔÚ AndroidÖУ¬¶ÔÓÚÊý¾ÝµÄ´æÖü£¬Óм¸ÖÖ·½Ê½£¬ÓÐÎļþ·½Ê½£¬ÓÐÎļþʽÊý¾Ý¿â·½Ê½,Android×Ô´øÁËÒ»¸öSQLiteÊý¾Ý¿â£¬×öǶÈ뿪·¢µÄÈ˶ÔÕâ¸ö¿çƽ̨µÄ±¾µØÎļþÊý¾Ý¿âÒ»¶¨²»»áİÉú£¬ÔÚAndroid¶ÔÓÚÊý¾ÝµÄ·ÃÎÊ£¬Ìá³öÁËеķ½Ê½£¬ContentProvider·½Ê½£¬ÀàËÆÓÚMSµÄ ContentProvider·½Ê½µÄ£¬OLEDB£¬¼°ODBCͳһµÄÊý¾Ý·½Ê½¡£
ÎÒÃÇÊ×ÏÈÀ´¿´¿ ......