SQLITEʹÓÃ×ܽá
1. ´ò¿ªÄÚ´æÊý¾Ý¿â
Ö±½Ó´ò¿ªÒ»¸öÃûΪ":memory:"»òÕß Ãû×ÖÖ±½ÓΪ¿ÕµÄÊý¾Ý¿â£¬ Á½ÖÖÊý¾Ý¿âÂÔ΢ÓÐÐ©Çø±ð¡£
²Î¿¼ £ºhttp://www.sqlite.org/inmemorydb.html
2. ±£´æÄÚ´æÊý¾Ý¿â
3. ÅжϱíÊÇ·ñ´æÔÚ
ͨ¹ý²éѯϵͳ±ísqlite_masterÀ´»ñÈ¡Ïà¹ØÐÅÏ¢
select * from sqlite_master where type='table' and name='±íÃû'
Ïà¹ØÎĵµ£º
ÎÒÏÖÔÚҪʹÓÃSQLite3.0´´½¨Ò»¸öÊý¾Ý¿â£¬È»ºóÔÚÊý¾Ý¿âÖд´½¨Ò»¸ö±í¸ñ¡£
Ê×ÏÈÒªÒýÈëSQLite3.0µÄlib¿â¡£È»ºó°üº¬Í·Îļþ#import <sqlite3.h>
¡¾1¡¿´ò¿ªÊý¾Ý¿â£¬Èç¹ûûÓУ¬ÄÇô´´½¨Ò»¸ö
sqlite3* database_;
-(BOOL) open{
NSArray *paths = NSSearchPathForDirectoriesInDomai ......
[±à¼±¾¶Î
]
SQLite¼ò½é
SQLite
µÚÒ»¸öAlpha°æ±¾µ®ÉúÓÚ2000Äê5ÔÂ. ÖÁ½ñÒѾÓÐ10¸öÄêÍ·ÁË. SQLiteÒ²ÓÀ´ÁËÒ»¸ö°æ±¾ SQLite 3ÒѾ·¢²¼.
¡¡¡¡SQLiteÊÇÒ»¿îÇáÐ͵ÄÊý¾Ý¿â£¬ÊÇ×ñÊØACIDµÄ¹ØÁªÊ½Êý¾Ý¿â¹ÜÀíϵͳ£¬ËüµÄÉè¼ÆÄ¿±êÊÇǶÈë
ʽµÄ£¬¶øÇÒĿǰÒѾÔںܶàǶÈëʽ²úÆ·ÖÐʹÓÃÁËËü£¬ËüÕ¼ÓÃ×ÊÔ´·Ç³£µÄµÍ£¬ÔÚǶÈëʽÉ豸ÖУ¬¿ ......
android µÄsqlite Ö÷¼üÓësimpleCursorAdapter
×î½üÔÚÔÚ×öÒ»¸öСÀý×Óʱ£¬³öÏÖÒ»¸öСÎÊÌ⣬¾ÍÊDz»ÄÜÏÔʾ´ÓÊý¾Ý¿âÖвé³öµÄÊý¾Ý£¬ºóÀ´ÔÚÍøÉϲéÁËÒ»²é£¬²ÅÖªµÀÔÀ´ÊÇÕâ¸öÎÊÌâ¡£
ÔÚʹÓÃsimpleCursorAdapterÏÔʾsqliteÊý¾Ýʱ£¬±ØÐë×¢ÒâsqliteµÄÖ÷¼üÃüÃû¡£ÓÉÓÚsimpleCursorAdapterµÄ·½·¨Ö»Ê¶±ð_id£¬ËùÒÔ£¬µ±ÄãÓõ½sql ......
ǰһÕó×Ö×öÏîÄ¿(ǶÈëʽlinux)£¬ÓÉÓÚÒª±£´æ´óÁ¿µÄÊý¾Ý£¬¶øÇÒ×Ҫ±£´æ30ÌìµÄʱ¼ä¡£±¾À´´òËã±£´æµ½ÎļþÖУ¬Ã¿´ÎÆô¶¯Ó¦ÓóÌÐòµÄʱºòÖØÐ½âÎöÒ»±é£¬¿ÉÊǵ±Êý¾ÝÁ¿ºÜ´óµÄʱºò£¬¾Í³öÏÖЧÂʵÄÎÊÌâÁË¡£ËùÒÔ×îºó»¹ÊÇ·ÅÆúÁËʹÓÃÎļþµÄ´òË㣬¾ö¶¨Ê¹ÓÃÊý¾Ý¿â´æÈ¡Êý¾Ý¡£
linuxϵÄÊý¾Ý¿âÒ²ºÜ¶à£¬ÓпªÔ´µÄ£¬Ò²ÓÐÊշѵġ£¶ÔÓÚÎÒÃÇÀ´Ëµ£¬¿Ï ......
********´´½¨***********
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
public class DataBaseOpenHelper extends SQLiteOpenHelper {
public static fi ......