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

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";
}
ÔÚÕâÀÎҼ̳ÐBaseColumnsµÄÄ¿µÄ£¬ÊÇÖ±½Ó¶¨Òå"_ID"×Ö¶Î
2£º¶¨ÒåSQLiteOpenHelper µÄ×ÓÀ࣬À´¶ÔÓ¦Ò»¸öÊý¾Ý¿â£¬ÖØÔرØÐëµÄonCreate ºÍ onUpgrade¡£ÀïÃæÍ¨¹ýexecSQLµ÷ÓÃÊʵ±µÄSQL Óï¾ä¡£
@Override
// Õâ¸öº¯Êý»áÔÚµÚÒ»´ÎÖ´ÐÐÊý¾Ý¿â²Ù×÷µÄʱºò±»µ÷Óõ½¡£
 public void onCreate(SQLiteDatabase db) {
  // TODO Auto-generated method stub 
  db.execSQL("CREATE TABLE " + TABLE_NAME + " (" + _ID
             + " INTEGER PRIMARY KEY AUTOINCREMENT, " + TIME
             + " INTEGER," + TITLE + " TEXT NOT NULL);");  //×¢Ò⣬×îºÃÉùÃ÷×Ö¶ÎÀàÐÍ£¬ÒÔÃâ²»±ØÒªµÄÂé·³¡£
 } 
 @Override
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  // TODO Auto-generated method stub
        db.execSQL("DROP TABLE IF EXITS "+ TABLE_NAME);
        onCreate(db);
 }
3£ºÊ¹ÓøÃÊý¾Ý¿â¡£
   mydatabase = new Databasehelp(this);
²åÈëÊý¾Ý£º
SQLiteDatabase db = mydatabase.getWritableDatabase();
        ContentValues values = new ContentValues();
        values.put(TIME, System.currentTimeMillis());
        values.put(TITLE, string);
        db.insertOrThrow(TABLE_NAME, null, values);
²éѯÊý¾Ý£º
SQLiteDatabase db = mydatabase.getReadableDatabase();
        Cursor cursor = db.query(TABLE_NAME, { _ID, TIME, TITLE, }, null, null, null,
     


Ïà¹ØÎĵµ£º

sqlite´¥·¢Æ÷Ò»Àý

int column_names_printed = 0;
void print_row(int n_values, char** values)
{
    int i;
    for (i = 0; i < n_values; ++i) {
        printf("%10s", values[i]);
    }
    printf("\n& ......

web.py+sqliteдµÄ¼òµ¥ÁôÑÔ±¾

´úÂëºÜÂÒ£¬¶øÇÒûÓÐÓõ½Ä£°å£¬°Ñhtml´úÂë¸úPython´úÂë»ìÔÚÒ»ÆðÁË£¬¶øÇÒҲûÓÐÓõ½web.py±¾ÉíÌṩµÄÊý¾Ý¿â²Ù×÷Ä£¿é£¬¾ø¶Ô´Ö³¬µÄ´úÂ룡
ѧϰÁ˺ܶණÎ÷£¬Ê×Ïȵ±È»ÊÇweb.py£¬È»ºóÊÇsqlite£¬½ÓÏÂÀ´ÊÇtimeÄ£¿é——¿´À´Ò²Î¨Óв»¶ÏµÄʵ¼ù£¬²ÅÕæÕýÄܽø²½£¡
˵ʵÔڵģ¬Å¼Ñ§htmlµ½ÏÖÔÚÕâô¾Ã£¬»¹ÊǰëͰˮ£¬±¯¾çÁË£¡
01&n ......

SQLiteÔÚVCϵÄʹÓÃ


Ò»¡¢SQLite¼ò½é
SQLite ÊÇÓÃCÓïÑÔ±àдµÄ¿ªÔ´Êý¾Ý¿â£¬Ö÷ÒªÓÃÓÚǶÈëʽ£¬ÄãÒ²¿ÉÒÔ°ÑËü¼¯³ÉÔÚ×Ô¼ºµÄ×ÀÃæ³ÌÐòÖУ¬Ò²ÓÐÈ˽«ÆäÌæ´úAccess£¬ÓÃ×÷ºǫ́Êý¾Ý¿â¡£
SQLite Ö§³Ö¶àÊýSQL92±ê×¼£¬ÀýÈ磺Ë÷Òý¡¢ÏÞÖÆ¡¢´¥·¢ºÍ²é¿´Ö§³Ö¡£
Ö§³Ö NULL¡¢INTEGER¡¢REAL¡¢TEXT ºÍ BLOB Êý¾ÝÀàÐÍ£¬Ö§³ÖÊÂÎñ¡£
¶þ¡¢ÏÂÔØSQLite
SQLite¿ÉÒÔµ½¹Ù·½Õ ......

SqLite ʱ¼ä¸ñʽ


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

sqlite¼ÓÃÜÉè¼ÆµÄȱÏÝÓë¸Ä½ø


sqliteÊÇ
Ò»¸ö·Ç³£Ð¡ÇÉµÄ¿çÆ½Ì¨Ç¶ÈëʽÊý¾Ý¿â£¬Ëü±¾Éí²»Ìṩ¼ÓÃܹ¦ÄÜ£¬²»¹ýÉè¼ÆÕßÃ÷ÏÔÒ²¿¼ÂÇÁ˼ÓÃܵķ½°¸£¬ÎÒÃÇÔÚÔ´ÂëÖпÉÒÔÕÒµ½Á½¸öÔ¤ÁôµÄ¼ÓÃܽÓ
¿Ú£ºsqlite3_keyºÍsqlite3_rekey£¬¿ÉÒÔͨ¹ýʵÏÖÕâÁ½¸ö½Ó¿ÚÀ´´ïµ½¼ÓÃܵÄÄ¿µÄ¡£
        ÈçºÎ¼ÓÃÜ£¬ÒѾ­ÓкܶàÎÄÕÂÃèÊö£¬¿ÉÒԲο¼:¡¶
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ