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µÄ°ïÖú¡£
ÎÊÌâÒѾ¸ã¶¨£¬£¡½á
Ïà¹ØÎÊ´ð£º
string ConStr="data source=C:\ceshi.db;verson=3;password=123456";
SQLiteConnection MyConnection = new SQLiteConnection(ConStr);
try
{ ......
¹ØÓÚjuliandayº¯ÊýµÄÎÊÌ⣬ÎÒÏÖÔÚ±íAÖÐÒ»¸ö×Ö¶Îbʱ¼äÀàÐÍ£¬ÈçºÎbΪ½ñÌìµÄÊý¾Ý£¿Ð»Ð»
select * from ±íÃû where datediff(d,getdate(),×Ö¶Îb)=0 ÕâÑùÄã¿´Ðв»£¿
ÎÒÓõÄÊÇsqliteÊý¾Ý¿â£¬Ëü²»Ö§³ÖdatediffµÄ¡ ......
Êý¾Ý¿âÖÐÓÐÒ»¸öusers±í¡£
create table users(name text, number text);
Ñ»·²åÈëÒ»°ÙÌõ£¬²»Ê¹ÓÃÊÂÎñµÄ»°£¬ÔÚÎҵĻúÆ÷ÉÏÐèÒª6s¡£
¶øÔÚÎÒÅóÓѵĻúÆ÷ÉÏÕâÑùµÄ²Ù×÷»¨·Ñ²»µ½1s¡£
¿ÉÄÜÊÇÄÄ·½ÃæµÄÔÒòµ¼ ......
¸Õѧsqlite£¬´´½¨Á˸ö±í£¬Í˳ösqliteÓÖÖØÐ´ò¿ªºó£¬²éѯ˵ûÓÐÕâ¸ö±í¡£ÔõôÑù²ÅÄܱ£´æÕâ¸ö±íÄØ£¬windowsÏÂ
Ö±½ÓÔËÐÐsqlite3.exe,È»ºó¾Í¾ÍÖ±½Ócreate table TestÁË
Í˳ösqlite3.exe ÖØÐ´ò¿ª£¬select¾ÍÌáʾûÓÐÕâ ......