´´½¨sqlite µÄvs2008 ¹¤³Ì
½üÀ´ÒòΪ¹¤×÷ÐèÒª¼ÓÈësqlite ´¦ÀíÊý¾Ý£¬ÏÂÔØÁËsqlite3.6.22(amalgamation °æ±¾£©£¬ÓÖÏë×Ô¼º¶¯ÊÖ±àÒë³öÀ´Ï붯̬Á´½Ó¾Í¶¯Ì¬£¬Ï뾲̬Á´½ÓÒ²¿ÉÒÔ£¬ÓÚÊÇÓÐÁËÕâƪÎÄÕ£¬ÓÐÒâ˼µÄÊÇ֮ǰҲÊÔ¹ý±àÒëSqlite£¬µ«Ã»³É¹¦£¬²»ÁËÁËÖ®£¬¿ÉÄܽüÀ´Òª¹ýÄêÁË
¸ú
RPÓйذÉ:)¡£
1 Ê×ÏÈ´´½¨vs2008µÄÒ»¸ö¿ÕDLL¹¤³Ì;
2 ½«sqlite3.cÎļþÌí¼Óµ½¹¤³Ì£¬²»ÐèÒªsqlite3.hÍ·Îļþ£¬sqlite3.cÒѾ°üº¬ÁËÍ·ÎļþµÄ½Ó¿Ú¸úÊý¾Ý½á¹¹¡£
3. ×îÖØÒªµÄÒ»²½£¬½«±àÒëÑ¡ÏîÀïµÄ"±àÒë³ÉC++"¸ÄΪ“±àÒë³ÉC”£¬ÎÒÔÚGoogleÏֳɵÄsqlite vs¹¤³Ì·¢ÏÖÐí¶àÈ˶¼ÒòΪÄÇЩ·³È˵ÄÀàÐÍû¶¨Òå»òÕß²»Æ¥Åä±ÀÀ££¬ÐÞ¸ÄÕâ¸öÑ¡Ïîºó¾Í²»ÐèÒªÐ޸ĴúÂëÁË¡£
4. sqliteÍøÕ¾Ìṩһ¸öWindowsµÄ±àÒë¿â£¬ÎÒûÓõ½ÄǸöDLL£¬µ«ÄǸösqlite3.defÈ´¿ÉÒÔÓÃÀ´ÉùÃ÷µ¼³öº¯Êý£¬±È×Ô¼ºÈ¥µ¼³öÊ¡Á¦£¬ËùÒÔÒ²Ìí¼Ó½ø¹¤³Ì¡£
5 »¹ÓÐÒ»¸ö±àÒëºê£¬SQLITE_ENABLE_COLUMN_METADATA£¬Èç¹ûÓöµ½sqlite3_column_database_name**£¨£©º¯Êýû¶¨Ò壬ÄǾÍÊÇÌáÐÑÒª¼Ó½øÕâ¸öºêÁË£¬ÎÒÊÇÔÚ¹¤³Ì"ÊôÐÔ"¿ò------> C++ ------->Preprocessor-------->Preprocessor DefinitionÌí¼ÓµÄ£¬µ±È»Ò²¿ÉÒÔÔÚÆäËûµØ·½Ìí¼Ó£¬
µ«ÒÔÎÒµÄÏë·¨£¬ÔÚÕâÀïÌí¼Ó²»ÐèÒª¸Ä¶¯´úÂ룬¶øÇÒÒÔºósqlite°æ±¾Éý¼¶£¬Ö»ÐèÒªÔÚ¹¤³ÌĿ¼ÀïÌæ»»sqlite3.c ºÍsqlite3.def£¬Ò»ÀÍÓÀÒÝ£¬¡¡Ï£ÍûÈç´Ë°É£¡
6 Ìí¼ÓÁËÒ»¸ö°æ±¾ÐÅÏ¢£¬³£ÓÃVCµÄ¿Ï¶¨ÖªµÀ£¬°æ±¾Éý¼¶¾ÍÖ±½ÓÔÚsqlite_version.rcÀïÃæÐ޸İ汾ºÅ¾ÍÊÇÁË¡£
ÉÏ´«ÁËÒ»·Ýµ½CSDN£¬²»ÖªµÀCSDNµ½µ×ÔÚÄÄÀïÖ§³Ö¸½¼þÉÏ´« :)
http://download.csdn.net/source/2022243
Ïà¹ØÎĵµ£º
Ê×ÏÈ×öµãÆ̵æ˵Ã÷£º
sqlite³ÌÐòͨ¹ý²éÕÒ·ÖºÅ(;)À´¾ö¶¨Ò»¸öSQLÓï¾äµÄ½áÊø,ËùÒÔÒªÖ´ÐÐSQLÓï¾äÇëÈ·±£ÔÚSQLÓï¾äºóÓзֺÅ(;).Èç¹ûÄãÊ¡ÂԷֺţ¬sqlite3½«¸øÄãÒ»¸öÁ¬ÐøµÄÃüÁîÌáʾ·û(...> )²¢µÈÄã¸øµ±Ç°µÄSQLÃüÁîÌí¼Ó¸ü¶àµÄÎÄ×Ö¡£Õâ¸öÌصãÈÃÄãÊäÈë¶àÐеĶà¸öSQLÓï¾ä.µ«µãºÅ(.)ÃüÁî²»Òª·ÖºÅ(;).ctrl+c¿ÉÒÔ½áÊøµ±Ç°ÃüÁî¡£
ÔÚdos´ ......
¿ÉÒÔ½Ó×ÅÉÏÒ»²½²Ù×÷£¬Ö±½ÓÏòDOS´°¿ÚÊäÈë.helpÃüÁîÀ´²é¿´SQLiteµÄËùÓÐÃüÁîÐм°½âÊÍÈçÏ£º
F:\>sqlite3
SQLite version 3.6.16
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .help
Ò²¿ÉÒÔctrl+c½áÊøÃüÁÏëDOS´°¿Ú ÊäÈësqlite3Ö´ÐкóÔÙÊäÈë.helpÃüÁîÈçÏ£º
F:\>sqli ......
1¡¢ÈçºÎ½¨Á¢×Ô¶¯Ôö³¤×Ö¶Î?
¼ò¶Ì»Ø´ð£ºÉùÃ÷Ϊ INTEGER PRIMARY KEY µÄÁн«»á×Ô¶¯Ôö³¤¡£
³¤Ò»µãµÄ´ð°¸£º Èç¹ûÄãÉùÃ÷±íµÄÒ»ÁÐΪ INTEGER PRIMARY KEY£¬ÄÇô£¬ ÿµ±ÄãÔÚ¸ÃÁÐÉϲåÈëÒ»NULLֵʱ£¬ NULL×Ô¶¯±»×ª»»ÎªÒ»¸ö±È¸ÃÁÐÖÐ×î´óÖµ´ó1µÄÒ»¸öÕûÊý£¬Èç¹û±íÊǿյģ¬ ½«»áÊÇ1¡ ......
CnGuiDB.js
var db : dbAccess;
public var mskin : GUISkin;
private var mstring : String;
var inputStr;
function Start(){
inputStr = "1";
}
function search(mid)
{
db = new dbAccess();
db.OpenDB("db1.db");
var tableName = "myTable";
// table name, I want to return everyo ......
SQLite ÊÇÒ»¸öʵÏÖÁËÍ걸µÄ£¨self-contained)£¬¿ÉǶÈëµÄ(embeddable)£¬ÁãÅäÖÃ(zero-configuration)µÄSQLÊý¾Ý¿âÒýÇæµÄСÐ͵ÄCº¯Êý¿â¡£Ëü°üº¬ÒÔϵÄÌص㣺
.
ÊÂÎñ´¦ÀíÔ×Ó»¯(atomic)£¬Ò»Ö»¯(consistent)£¬³Ö¾Ã»¯(isolated)£¬¾øÔµ»¯(durable)£¬¼´Ê¹ÊÇÔÚϵͳ±ÀÀ£ºÍµôµçʱ
ÁãÅäÖ㬲» ......