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

SQLiteµÄ²éѯÓÅ»¯

±¾ÆªÎÄÕÂÀ´Ô´ÓÚ£º¿ª·¢Ñ§Ôº http://edu.codepub.com   Ô­ÎÄÁ´½Ó£ºhttp://edu.codepub.com/2009/0825/14358.php
SQLiteÊǸöµäÐ͵ÄǶÈëʽDBMS£¬ËüÓкܶàÓŵ㣬ËüÊÇÇáÁ¿¼¶µÄ£¬ÔÚ±àÒëÖ®ºóºÜС£¬ÆäÖÐÒ»¸öÔ­Òò¾ÍÊÇÔÚ²éѯÓÅ»¯·½Ãæ±È½Ï¼òµ¥£¬ËüÖ»ÊÇÔËÓÃË÷Òý»úÖÆÀ´½øÐÐÓÅ»¯µÄ£¬¾­¹ý¶ÔSQLiteµÄ²éѯÓÅ»¯µÄ·ÖÎöÒÔ¼°¶ÔÔ´´úÂëµÄÑо¿£¬ÎÒ½«SQLiteµÄ²éѯÓÅ×ܽá
SQLiteÊǸöµäÐ͵ÄǶÈëʽDBMS£¬ËüÓкܶàÓŵ㣬ËüÊÇÇáÁ¿¼¶µÄ£¬ÔÚ±àÒëÖ®ºóºÜС£¬ÆäÖÐÒ»¸öÔ­Òò¾ÍÊÇÔÚ²éѯÓÅ»¯·½Ãæ±È½Ï¼òµ¥£¬ËüÖ»ÊÇÔËÓÃË÷Òý»úÖÆÀ´½øÐÐÓÅ»¯µÄ£¬¾­¹ý¶ÔSQLiteµÄ²éѯÓÅ»¯µÄ·ÖÎöÒÔ¼°¶ÔÔ´´úÂëµÄÑо¿£¬ÎÒ½«SQLiteµÄ²éѯÓÅ×ܽáÈçÏ£º
Ò»¡¢Ó°Ïì²éѯÐÔÄܵÄÒòËØ£º
1£® ¶Ô±íÖÐÐеļìË÷ÊýÄ¿£¬Ô½Ð¡Ô½ºÃ
2£® ÅÅÐòÓë·ñ¡£
3£® ÊÇ·ñÒª¶ÔÒ»¸öË÷Òý¡£
4£® ²éѯÓï¾äµÄÐÎʽ
¶þ¡¢¼¸¸ö²éѯÓÅ»¯µÄת»»
1£® ¶ÔÓÚµ¥¸ö±íµÄµ¥¸öÁжøÑÔ£¬Èç¹û¶¼ÓÐÐÎÈçT.C=exprÕâÑùµÄ×Ӿ䣬²¢ÇÒ¶¼ÊÇÓÃOR²Ù×÷·ûÁ¬½ÓÆðÀ´£¬ÐÎÈ磺 x = expr1 OR expr2 = x OR x = expr3 ´ËʱÓÉÓÚ¶ÔÓÚOR£¬ÔÚSQLiteÖв»ÄÜÀûÓÃË÷ÒýÀ´ÓÅ»¯£¬ËùÒÔ¿ÉÒÔ½«Ëüת»»³É´øÓÐIN²Ù×÷·ûµÄ×Ӿ䣺x IN(expr1,expr2,expr3)ÕâÑù¾Í¿ÉÒÔÓÃË÷Òý½øÐÐÓÅ»¯£¬Ð§¹ûºÜÃ÷ÏÔ£¬µ«ÊÇÈç¹ûÔÚ¶¼Ã»ÓÐË÷ÒýµÄÇé¿öÏÂORÓï¾äÖ´ÐÐЧÂÊ»áÉÔÓÅÓÚINÓï¾äµÄЧÂÊ¡£
2£® Èç¹ûÒ»¸ö×Ó¾äµÄ²Ù×÷·ûÊÇBETWEEN£¬ÔÚSQLiteÖÐͬÑù²»ÄÜÓÃË÷Òý½øÐÐÓÅ»¯£¬ËùÒÔÒ²Òª½øÐÐÏàÓ¦µÄµÈ¼Ûת»»£º È磺a BETWEEN b AND c¿ÉÒÔת»»³É£º(a BETWEEN b AND c) AND (a>=b) AND (a<=c)¡£ ÔÚÉÏÃæÕâ¸ö×Ó¾äÖУ¬ (a>=b) AND (a<=c)½«±»ÉèΪdynamicÇÒÊÇ(a BETWEEN b AND c)µÄ×Ӿ䣬ÄÇôÈç¹ûBETWEENÓï¾äÒѾ­±àÂ룬ÄÇô×Ó¾ä¾ÍºöÂÔ²»¼Æ£¬Èç¹û´æÔÚ¿ÉÀûÓõÄindexʹµÃ×Ó¾äÒѾ­Âú×ãÌõ¼þ£¬ÄÇô¸¸¾äÔò±»ºöÂÔ¡£
3£® Èç¹ûÒ»¸öµ¥ÔªµÄ²Ù×÷·ûÊÇLIKE£¬ÄÇô½«×öÏÂÃæµÄת»»£ºx LIKE ‘abc%’£¬×ª»»³É£ºx>=‘abc’ AND x<‘abd’¡£ÒòΪÔÚSQLiteÖеÄLIKEÊDz»ÄÜÓÃË÷Òý½øÐÐÓÅ»¯µÄ£¬ËùÒÔÈç¹û´æÔÚË÷ÒýµÄ»°£¬Ôòת»»ºóºÍ²»×ª»»Ïà²îºÜÔ¶£¬ÒòΪ¶ÔLIKE²»Æð×÷Ó㬵«Èç¹û²»´æÔÚË÷Òý£¬ÄÇôLIKEÔÚЧÂÊ·½ÃæÒ²»¹ÊDZȲ»ÉÏת»»ºóµÄЧÂʵġ£
Èý¡¢ ¼¸ÖÖ²éѯÓï¾äµÄ´¦Àí£¨¸´ºÏ²éѯ£©
1£®²éѯÓï¾äΪ£º<SelectA> <operator> <selectB> ORDER BY <orderbylist> ORDER BY
     Ö´Ðз½·¨£º is one of UNION ALL, UNION, EXCEPT, or INTERSECT. Õâ¸öÓï¾äµÄÖ´Ðйý³ÌÊÇÏȽ«selectAºÍsele


Ïà¹ØÎĵµ£º

SQLite 3 һЩ»ù±¾Ê¹ÓÃ

ʹÓù¤¾ß£º 
      SQLite Expert SQLiteÊý¾Ý¿â¹ÜÀí¹¤¾ß£¬·Ç³£ºÃÓã¬ÀàËÆÎÒ֮ǰ½éÉܵÄEMS SQL Manager 2007 for MySQL
      System.Data.SQLite SQLite For ADO.NETÇý¶¯,ÀàËÆÎÒ֮ǰ½éÉܵÄMySql.Data.dll
Õâ2¸ö¹¤¾ß¶¼°üÀ¨ÁËSQLiteµÄÒýÇæ
1¡¢´Óhttp://www.s ......

ASPÁ¬½ÓSQLiteÊý¾Ý¿âÒ»Àý

ÒªÓÃASPÀ´²Ù×÷SQLiteÊý¾Ý¿â£¬Ç°ÌáÌõ¼þÊÇÔÚ·þÎñÆ÷Éϵð²×°SQLiteµÄODBCÇý¶¯³ÌÐò£¬¿Éµ½Õâ¸öÕ¾µãÉÏÏÂÔØ°²×°£ºhttp://www.ch-werner.de/sqliteodbc/£¬°²×°ºÃºó¾Í¿ÉÒÔÏñʹÓÃAccessÒ»ÑùÀ´Ê¹ÓÃSQLiteÁË£¡Ï±ßÊÇÒ»¸öSQLiteÊý¾Ý¿â½á¹¹£º
ÒýÓÃÄÚÈÝ
Create TABLE admin(username text,age integer);
ÎÒÃÇÔÙÀ´ÓÃASPÑÝʾÏÂÈçºÎ¶ÔSQLi ......

SQLite3 C/C++ ¿ª·¢½Ó¿Ú¼ò½é£¨APIº¯Êý£©


SQLite3ÊÇSQLiteÒ»¸öȫеİ汾,ËüËäÈ»ÊÇÔÚSQLite 2.8.13µÄ´úÂë»ù´¡Ö®ÉÏ¿ª·¢µÄ,µ«ÊÇʹÓÃÁ˺Í֮ǰµÄ°æ±¾²»¼æÈݵÄÊý¾Ý¿â¸ñʽºÍAPI. SQLite3ÊÇΪÁËÂú×ãÒÔϵÄÐèÇó¶ø¿ª·¢µÄ:
Ö§³ÖUTF-16±àÂë.
Óû§×Ô¶¨ÒåµÄÎı¾ÅÅÐò·½·¨.
¿ÉÒÔ¶ÔBLOBs×ֶν¨Á¢Ë÷Òý.
Òò´ËΪÁËÖ§³ÖÕâÐ©ÌØÐÔÎҸıäÁËÊý¾Ý¿âµÄ¸ñʽ,½¨Á¢ÁËÒ»¸öÓë֮ǰ°æ±¾²»¼æÈݵ ......

sqliteºÍpdo mysqlµÄÊý¾Ý¿â²Ù×÷

½ñÌìµÄѧϰÄÚÈÝÊÇsqliteºÍPDO mysql¡£
ÓÃ×Ô¼ºµÄ»°ËµËµÁ½¸ö¶«Î÷°É£º
sqliteËãÊÇÒ»ÖÖ²»ÏµÍ³µÄÊý¾Ý¿â´æ´¢·½Ê½£¬ËüµÄ´æ·Å¸ñʽÊÇÒ»¸ö.dbºó׺µÄÎļþ£¬ÔÚphpÖÐËü´æ·ÅÔÚµ±Ç°µÄĿ¼Ï£¬Ã²ËƲ»ÓÃÓû§ÃûÃÜÂ룬°²È«ÐԽϵͣ¬È´±È½Ï·½±ã¡£PHP5ÖÐ×Ô´øµÄһЩϵͳº¯Êý£¬¶¼ÊÇÒÔsqlite_¿ªÍ·µÄ¡£
PDOÈ«³ÆPHP Data Object£¬¹ËÃû˼Òå¾ÍÊÇPHPµÄÒ ......

sqliteÊý¾Ý¿â»ù±¾²Ù×÷

//²åÈë¼°¸üвÙ×÷
 int nRet = 0;
 sqlite3 * db = NULL;
 CString strFilePath;  //Êý¾Ý¿â´æ´¢Â·¾¶
//·¾¶¸³Öµ£¨Ê¡ÂÔ£©
 //Á¬½ÓÊý¾Ý¿â
 nRet = sqlite3_open16(strFilePath, &db);    //Óм¸¸ö´ò¿ªº¯Êý¿É¹©µ÷Óã¬Ê¹ÓÃWCHARÀàÐÍ·¾¶ÓÃÕâ¸ö
 if(nRet != SQLIT ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ