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
{ ......
¸üÐÂÓï¾äÖУº
UPDATE sc SET AA=INT(BB)
ÎÒÏëÈÃAAµÃµ½BBµÄÕûÊýÖµ¡£¿ÉÊÇÔËÐб¨´í¡£
²»ÖªµÀSQLiteÏ ȡÕûÊý²¿·ÖµÄº¯ÊýÊÇÄĸö£¿£¨ËÄÉáÎåÈëµÄº¯ÊýÓÖÊÇÄĸö£¿£©¡£
Èç¹ûÖªµÀ»¹ÓÐÆäËûº¯ÊýÇëÒ»²¢¸æÖª£¬Ð»Ð»¡£
ROUND
......
¹ØÓÚjuliandayº¯ÊýµÄÎÊÌ⣬ÎÒÏÖÔÚ±íAÖÐÒ»¸ö×Ö¶Îbʱ¼äÀàÐÍ£¬ÈçºÎbΪ½ñÌìµÄÊý¾Ý£¿Ð»Ð»
select * from ±íÃû where datediff(d,getdate(),×Ö¶Îb)=0 ÕâÑùÄã¿´Ðв»£¿
ÎÒÓõÄÊÇsqliteÊý¾Ý¿â£¬Ëü²»Ö§³ÖdatediffµÄ¡ ......
ÏÖÔÚÏë×öÒ»¸ö½øÏú´æ,¿ÉÄÜ»áÓÐ20ÈËͬʱһÆðÓÃ
²»ÖªµÀµ½ÊÇÑ¡Ôñ sqlite »¹ÊÇ access
´ó¼Ò¸ø¸øÒâ¼û°É
»¹ÊÇÓÃaccess°É£¬ÒòΪÄã¿Ï¶¨ÊÇÓÃ.net¿ª·¢£¬³öÁËʲôÎÊÌâµÄ»°ºÃ½â¾öһЩ¡£
Èç¹ûÓÃsqlite×ÊÁÏÏà¶Ô±È½ÏÉÙ¡£
²»¹ýÌý ......