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

fleaphpÖÐsqliteÔõôÓÃ

ÓÉÓڳɱ¾¿¼ÂÇÓÃsqlite×öÊý¾Ý¿â£¬¿ÉÊÇÔÚµ÷ÓÃcreate·½·¨Ê±³ö´í£¬ºÃÏñÊDz»Äܵõ½×ÔÔöµÄIDÔõô¸Ä°¡
ÓÃmysqlÓÐʲô³É±¾£¿


ÓÃmysql²»µÃÂòÊý¾Ý¿â°¡¡£¡£¡£
¶¼ÊÇÒ»Ð©Ð¡ÍøÕ¾

id INTEGER NOT NULL PRIMARY KEY
ÉèΪÖ÷¼ü¾Í×ÔÔö

ÒýÓÃ
id INTEGER NOT NULL PRIMARY KEY
ÉèΪÖ÷¼ü¾Í×ÔÔö

ÎÒÖªµÀÕâÑùÄÜ×ÔÔö£¬ÎÒÏëÎʵÄÊÇfleaphp²»ÄÜÌí¼ÓÊý¾Ý£¬³öÏÖ´íÎóµÄµØ·½ºÃÏñÊÇ»ñÈ¡×î´óIDµÄʱºò£¬sqliteÖ§³Ölast_insert_idÂð

sqlite_last_insert_rowid

Ë­ÓÐÔÚfleaphp 1.7ÖÐÄÜÓõÄsqliteÇý¶¯°¡

up

ÓÃsqliteµÄÈ˾ÍÕâôÉÙÂð

ÓÃsqliteµÄÈ˲»ÉÙ£¬µ«ÓÃfleaphpµÄÈ˲»¶à

ÒýÓÃ
ÓÃsqliteµÄÈ˲»ÉÙ£¬µ«ÓÃfleaphpµÄÈ˲»¶à

Äĸö¿ò¼ÜѧϰÇúÏ߯½»ºÄØ£¿
ÎÒÕýÔÚÕÒÒ»¸ö¿ò¼Üѧѧ


Ïà¹ØÎÊ´ð£º

SQLITE´æÍ¼Æ¬

´ó¼ÒºÃ£¬ÇëÎʸ÷λ´óϺ£¬Ë­ÓÐSQLITE´æÍ¼Æ¬Â·¾¶µÄ´úÂë»òÀý×Ó°¡£¬Çë°ïæ¸øÐ¡µÜ·¢Ò»¸ö£¬tiandaliubin@163.com ÕæµÄºÜ¼±°¡¡£ÏÈллÁË¡£
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

ÒýÓÃ
http://www.sql ......

ÇósqlÓï¾ä£¬sqliteÊý¾Ý¿â

µç»°±¾Æ¥Åä²éѯ£¬Ï£ÍûÒ»ÌõÓï¾ä¸ã¶¨
 
¼ÙÉèºÅÂë±¾(numtable)ÈçÏÂ:

ºÅÂë(num)      ÁªÏµÈË (relationname)     
10086          ÒÆ ......

ʹÓ÷ÉÐÅÐéÄâ.net»·¾³£¬ÔÚʹÓÃSQLiteʱΪʲô±¨´íÄØ

C# code:

System.Data.SQLite.SQLiteConnection conn = new SQLiteConnection(@"acs.db");
try
{
conn.Open();
}
......

sqliteÏÂselect * from table whereµÄÎÊÌâ

ÎÒÏÖÔÚÏë°´ÕÕ×Ö¶Î DAY ºÍ NAME À´²éѯ£¬ÎÒÏëʵÏÖ£º±ÈÈ磬ÔÚÒ»¸öÊäÈë¿òÀïÊäÈë ¡°2009-10-12ÕÅÈý¡±£¬¿ÉÒÔ²éѯ³ö×Ö¶ÎDAYºÍNAMEµÄ×éºÏ·ûºÏÊäÈëµÄÄÇÏî¡£
Ò»°ãºÃÏñÊǰÑÁ½¸öÌõ¼þ·Ö¿ªÐ´£¬where DAY= and NAME= ÏÖÔÚÎÒÏëÈà ......

Óа취ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔ²Ù×÷sqliteÊý¾Ý¿âÂð£¿

visual studioÏÂÔÚwmÄ£ÄâÆ÷À³ÌÐò²Ù×÷sqlite¶¼Ê§°Ü£¬µ«ÔÚÊÖ»úÉÏûÎÊÌ⣬´ó¼ÒÆÕ±é¶¼ÊÇÕâÑùÂð£¿Ë­Óнâ¾ö°ì·¨£¿±Ï¾¹ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔЧÂʱȽϸߡ£
¶÷£¬²»»á°¡£¬PPCµÄÄ£ÄâÆ÷ÊÇ¿ÉÒԵİ¡..

ÒýÓÃ
¶÷£¬²»»á°¡£¬PPCµÄÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ