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

SQLite C/C++½Ó¿Ú½éÉÜ

ÕâƪÎÄÕÂÊÇʹÓÃSQLite C/C++½Ó¿ÚµÄÒ»¸ö¸ÅÒª½éÉܺÍÈëÃÅÖ¸ÄÏ¡£
ÓÉÓÚÔçÆÚµÄSQLiteÖ»Ö§³Ö5¸öC/C++½Ó¿Ú£¬Òò¶ø·Ç³£ÈÝÒ×ѧϰºÍʹÓ㬵«ÊÇËæ×ÅSQLite¹¦ÄܵÄÔöÇ¿£¬ÐµÄC/C++½Ó¿Ú
²»¶ÏµÄÔö¼Ó½øÀ´£¬µ½ÏÖÔÚÓг¬¹ý150¸ö²»Í¬µÄAPI½Ó¿Ú¡£ÕâÍùÍùʹ³õѧÕßÍû¶øÈ´²½¡£ÐÒÔ˵ÄÊÇ£¬´ó¶àÊýSQLiteÖеÄC/C++½Ó¿ÚÊÇרÓõģ¬Òò¶øºÜÉÙ±»
ʹÓõ½¡£¾¡¹ÜÓÐÕâô¶àµÄµ÷Óýӿڣ¬ºËÐĵÄAPIÈÔÈ»Ïà¶Ô¼òµ¥ºÍ±ãÓÚµ÷Óᣱ¾Æ¬ÎÄÕµÄÄ¿µÄ¾ÍÊÇΪÁËÄܹ»¸üÒ×ÓÚÀí½âSQLiteµÄÔË×÷Ìṩ»ù´¡µÄ֪ʶ¡£
Áíһƪ¶ÀÁ¢µÄÎĵµ¡¶The SQLite C/C++
Interface¡·¶ÔSQLiteÖеÄËùÓÐC/C++½Ó¿ÚÌṩÁËÏêϸµÄʹÓÃ˵Ã÷¡£Ò»µ©¶ÁÕßÀí½âÁËSQLiteµÄ»ù±¾²Ù×÷Ô­Àí£¬ÕâƪÎĵµ¾ÍÓ¦µ±×÷Ϊһ±¾²Î
¿¼Êֲᡣ±¾ÆªÎÄÕ½ö½öÊÇSQLiteµÄÒ»¸öÈëÃŽéÉÜ£¬¶ø²»ÊÇÍêÕûºÍȨÍþÐÔµÄSQLite API²Î¿¼Ö¸ÄÏ¡£
1.0 ºËÐĶÔÏóºÍ½Ó¿Ú
SQLÊý¾Ý¿âÒýÇæµÄ×îÖ÷ÒªÈÎÎñÊǽâÎöSQLÓï¾ä¡£ÎªÁË´ï³ÉÕâ¸öÄ¿µÄ£¬¿ª·¢ÕßÐèÒªÁ˽âÁ½¸ö¶ÔÏó£º
* Êý¾Ý¿âÁ¬½Ó¶ÔÏó£ºsqlite3
* Ô¤´¦ÀíÓï¾ä¶ÔÏó£ºsqlite3_stmt
ÑϸñÀ´½²£¬Ô¤´¦ÀíÓï¾ä¶ÔÏó²¢²»ÊDZØÐëµÄ£¬ÒòΪÄܹ»Ê¹ÓÃsqlite_exec»òÕßsqlite3_get_tableÕâЩ±ãÓÚʹÓõķâ×°½Ó¿Ú£¬¶øÕâЩ½Ó¿Ú·â×°²¢Òþ²ØÁËÔ¤´¦ÀíÓï¾ä¶ÔÏó¡£¾¡¹ÜÈç´Ë£¬¶ÔÔ¤´¦Àí¶ÔÏóµÄÀí½âÓÐÖúÓÚÎÒÃǸü³ä·ÖµÄʹÓÃSQLite¡£
Êý¾Ý¿âÁ¬½Ó¶ÔÏóºÍÔ¤´¦Àí¶ÔÏóÊÇÓÉÏÂÁеÄÒ»×éC/C++½Ó¿Úµ÷ÓòÙ×ݵģº
* sqlite3_open()
* sqlite3_prepare()
* sqlite3_step()
* sqlite3_column()
* sqlite3_finalize()
* sqlite3_close()
Õâ6¸öC/C++½Ó¿ÚÀý³ÌºÍÉÏÊöµÄÁ½¸ö¶ÔÏó¹¹³ÉÁËSQLiteµÄºËÐŦÄÜ¡£¿ª·¢Õ߶ÔÓÚËüÃǵÄÀí½âÄܹ»¸üºÃµÄʹÓÃSQLite¡£
×¢Ò⣬Õâ¸ö½Ó¿ÚÀý³ÌÁбí¸ü¶àÊǸÅÄîÉϵÄÒâÒå¶ø²»ÊÇʵ¼ÊµÄ½Ó¿Ú¡£Ðí¶àÕâЩ½Ó¿Ú¶¼³öÏÖÔÚ¸÷¸ö°æ±¾Ö®ÖС£ÀýÈ磬ÉÏÊöÁбíÖеÄ
sqlite3_open()Àý³Ìʵ¼ÊÉÏÓÐÈý¸ö²»Í¬µÄ½Ó¿ÚÒÔÂÔ΢²»Í¬µÄ·½Ê½ÊµÏÖÏàͬµÄ¹¦
ÄÜ£ºslqite3_open()£¬sqlite3_open16()ºÍsqlite3_open_v2()¡£ÁбíÖеÄʵ¼ÊÉϲ¢²»´æÔÚ
sqlite3_column()Õâ¸ö½Ó¿Ú¡£ÏÔʾÔÚÁбíÖеēsqlite3_column()”½ö½öÊÇÒ»¸öռ룬±íʾһÕûÌ×ÓÃÓÚ´Ó±íÖвéѯ³ö¸÷ÖÖÊý¾ÝÀà
Ð͵ÄÁмǼ½Ó¿Ú¡£
ÕâÀï˵Ã÷ϺËÐĽӿڵÄÖ÷Òª¹¦ÄÜ£º
* sqlite3_open()
¸Ã½Ó¿Ú´ò¿ªÓëÒ»¸öSQLiteÊý¾Ý¿âÎļþµÄÁ¬½Ó²¢·µ»ØÒ»¸öÊý¾Ý¿âÁ¬½Ó¶ÔÏó¡£Õâͨ³£ÊÇÓ¦ÓóÌÐòµ÷ÓõĵÚÒ»¸öSQLite
API½Ó¿Ú¶øÇÒÒ²Êǵ÷ÓÃÆäËûSQLite
API½Ó¿ÚÇ°ÐèÒªµ÷ÓõĽӿڡ£Ðí¶àSQLite½Ó¿ÚÐèÒªÒ»¸öÖ¸ÏòÊý¾Ý¿âÁ¬½Ó¶ÔÏóµÄÖ¸Õë×÷ΪËüÃǵĵÚÒ»¸ö²ÎÊý£¬Òò¶øÕâЩ½Ó


Ïà¹ØÎĵµ£º

LinuxÇý¶¯¿ª·¢Ö®S3C2440°´¼üµãÁÁLED

ÎÄռǼÁË×÷ÕßÔÚS3C2440¿ª·¢°åÉÏʵÏÖ°´¼üµãÁÁLEDÇý¶¯¿ª·¢µÄÏêϸ¹ý³Ì£¬»¹¼Ç¼ÁËһЩÈÝÒ׳öÏֵĴíÎó£¬ÒÔ¼°Ôõô½â¾öÕâЩ´íÎó¡£
Ò»¡¢Çý¶¯¿ª·¢Á÷³Ì
       LinuxÇý¶¯¿ª·¢²»Í¬ÓÚÓ¦ÓóÌÐòµÄ¿ª·¢¡£Çý¶¯¿ª·¢ÊÇÖ±½ÓºÍÓ²¼þ´ò½»µÀµÄ£¬Í¨¹ý¶ÔÓ²¼þµÄ²Ù×÷¸øÓ¦ÓóÌÐòÌṩһЩ½Ó¿Úº¯Êý£¬Ê¹µÃÓ¦ÓóÌÐòÄܹ»&l ......

C/C++ header file lists

  C/C++Í·ÎļþÒ»ÀÀ ÊÕ²Ø
C/C++Í·ÎļþÒ»ÀÀ
C¡¢´«Í³ C++
#include <assert.h>¡¡¡¡¡¡¡¡//É趨²åÈëµã
#include <ctype.h>¡¡¡¡¡¡¡¡ //×Ö·û´¦Àí
#include <errno.h>¡¡¡¡¡¡¡¡ //¶¨Òå´íÎóÂë
#include <float.h>¡¡¡¡¡¡¡¡ //¸¡µãÊý´¦Àí
#include <fstream.h>¡¡¡¡¡¡ //ÎļþÊäÈ룯Êä³ö
#i ......

C¡¢C++ÖеÄÈÕÆÚºÍʱ¼ä time_tÓëstruct tmת»»

Ò»£®¸ÅÄî
Coordinated Universal Time£¨UTC£©£ºÐ­µ÷ÊÀ½çʱ£¬ÓÖ³ÆΪÊÀ½ç±ê׼ʱ¼ä£¬Ò²¾ÍÊÇ´ó¼ÒËùÊìÖªµÄ¸ñÁÖÍþÖαê׼ʱ¼ä£¨Greenwich Mean Time£¬GMT£©¡£±ÈÈ磬ÖйúÄڵصÄʱ¼äÓëUTCµÄʱ²îΪ+8£¬Ò²¾ÍÊÇUTC+8¡£ÃÀ¹úÊÇUTC-5¡£
Calendar Time£ºÈÕÀúʱ¼ä£¬ÊÇÓÓ´ÓÒ»¸ö±ê׼ʱ¼äµãµ½´ËʱµÄʱ¼ä¾­¹ýµÄÃëÊý”À´±íʾµÄʱ¼ä¡ ......

SQLite ³õ̽

»¹Êdzõ̽£¬×öµÄÏîÄ¿ÒªÓõ½ÇáÇɵı¾µØÊý¾Ý¿â£¬ÓÚÊÇÕÒÁË sqlite 3 ÊÔÓÃÖ®£¬»¹²»´í£¬¹»ÇáÇÉ¡£
ÉÏÕâ¶ùÈ¥ÏÂÔسÌÐòºÍ²é¿´Îĵµ£º http://www.sqlite.org/download.html
Õâ»Ø¿ª·¢ÓõÄÊÇ C#£¬ÓÚÊÇÕÒÁ˸ö.NETµÄ¿â Finisar.SQLite £¬µ½Õâ¶ùÈ¥ÔØ http://adodotnetsqlite.sourceforge.net/
Òª¼ÇµÄÒ²²»ÊÇʲô´ó²»Á˵Ķ«Î÷£¬Ê¾ÀýÍøÕ¾É϶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ