SQLite ³õ̽
»¹Êdzõ̽£¬×öµÄÏîĿҪÓõ½ÇáÇɵı¾µØÊý¾Ý¿â£¬ÓÚÊÇÕÒÁË sqlite 3 ÊÔÓÃÖ®£¬»¹²»´í£¬¹»ÇáÇÉ¡£
ÉÏÕâ¶ùÈ¥ÏÂÔØ³ÌÐòºÍ²é¿´Îĵµ£º http://www.sqlite.org/download.html
Õâ»Ø¿ª·¢ÓõÄÊÇ C#£¬ÓÚÊÇÕÒÁ˸ö.NETµÄ¿â Finisar.SQLite £¬µ½Õâ¶ùÈ¥ÔØ http://adodotnetsqlite.sourceforge.net/
Òª¼ÇµÄÒ²²»ÊÇʲô´ó²»Á˵Ķ«Î÷£¬Ê¾ÀýÍøÕ¾É϶¼ÓУ¬¾ÍÊǼ¸µãÐèҪעÒâµÄµØ·½
1¡¢Finisar.SQLite °üÄÜÔØµ½3¸ö¶¯Ì¬¿â sqlite3.dll¡¢SQLite.dll¡¢SQLite.NET.dll£¬ÔÚ.NET¹¤³ÌÖÐ¶Ô SQLite.NET.dll Ìí¼ÓÒýÓà ´úÂëÖоͿÉÒÔ using Finisar.SQLite;£¬½«¶¯Ì¬¿â¿½±´ÖÁ³ÌÐòÔËÐÐĿ¼£¬¼´¿É¡£
2¡¢Õâ¸ö¿âÓÐÀàËÆ DbConnection¡¢DbCommand¡¢DbDataReader µÄ×é¼þ£ºSQLiteConnection ¡¢SQLiteCommand¡¢SQLiteDataReader£¬Ê¹ÓÃÒ²»ù±¾Ïàͬ¡£
µ«ÊÇÎÒÔÚʹÓôø²ÎÊýµÄ SQLiteCommand ʱ³öÁ˵ãÎÊÌ⣬ËäÈ»²Î¿¼Á˹ÙÍøµÄʾÀý £¨http://www.devart.com/dotconnect/sqlite/docs/Parameters.html£©µ«Ã»ÓÐʲô°ïÖú£º
ÎÊÌ⣺
SQLiteCommand myCommand1;
...
myCommand1.CommandText = "INSERT INTO dept (deptno, dname, loc) VALUES (?, ?, ?)";
myCommand1.Parameters.Add("param1", 30);
myCommand1.Parameters.Add("param2", "SALES");
myCommand1.Parameters.Add("param3", "CHICAGO");
×ÜÊǻᱨ“ÕÒ²»µ½Î´ÃüÃûµÄ²ÎÊý”
¶ø»»ÁíÒ»ÖÖ×ö·¨£º
SQLiteCommand myCommand1;
...
myCommand1.CommandText = "UPDATE dept SET dname = :dname, loc = :loc WHERE deptno = @deptno";
myCommand1.Parameters.Add("@deptno", 20);
myCommand1.Parameters.Add("dname", "SALES");
myCommand1.Parameters.Add("loc", "NEW YORK");
²åÈëÊÇÄܳɹ¦£¬µ«ÊÇÊý¾Ý¶¼Îª¿Õ£¬ÕæÊǹÖÒì
×îÖÕÖ»ºÃÍÁÍÁµÄÆ´¸öSQLÈ¥Ö´ÐС£
3¡¢¹ØÓÚ Data Source=dbfile;Version=3;New=True;Compress=True; Õâ¸öÁ¬½Ó´®¡£
×îÐèҪ˵Ã÷µÄ¾ÍÊÇ New=True£¬ µ±New=Trueʱ£¬ÊÇʼÖÕ´´½¨ÐµÄÊý¾Ý¿â¡£
ËùÒÔµ±ÔÊý¾Ý¿âÓÐÄÚÈÝʱ£¬ÓÃNew=False£¬·ñÔò£¬Ä㽫ֻÄÜ¿´µ½Ò»¸ö¿ÕµÄÊý¾Ý¿âÎļþ¡£
Ïà¹ØÎĵµ£º
.help ÏÔʾ°ïÖúÐÅÏ¢
.import FILE TABLE °ÑÎļþÖеÄÊý¾Ýµ¼Èëµ½±íÖÐ,¸÷×Ö¶ÎÓÃseparator£¨Ä¬ÈÏÊÇ"|"£©µÄֵΪ·Ö¸ô·û,ÏÂÃæÎÒÃǾٸöÀý×Ó¡£ ÎÒÃÇÔÚFÅÌϽ¨Ò»¸ödata.txtÎļþ£¬ÄÚÈÝÈçÏ£º
4|¿ªÔ´
5|¼¼Êõ
.importÃüÁî²Ù×÷ÈçÏ£º
sqlite> .import data.txt websites
sqlite>
²é¿´½á¹ûÈçÏ£º
sqlite> select * from ......
dbAccess.js
import System.Data; // we import our data class
import Mono.Data.SqliteClient; // we import our sqlite client
class dbAccess {
// variables for basic query access
private var connection : String;
private var dbcon : IDbConnection;
private ......
SQLite ÊÇÒ»¸öʵÏÖÁËÍ걸µÄ£¨self-contained)£¬¿ÉǶÈëµÄ(embeddable)£¬ÁãÅäÖÃ(zero-configuration)µÄSQLÊý¾Ý¿âÒýÇæµÄСÐ͵ÄCº¯Êý¿â¡£Ëü°üº¬ÒÔϵÄÌØµã£º
.
ÊÂÎñ´¦ÀíÔ×Ó»¯(atomic)£¬Ò»Ö»¯(consistent)£¬³Ö¾Ã»¯(isolated)£¬¾øÔµ»¯(durable)£¬¼´Ê¹ÊÇÔÚϵͳ±ÀÀ£ºÍµôµçʱ
ÁãÅäÖ㬲» ......
2010ÄêSQLiteѧϰ±Ê¼ÇÖ®Ò»
Ò»£® ÈçºÎ»ñÈ¡SQLite×îа汾
¹Ù·½Õ¾µã£ºhttp://www.sqlite.org/
´Óhttp://www.sqlite.org/ÍøÕ¾µÄDownloadÒ³Ãæ»ñÈ¡
¼´ÈçÏÂÒ³ÃæÏÂÔØ
http://www.sqlite.org/download.html
¶þ£®WindowsϵÄSQLiteµÄÔ´´úÂëÊÇÄĸöÈí¼þÑ¹Ë ......