sqlite¹Ø±ÕÊý¾Ý¿â£¬Çå³ýÁ¬½Ó³Ø
´ÓÍøÉÏÕÒµÄÀý×Ó£¬´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬×·¼ÓÁ˼¸Ìõ¼Ç¼ºó£¬È»ºó¹Ø±ÕÊý¾Ý¿â£¬È»ºó×¼±¸ÏòPDAÏÂÔØÊý¾Ý¿â£¬·¢ÏÖÎļþ¾¹È»±»Õ¼ÓÃÁË£¬ÒѾ¹Ø±ÕÁËÊý¾Ý¿âÁ¬½ÓÒ²ÎÞЧ£¬ºóÀ´´ÓÍøÉÏ¿´µ½ÐèÒªÇå³ýÁ¬½Ó³Ø
using (SQLiteConnection cn = new SQLiteConnection("Data Source=" + strTempPath + "\\Smoke.db3;Pooling=true;FailIfMissing=false"))
{
//ÔÚ´ò¿ªÊý¾Ý¿âʱ£¬»áÅжÏÊý¾Ý¿âÊÇ·ñ´æÔÚ£¬Èç¹û²»´æÔÚ£¬ÔòÔÚµ±Ç°Ä¿Â¼Ï´´½¨Ò»¸ö
cn.Open();
using (SQLiteCommand cmd = new SQLiteCommand())
{
}
cn.Close();
System.Data.SQLite.SQLiteConnection.ClearAllPools(); //Çå³ýÁ¬½Ó³ØÖ®ºó£¬Êý¾Ý¿âÎļþ²ÅÄÜʹÓÃ
}
Ïà¹ØÎĵµ£º
ǶÈëʽÊý¾Ý¿âSQLiteÓëJava
SQLite×÷Ϊһ¸ö¿ªÔ´µÄǶÈëʽÊý¾Ý¿â²úÆ·£¬¾ßÓÐϵͳ¿ªÏúС£¬¼ìË÷ЧÂʸߵÄÌØÐÔ£¬ÊÊÓÃÓÚÊÖ»ú¡¢PDA¡¢»ú¶¥ºÐÉ豸µÈµçÆ÷£¬²¢ÇÒ×÷ΪǶÈëʽÊý¾Ý¿âÔÚ¿ÉÏÂÔØµÄÏû·ÑÀàÓ¦ÓóÌÐòÖÐÔËÐеĺܺá£ÕâÆªÎÄÕ½éÉÜǶÈëʽÊý¾Ý¿â²úÆ·SQLiteµÄ¼¼ÊõÌØµã£¬²¢×ÅÖØÌÖÂÛÑо¿ÓëJavaÓïÑÔÖ®¼äµÄ½Ó¿Ú£¬²¢ÒÔʵÀý˵Ã÷ÈçºÎʹÓÃJAVA¿ª· ......
¡¾¹¤×÷»·¾³£º»ùÓÚÓÑÉÆÖ®±Ûmini2440¿ª·¢°å+Qtopia2.2°æ±¾+RedHat9+SQLite-3.3.6¡¿
1.QtopiaÖÐʹÓÃSQLite
ÓÉÓÚQt2²»Ö§³ÖÊý¾Ý¿â²Ù×÷£¬£¨Qt3°æ±¾¾ÍÌṩÁËÖ§³ÖÊý¾Ý¿â²Ù×÷µÄÀ࣬µ«ÊÇQtopia2±È½Ï¾µä£¬ÊÇ»ùÓÚQt2µÄ£¬Ã»°ì·¨£¡£©ËùÒÔÔÚQt/Qtopia³ÌÐòÖÐÐèÒªÊý¾Ý¿âʱ£¬¿ÉÒÔ¿¼ÂÇÔÚQtÖÐʹÓÃLinuxϲÙ×÷SQLiteÊý¾Ý¿âµÄ·½·¨¡££¨±í´ïµÄÓе ......
1. Ô´´úÂëµÄ»ñÈ¡
sqliteÊÇÒ»¸ö¹¦ÄÜÇ¿´ó¡¢Ìå»ýСÔËËãËÙ¶È¿ìµÄǶÈëʽÊý¾Ý¿â£¬²ÉÓÃÁËÈ«CÓïÑÔ·â×°£¬²¢ÌṩÁ˰ËÊ®¶à¸öÃüÁî½Ó¿Ú£¬¿ÉÒÆÖ²ÐÔÇ¿£¬Ê¹Ó÷½±ã¡£
ÏÂÔØµØÖ·£ºhttp://sqlite.org/download.html
sqliteÔ´´úÂ룺sqlite-3.6.17.tar.gz
2. sqliteÒÆÖ²µ½x86 for linu ......
sqliteÊDz»´íµÄÄÚ´æÊý¾Ý¿â£¬ÄÚ´æÊý¾Ý¿âÊÇ´¦Àí´óÁ¿²¢·¢Êý¾ÝµÄÓÅÏÈÑ¡Ôñ¡£µ«ÓÐЩ´óÁ¿Êý¾ÝµÄ²¢·¢²¢²»ÊÇÊý¾Ý´¦Àí±¾ÉíµÄÎÊÌ⣬ÀýÈçÂß¼ÉϱØÐëÓÐÏȺó´ÎÐòµÄÊý¾ÝÊDz¢·¢ËٶȲ»Äܽâ¾öµÄÎÊÌâ¡£Å׿ªÕâЩÎÊÌâÒ»¸ö¼òµ¥´óÈÝÁ¿µÄ½â¾ö·½°¸ÊÇÓÃÒ»¸öÄÚ´æÊý¾Ý¿â×öǰ¶ËÒ»¸öÓ²ÅÌÊý¾Ý¿â×öºó¶Ë£¬ÄÚ´æÊý¾Ý¿â¶¨ÆÚ°ÑÊý¾Ýͬ²½µ½ºó¶ËµÄÓ²ÅÌÊý¾Ý¿â¡£Õâ¸ö·½ ......