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

ÔÚsqliteÊý¾Ý¿âÖУ¬intÀàÐͲ»µÈÓÚintegerÊý¾ÝÀàÐÍ

ÕâЩÌìÒ»Ö±ÔÚæÏúÊÛ¹ÜÀíÈí¼þÒ×Âôͨ¿Í»§¶ËµÄ³ÌÐò±àд£¬ÓÉÓÚÐèÒª²ÉÓñ¾µØÊý¾Ý»º´æ»úÖÆÀ´Ìá¸ß³ÌÐòµÄÊý¾Ý·ÃÎÊЧÂÊ£¬ËùÒÔÐèÒªÔÚ¿Í»§¶ËʹÓÃÒ»¸öСÇɵı¾µØÊý¾Ý¿â¡£Õâ¸öÊý¾Ý¿âµ±È»ÒªÐ¡¶ø¾«º·µÄ¡£ÎÒÒ²²»Ïë×öÇ¿µÁ£¬ÓÚÊǾÍÑ¡ÔñSqlite°É——ÎļþÊý¾Ý¿â£¬Ö»ÒªÒ»¸öSqlite.dll¾Í¿ÉÒÔ²Ù×÷Êý¾Ý¿â¡£
²»µÃ²»³ÃÈ˱¾ÈËÊÇÓеã͵ÀÁ£¬Add Nhibernate+ActiveRecord×öO/R mapping£¬Ã²ËÆÕâÑùµÄ¼Ü¹¹ÓÐɱ¼¦ÓÃÅ£µ¶Ö®ÏÓ¡£
×òÌìÅöµ½Ò»¸ö·Ç³£¹ÖÒìµÄÎÊÌ⣬µ±ÎÒµ÷ÓÃActiveRecordBase.FindAllµÄʱºò£¬·µ»ØÒ»¸öÊý×éÄÚ²¿µÄËùÓÐÔªËØ¶¼ÊÇnull¡£
Õâ¾ÍÆæ¹ÖÁË£¬Êý¾Ý¿âÀïÃæÒѾ­´æÔÚÊý¾Ý¡£ÓÚÊÇÉÏÍø²é×ÊÁÏ£¬¿´µ½ÓÐÒ»¸ö¼Ò»ï˵²»ÄܰÑPrimary keyÓ³ÉäΪIdentify£¬Ö»ÄÜÓÃNative¡£Ð޸ĺó»¹ÊDz»ÐУ¬TMD£¬ÍøÂçÉÏµÄÆ­×Ó»¹Õæ²»ÉÙ£¬ÌرðÊǹúÄÚ£¬ºöÓÆµÄÈË¶à£¬Õæ²ÅʵѧµÄÉÙ£¡
ÓÚÊÇ¿ªÊ¼²âÊÔÆäËû±íµÄFIND¹¦ÄÜ£¬Ò»Çй¤×÷Õý³£¡£¼û¹í£¬DAMN£¡
ÓÚÊÇÓÃ.schÃüÁî²é¿´±íµÄschemaÒìͬ£¬·¢ÏÖ³ýÁËPrimary keyµÄ¶¨ÒåÓÐÒ»µã²î±ðÍ⣬ÎÞÒì³£¡£
ÓÖ¿ªÊ¼»³ÒÉÊDz»ÊÇDLL¼ÓÔØÇé¿ö£¬ÁªÏëµ½ÎĵµËµÒª¼ÓÔØDynamicProxy£¬ÂíÉÏÏÂÔØÐ°汾DynamicProxy¡£»¹ÊDz»¹ÜÓá£
±§×ÅËÀÂíµ±»îÂíÒ½ÊÔÊÔ¿´µÄÐÄ̬£¬ÐÞ¸ÄÁ˱íµÄPrimary Key¶¨Ò壬Ҳ¾ÍÊǰÑÔ­À´Primary keyÖеÄintÀàÐÍ×ֶΣ¬¸Ä³ÉÁËintegerÀàÐÍ¡£¡£¡£²âÊÔͨ¹ý¡£¡£¡£À²£¡
¹«²¼´ð°¸£¬±íµÄPrimary key±»ÎÒ¶¨Òå³Éint¶ø²»ÊÇinteger£¬Ð޸ĺó¾ÍÐÐÁË£¬¶øÇÒ£¬´ËÁÐÊÇ¿ÉÒÔÓÃIdentifyÀ´Ó³ÉäµÄ£¬¹¤×÷ÍêÈ«Õý³£¡£
¹À¼ÆÍøÉÏÄǸö·¢ÌûµÄÈËÒ²ºÍÎÒÓöµ½ÁËÏàͬµÄÎÊÌ⣬µ«ÊǿɶñµÄÊǾ¹È»ÌṩÁËÒ»¸ö×ö´íµÄ´ð°¸£¬ÎóÈË×ӵܣ¡º¹Ò»¸ö


Ïà¹ØÎĵµ£º

SqliteÅжÏ×ֶδæÔÚ

ÅÐ¶Ï±í´æÔڵķ½·¨ºÜ¼òµ¥,ÍøÉϺܶà:
SELECT COUNT(*) from sqlite_master where type='table' and name='%s'" % tname;
ÄÇôÅжÏ×Ö¶ÎÊÇ·ñ´æÔÚ, »òÕß˵ÈçºÎÅжϱíµÄ°æ±¾ÊÇ·ñ×îоÍÖ»ÐèÒª:
select * from sqlite_master where tbl_name='tblContactList';
sqlite_master µÄ±í½á¹¹ÈçÏÂ:
type   |name  ......

QtopiaÖÐʹÓÃSQLite×ܽἰSQLiteÖд洢ÖÐÎIJÙ×÷

¡¾¹¤×÷»·¾³£º»ùÓÚÓÑÉÆÖ®±Ûmini2440¿ª·¢°å+Qtopia2.2°æ±¾+RedHat9+SQLite-3.3.6¡¿
1.QtopiaÖÐʹÓÃSQLite
ÓÉÓÚQt2²»Ö§³ÖÊý¾Ý¿â²Ù×÷£¬£¨Qt3°æ±¾¾ÍÌṩÁËÖ§³ÖÊý¾Ý¿â²Ù×÷µÄÀ࣬µ«ÊÇQtopia2±È½Ï¾­µä£¬ÊÇ»ùÓÚQt2µÄ£¬Ã»°ì·¨£¡£©ËùÒÔÔÚQt/Qtopia³ÌÐòÖÐÐèÒªÊý¾Ý¿âʱ£¬¿ÉÒÔ¿¼ÂÇÔÚQtÖÐʹÓÃLinuxϲÙ×÷SQLiteÊý¾Ý¿âµÄ·½·¨¡££¨±í´ïµÄÓе ......

[ת]JavaÁ¬½ÓSQLite dbÊý¾Ý¿âÎļþ

JavaÁ¬½ÓSQLiteÊý¾Ý¿âÏê½â ÏÂÔØSQLiteÊý¾Ý¿âµÄJDBC ÕâÀï¸ø³öÒ»¸öÖÐÎÄÕ¾µãµÄURL: ÉèÖû·¾³±äÁ¿£º ½«ÏÂÔØµ½µÄ°ü½âѹºóµÃµ½jar°ü sqlitejdbc-v033-nested.jar ·Åµ½%JAVA_HOME%\lib Ï£¬²¢ÇÒ½«ÆäÌí¼Óµ½classpathϵͳ»·¾³±äÁ¿ÖÐ,ÎÒµÄclasspathϵͳ»·¾³±äÁ¿ÏÖÔÚΪ: .;%JAVA_HOME%\lib;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\li ......

ÈçºÎ¸ßЧʹÓÃSQLite .net (C#)

 SQLite ×÷Ϊһ¸öÇáÁ¿¼¶Ç¶ÈëʽÊý¾Ý¿â£¬»¹ÊǷdz£ºÃÓõġ£ÓêºÛ¼«Á¦ÍƼö~~~~~~ 
½ñÌìÓиöÅóÓѲâÊÔ SQLite£¬È»ºóµÃ³öµÄ½áÂÛÊÇ£ºSQLite ЧÂÊÌ«µÍ£¬ÅúÁ¿²åÈë1000Ìõ¼Ç¼£¬¾ÓÈ»ºÄʱ 2 ·ÖÖÓ£¡
ÏÂÃæÊÇËû·¢¸øÎҵIJâÊÔ´úÂë¡£ÎÒÔÎ~~~~~~ 
using System.Data;
using System.Data.Common;
using System.Data.SQLite; ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ