Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ......

ÐÂÏîÄ¿ÐèҪʹÓÃsqlite,ÇëÎÊÔõôÏÂÔغʹʹÓû·¾³

ÎÒÏÖÔÚ¿ªÊ¼×öÒ»¸öÐÂÏîÄ¿,ÐèÒªÊÇÓÃEVC+SqliteµÄ»·¾³,µ«ÎÒûÓùýSqlite,Çë´ó¼Ò¸øµã½¨Òé,лл!!
sqlite ºÜ¼òµ¥£¬Ö±½Óµ½ËüµÄ¹ÙÍøÏÂÔØ sqlite3.exe ¾ÍÐÐÁË£¬ÆäËüʲô¶¼²»ÐèÒª¡£
È»ºó¾ÍÊÇÏÂÔØÄãÐèÒªµÄÇý¶¯¡£

µ±ÄúµÄ ......

sqlite ²»Ö§³Ölast()?


Java code:

stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery("select * from table");//±¨´íµÄÐÐ
rs.last()

ÓÃrs.last( ......

ÔõôÈÃsqliteÖ§³ÖÖÐÎÄ,Ë­½â¾öÁ˾͸øËû100·Ö

ÔõôÈÃsqliteÖ§³ÖÖÐÎÄ,Ë­½â¾öÁ˾͸øËû100·Ö
ÄѵÀSQLITE²»Ö§³ÖÖÐÎÄÂ𣿣¿£¿£¿£¿£¿£¿£¿

¶ÁÈ¡³öÀ´Ê±ÂÒÂë

ÕâÑùÊÔÊÔ
C# code:

using System.Data;
using System.Data.SQLite;
//...
using (SQLiteConnec ......

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

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

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