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

SqliteÅжÏ×ֶδæÔÚ

ÅÐ¶Ï±í´æÔڵķ½·¨ºÜ¼òµ¥,ÍøÉϺܶà:
SELECT COUNT(*) from sqlite_master where type='table' and name='%s'" % tname;
ÄÇôÅжÏ×Ö¶ÎÊÇ·ñ´æÔÚ, »òÕß˵ÈçºÎÅжϱíµÄ°æ±¾ÊÇ·ñ×îоÍÖ»ÐèÒª:
select * from sqlite_master where tbl_name='tblContactList';
sqlite_master µÄ±í½á¹¹ÈçÏÂ:
type   |name    |tbl_name    |rootpage   |sql
×îºóÒ»¸ösql¾ÍÊÇ´´½¨tblContactList±íµÄsqlÓï¾ä, ËùÒÔÖ»ÒªÅжÏÕâ¸ösqlÓï¾äÊÇ·ñºÍÄãµÄ´´½¨Óï¾äÒ»Ñù¾Í¿ÉÒÔÖªµÀ¸Ã±íÊDz»ÊÇÄã×îеİ汾.


Ïà¹ØÎĵµ£º

android µÄsqlite Ö÷¼üÓësimpleCursorAdapter

android µÄsqlite Ö÷¼üÓësimpleCursorAdapter
×î½üÔÚÔÚ×öÒ»¸öСÀý×Óʱ£¬³öÏÖÒ»¸öСÎÊÌ⣬¾ÍÊDz»ÄÜÏÔʾ´ÓÊý¾Ý¿âÖвé³öµÄÊý¾Ý£¬ºóÀ´ÔÚÍøÉϲéÁËÒ»²é£¬²ÅÖªµÀÔ­À´ÊÇÕâ¸öÎÊÌâ¡£ 
 ÔÚʹÓÃsimpleCursorAdapterÏÔʾsqliteÊý¾Ýʱ£¬±ØÐë×¢ÒâsqliteµÄÖ÷¼üÃüÃû¡£ÓÉÓÚsimpleCursorAdapterµÄ·½·¨Ö»Ê¶±ð_id£¬ËùÒÔ£¬µ±ÄãÓõ½sql ......

SqLite ʱ¼ä¸ñʽ


sqliteʱ¼äº¯Êý£¨×ª£©
2007Äê12ÔÂ10ÈÕ ÐÇÆÚÒ» 13:33
תÌùÔ­Òò£º×î½üÉè¼ÆÁËÒ»¸ö¿çÊý¾Ý¿âµÄº¯Êý£¬À´²âÊÔ²âÊÔsqlite¡£
SQLite·ÖÒ³ÏÔʾ£ºSelect * from news order by id
desc Limit 10 Offset 10
ÕâÆªÎÄÕÂÊǸù¾Ý SQLite ¹Ù·½ WIKI ÀïµÄÄÚÈÝ·­Ò룬Èç¹ûÓÐʲô·­Òë²»µ±µÄµØ·½Ï£Íû´ó¼ÒÖ¸³ö£¬±Ï¾¹ÎÒµÄÓ¢ÎÄˮƽʵÔںܲ SQ ......

sqlite´æmp3


Step-1: Ê×ÏÈ將.mp3檔°¸·ÅÈëProjectµÄ/res/raw/裡£¬ÈçÏ£º
 
      
 
       ³Ìʽһ開ʼ執ÐУ¬½¨Á¢Ò»個資ÁÏ庫£¬º¬ÓÐBLOB欄룬ÈçÏÂÖ®Ö¸Á
 
     sql ......

c# sqlite Êý¾Ý¿â¼ÓÃÜ


ÓÃÁËADO.NET 2.0 SQLite Data Provider ÕâÑù¿ÉÒÔÖ±½ÓÀûÓÃËüÀ´´´½¨Ò»¸ö¼ÓÃܵÄsqliteÊý¾Ý¿â¡£
ÓйØc#´úÂëÈçÏ£º
1¡¢´´½¨¿ÕµÄsqliteÊý¾Ý¿â¡£
//Êý¾Ý¿âÃûµÄºó׺Äã¿ÉÒÔÖ±½ÓÖ¸¶¨£¬ÉõÖÁûÓкó׺¶¼¿ÉÒÔ
//·½·¨Ò»£º´´½¨Ò»¸ö¿ÕsqliteÊý¾Ý¿â£¬ÓÃIOµÄ·½Ê½
FileStream fs = File.Create(“c:\\test.db“);
//·½·¨¶þ£ºÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ