Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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»ÊÇÄã×îеİ汾.


Ïà¹ØÎĵµ£º

Ò»¸ö¹ØÓÚSQLiteС³ÌÐò £¬Çë´ó¼Ò¶à¶àÖ¸½Ì£¡

package com.jiao.sqlite;
import android.app.Activity;
import android.database.Cursor;
import android.os.Bundle;
import android.view.KeyEvent;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widg ......

×ܽáSQLite²»Ö§³ÖµÄSQLÓï·¨ÓÐÄÄЩ


1 TOP
ÕâÊÇÒ»¸ö´ó¼Ò¾­³£Îʵ½µÄÎÊÌ⣬ÀýÈçÔÚSQLSERVERÖпÉÒÔʹÓÃÈçÏÂÓï¾äÀ´È¡µÃ¼Ç¼¼¯ÖеÄǰʮÌõ¼Ç¼£º
SELECT TOP 10 * from [index] ORDER BY indexid DESC;
 
µ«ÊÇÕâÌõSQLÓï¾äÔÚSQLiteÖÐÊÇÎÞ·¨Ö´Ðеģ¬Ó¦¸Ã¸ÄΪ£º
SELECT * from [index] ORDER BY indexid DESC limit 0,10;
 
ÆäÖÐlimit 0,10±íʾ´ÓµÚ0 ......

SQLiteÃüÁîÐгÌÐò˵Ã÷

sqlite3: Ò»¸öSQLiteÊý¾Ý¿âµÄÃüÁîÐнӿÚ
ÒëÕß×¢
Ô­ÎĵØÖ·£ºhttp://www.sqlite.org/sqlite.html
    SQLite¿â°üº¬Ò»¸öÃû×Ö½Ð×ösqlite3 µÄÃüÁîÐÐ,Ëü¿ÉÒÔÈÃÓû§ÊÖ¹¤ÊäÈë²¢Ö´ÐÐÃæÏòSQLiteÊý¾Ý¿âµÄSQLÃüÁî¡£±¾ÎĵµÌṩһ¸öÑùʹÓÃsqlite3µÄ¼òҪ˵Ã÷¡£
¿ªÊ¼
    Æô¶¯sqlite3 ³ÌÐò£¬½ö½öÐèÒªÇÃÈ ......

sqlite´æmp3


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

Android SQLITE ¼òµ¥Æð²½

1£º¶¨Òå±íµÄ½á¹¹ºÍÃû×Ö£¬ÎÒʹÓÃÒÔÏ·½·¨£º
public interface Constatnts extends BaseColumns {
   public static final String TABLE_NAME = "test";
  
   public static final String TIME = "time";
   public static final String TITLE = "title";
}
ÔÚÕâÀÎҼ̳Р......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ