fleaphpÖÐsqliteÔõôÓÃ
ÓÉÓڳɱ¾¿¼ÂÇÓÃsqlite×öÊý¾Ý¿â£¬¿ÉÊÇÔÚµ÷ÓÃcreate·½·¨Ê±³ö´í£¬ºÃÏñÊDz»Äܵõ½×ÔÔöµÄIDÔõô¸Ä°¡
ÓÃmysqlÓÐʲô³É±¾£¿
ÓÃmysql²»µÃÂòÊý¾Ý¿â°¡¡£¡£¡£
¶¼ÊÇһЩСÍøÕ¾
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´æͼƬ·¾¶µÄ´úÂë»òÀý×Ó°¡£¬Çë°ïæ¸øСµÜ·¢Ò»¸ö£¬tiandaliubin@163.com ÕæµÄºÜ¼±°¡¡£ÏÈллÁË¡£
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
ÒýÓÃ
http://www.sql ......
ÎÒÏÖÔÚ¿ªÊ¼×öÒ»¸öÐÂÏîÄ¿,ÐèÒªÊÇÓÃEVC+SqliteµÄ»·¾³,µ«ÎÒûÓùýSqlite,Çë´ó¼Ò¸øµã½¨Òé,лл!!
sqlite ºÜ¼òµ¥£¬Ö±½Óµ½ËüµÄ¹ÙÍøÏÂÔØ sqlite3.exe ¾ÍÐÐÁË£¬ÆäËüʲô¶¼²»ÐèÒª¡£
È»ºó¾ÍÊÇÏÂÔØÄãÐèÒªµÄÇý¶¯¡£
µ±ÄúµÄ ......
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²»Ö§³ÖÖÐÎÄÂ𣿣¿£¿£¿£¿£¿£¿£¿
¶ÁÈ¡³öÀ´Ê±ÂÒÂë
ÕâÑùÊÔÊÔ
C# code:
using System.Data;
using System.Data.SQLite;
//...
using (SQLiteConnec ......
visual studioÏÂÔÚwmÄ£ÄâÆ÷À³ÌÐò²Ù×÷sqlite¶¼Ê§°Ü£¬µ«ÔÚÊÖ»úÉÏûÎÊÌ⣬´ó¼ÒÆձ鶼ÊÇÕâÑùÂð£¿ËÓнâ¾ö°ì·¨£¿±Ï¾¹ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔЧÂʱȽϸߡ£
¶÷£¬²»»á°¡£¬PPCµÄÄ£ÄâÆ÷ÊÇ¿ÉÒԵİ¡..
ÒýÓÃ
¶÷£¬²»»á°¡£¬PPCµÄÄ ......