sqliteÄÚ´æÊý¾Ý¿âʹÓÃÓиÐ
SQLite²»½ö¿ÉÒÔ°ÑÊý¾Ý¿â ·ÅÔÚÓ²ÅÌÉÏ£¬»¹¿ÉÒÔ·ÅÔÚÄÚ´æÖУ¨sqlite3_open(":memory:", &db)£©£¬¾²âÊÔ£¬Í¬ÑùÌõ¼þÏÂÊý¾Ý¿â·ÅÔÚÄÚ´æÖбȷÅÔÚÓ²ÅÌÉϲåÈë¼Ç¼ËÙ¶È¿ì²î²»¶à3±¶¡£µ«Êý¾Ý¿â·ÅÔÚÄÚ´æÖÐʱÓÐÈçÏÂȱÏÝ£º
1¡¢¶Ïµç»ò³ÌÐò±ÀÀ£ºóÊý¾Ý¿â¾Í»áÏûʧ£¬ÄãÐèÒª¶¨ÆÚAttachµ½Ó²ÅÌÉϱ¸·Ý£»
2¡¢ÔÚÄÚ´æÖеÄÊý¾Ý¿â²»Äܱ»±ðµÄ½ø³Ì·ÃÎÊ(ÒòΪûÃû×Ö£¬ÒÔºó¿ÉÄÜÖ§³Ö)£¬¼´Ê¹ÔÚ¶àÏß³ÌÏ£¬Ò²µÃʹÓÃͬһ¾ä±ú£»
3¡¢²»Ö§³ÖÏñÔÚÓ²ÅÌÉϵĶÁд»¥³â´¦Àí£¬×Ô¼º¼ÓËø°É¡£
¿´À´£¬×·ÇóËÙ¶ÈÒª¸¶³ö´ú¼Û°¡£¡
Ïà¹ØÎĵµ£º
ÔÚ .NET ÀïÃæÊ¹Óà SQLite£¬ ÎÒÕâÀïʹÓõÄwrapperÊÇ System.Data.SQLite£¬ËüÖ»ÐèÒªÒ»¸ödll,½Ó¿Ú·ûºÏADO.Net 2.0µÄ¶¨Òå,ÐÔÄÜÒ²²»´í,NHibernateÓõÄÒ²ÊÇËü£¬Ä¿Ç°Ö§³ÖADO.NET 3.5ÁË£¬Ö§³Ö¼¯³ÉÔÚ VS2005 ºÍ VS2008ÀïÃæ£¬¶øÇÒÖ§³Öwince£¬ÊǸöÁÁµã
ÒòΪ·ûºÏADO.NETµÄ¹æ·¶£¬ËùÒÔʹÓ÷½Ê½£¬»ù±¾ºÍ SqlClient, OleDbµÈÔÉúµÄÒ»ÖÂ
us ......
sqliteʱ¼äº¯Êý£¨×ª£©
2007Äê12ÔÂ10ÈÕ ÐÇÆÚÒ» 13:33
תÌùÔÒò£º×î½üÉè¼ÆÁËÒ»¸ö¿çÊý¾Ý¿âµÄº¯Êý£¬À´²âÊÔ²âÊÔsqlite¡£
SQLite·ÖÒ³ÏÔʾ£ºSelect * from news order by id
desc Limit 10 Offset 10
ÕâÆªÎÄÕÂÊǸù¾Ý SQLite ¹Ù·½ WIKI ÀïµÄÄÚÈÝ·Ò룬Èç¹ûÓÐʲô·Òë²»µ±µÄµØ·½Ï£Íû´ó¼ÒÖ¸³ö£¬±Ï¾¹ÎÒµÄÓ¢ÎÄˮƽʵÔںܲ SQ ......
SQLiteÊý¾Ý¿âÁ¬½Ó·½Ê½
SQLite.NET
Type: .NET Framework Class Library
Usage: System.Data.SQLite.SQLiteConnection
Basic
Data Source=filename;Version=3;
Version 2 is not supported by this class library.
Using UTF16
Data Source=filename;Version=3;UseUTF16 ......
sqlite3: Ò»¸öSQLiteÊý¾Ý¿âµÄÃüÁîÐнӿÚ
ÒëÕß×¢
ÔÎĵØÖ·£ºhttp://www.sqlite.org/sqlite.html
SQLite¿â°üº¬Ò»¸öÃû×Ö½Ð×ösqlite3 µÄÃüÁîÐÐ,Ëü¿ÉÒÔÈÃÓû§ÊÖ¹¤ÊäÈë²¢Ö´ÐÐÃæÏòSQLiteÊý¾Ý¿âµÄSQLÃüÁî¡£±¾ÎĵµÌṩһ¸öÑùʹÓÃsqlite3µÄ¼òҪ˵Ã÷¡£
¿ªÊ¼
Æô¶¯sqlite3 ³ÌÐò£¬½ö½öÐèÒªÇÃÈ ......
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";
}
ÔÚÕâÀÎҼ̳Р......