Sqlite·µ»Ø¶à½á¹û¼¯ÎÊÌâ
Sqlite·µ»Ø¶à¸ö²éѯ½á¹û¼¯µÄʱºò£¬ÓÐʲô°ì·¨ÄÜÒÆ¶¯µ½ÏÂÒ»¸ö½á¹û¼¯ÉÏÈ¥
±ÈÈç
ÓÐÓï¾ä
select * from sqlite_master where type='table';select * from sqlite_master where type='index';
Õâ¸öÓï¾äÖ´ÐÐÆðÀ´£¬¾Í»á·µ»ØÁ½¸ö½á¹û¼¯
ÇëÎÊÓÐûÓÐÌṩAPIº¯ÊýÔÚÁ½¸ö½á¹û¼¯Çл»µÄ£¿
²»ÊÇÓõÄADO,¾ÍÊÇÓõÄSqlite×Ô¼ºµÄdll¿â
Õâ¸ö¿ÉÒÔÖ´ÐжàÌõÓï¾ä°¡£¬Ö»ÒªÓ÷ֺŷָî¾Í¿ÉÒÔÁË£¬ÓÃsqlite3.exeÖ´ÐÐÁ½Ìõ¶¼ÐУ¬Ö»ÊÇËû°ÉÁ½ÌõÓï¾äµÄÁ½¸ö½á¹û¼¯×ۺϷµ»ØÁË¡£
²»ÖªµÀÕâλ˵µÄ recordsets[0], recordset[1]£¬ÔõÑùÓã¡ÇëÏêÊö£¬Ð»Ð»
ÎÒÊÇÓõÄDelphi£¬ÓõÄZeosLib¿Ø¼þ×飬Õâ¸ö¶«Î÷Ò²ÊÇÓõÄSqliteµÄ¿ª·ÅAPI½Ó¿ÚʵÏֵģ¡ÀïÃæÓÐTZQuery;
query: TZQuery;
begin
query := TZQuery.create(nil);
query.con := ZConnection;
query.sql.add('select * from sqlite_master where type=''table'';');
query.sql.add('select * from sqlite_master where type=''index''; ');
query.open;
end;
ÄãÓá¡ZeosLib£¬Ó¦¸Ã²éѯһÏÂZeosLibµÄ°ïÖú¡£
ÎÊÌâÒѾ¸ã¶¨£¬£¡½á
Ïà¹ØÎÊ´ð£º
СµÜ Ūµã¶«Î÷¿ÉÊǵ÷Óà sqlite3_prepare Õâ¸öº¯Êý select ¾ÍºÃʹ Ö»Òª ¸Ä±äÊý¾Ý¿â µÄ¾Í²»ÐÐ ±ÈÈçinsert Ö®ÀàµÄ ËÀ´°ï¸öæ°¡ ÇëÎÊÕâÊÇʲôÔÒò °¡ Óà c ȥʵÏÖµÄ
ÄãÓõÄʲô¹¤¾ß°¡?
°ÑÄã×Ô¼ºµÄ´úÂë·¢ ......
ÎÒÖªµÀ´ó¼Ò¶¼ËµÊÇ64λϵͳϲ»ÄÜÓÃ32λµÄsyste.sqlite.dll¡£Õâ¸öÎÒÒѾ»»ÁË
VS2008ÖÐÔËÐж¼Ã»ÎÊÌ⣨ͬһϵͳÏ£©
Ò»·Åµ½IISÖоͱ¨´í£º
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°System.Data.SQLite¡±»òËüµÄijһ¸öÒÀÀµÏî¡£ÊÔͼ¼ÓÔØ¸ ......
ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éÑ¯Ê ......
Êý¾Ý¿âÖÐÓÐÒ»¸öusers±í¡£
create table users(name text, number text);
Ñ»·²åÈëÒ»°ÙÌõ£¬²»Ê¹ÓÃÊÂÎñµÄ»°£¬ÔÚÎҵĻúÆ÷ÉÏÐèÒª6s¡£
¶øÔÚÎÒÅóÓѵĻúÆ÷ÉÏÕâÑùµÄ²Ù×÷»¨·Ñ²»µ½1s¡£
¿ÉÄÜÊÇÄÄ·½ÃæµÄÔÒòµ¼ ......