VC++ÍùACCESSдÊý¾ÝµÄÎÊÌâ - VC/MFC / Êý¾Ý¿â
ÎÒÔÚVC++ÀﶨÒåÁ˼¸¸öÈ«¾Ö±äÁ¿£¬¾¹ýһϵÁеļÆËãÖ®ºó£¬½«ÕâЩȫ¾Ö±äÁ¿µÄÖµ´æµ½ACCESS¶ÔÓ¦µÄ×Ö¶ÎÏÂÃæ¡£²»Öª¸ÃÈçºÎʵÏÖ¡£Õ⼸¸ö±äÁ¿ÓÐSTRING£¬Ò²ÓÐDOUBLEÀàÐ͵ġ£¸ÃACCESS²»ÓëÈκζԻ°¿òÓбäÁ¿Êý¾Ý´«µÝµÄÁªÏµ£¬½ö½öÊÇ´¢´æ×îºóºÍһϵÁнá¹û¡£
ÎҵijÌÐòÓõÄÊÇODBC£¬²»ÊÇADO¡£¿ÉÒÔÔÚODBCÉÏÌî ¼ÓADOµÄÓï¾äÂð£¿
²»ÒªÓÃODBC£¬ÄÇʱ×îÔçµÄ¼¼Êõ£¬ADO±ÈËü¿ìËÙÏȽø£¬ODBCºÍADO
ÊÇÁ½ÖÖ¼¼Êõ£¬²»ÄÜ»¥²Ù×÷¡£
·ÇÒªÓÃODBCµÄ»°£¬ÔÚÉÏÃæÄǸöÍøÕ¾ÕÒÕÒÀý×Ó¡£
Ò»£®¸ÅÊö
----ODBCÊÇÒ»ÖÖʹÓÃSQLµÄ³ÌÐòÉè¼Æ½Ó¿Ú¡£Ê¹ÓÃODBCÈÃÓ¦ÓóÌÐòµÄ±àдÕß±ÜÃâÁËÓëÊý¾ÝÔ´ÏàÁªµÄ¸´ÔÓÐÔ¡£ÕâÏî¼¼ÊõĿǰÒѾµÃµ½ÁË´ó¶àÊýDBMS³§ÉÌÃǵĹ㷺֧³Ö¡£
----Microsoft Developer StudioΪ´ó¶àÊý±ê×¼µÄÊý¾Ý¿â¸ñʽÌṩÁË32λODBCÇý¶¯Æ÷¡£ÕâЩ±ê×¼Êý¾Ý¸ñʽ°üÀ¨ÓУºSQL Server¡¢Access¡¢Paradox¡¢dBase¡¢FoxPro¡¢Excel¡¢OracleÒÔ¼°Microsoft Text¡£Èç¹ûÓû§Ï£ÍûʹÓÃÆäËûÊý¾Ý¸ñʽ£¬Óû§ÐèÒªÏàÓ¦µÄODBCÇý¶¯Æ÷¼°DBMS¡£
----Óû§Ê¹ÓÃ×Ô¼ºµÄDBMSÊý¾Ý¿â¹ÜÀí ¹¦ÄÜÉú³ÉеÄÊý¾Ý¿âģʽºó£¬¾Í¿ÉÒÔʹÓÃODBCÀ´µÇ¼Êý ¾ÝÔ´¡£¶ÔÓû§µÄÓ¦ÓóÌÐòÀ´Ëµ£¬Ö»Òª°²×°ÓÐÇý¶¯³ÌÐò£¬¾ÍÄÜ×¢²áºÜ¶à²»Í¬µÄÊý¾Ý¿â¡£µÇ¼Êý¾Ý¿âµÄ¾ßÌå²Ù×÷²Î¼ûÓйØODBCµÄÁª»ú°ïÖú¡£
--------------------------------------------------------------------------------
¶þ£®MFCÌṩµÄODBCÊý¾Ý¿âÀà
----VisualC++µÄMFC»ùÀà¿â¶¨ÒåÁ˼¸¸öÊý¾Ý¿âÀà¡£ÔÚÀûÓÃODBC±à³Ìʱ£¬¾³£ÒªÊ¹Óõ½CDatabase(Êý¾Ý¿âÀà)£¬CRecordSet(¼Ç¼¼¯Àà)ºÍCRecordView(¿ÉÊӼǼ¼¯Àà)¡£ Æ
Ïà¹ØÎÊ´ð£º
дÁ˸ö²âÊÔ³ÌÐòÈçÏÂ
struct hostent *hp;
char AlarmDevIP[20];
int x2;
hp = gethostbyname("www.google.com");
if (hp)
{
......
´ó¼ÒºÃ£¬ÕâÊÇÒ»¸öÖ÷ÒªÃæÏòc/c++/mfcµÄȺ£¬×î½ü½øÐÐÁËÒ»´Î´óÇåÀí£¬»¶Ó¸÷λ¸ßÊÖ¼ÓÈ룬ºÃѧ°®ÎʵÄÐÂÊÖ£¬Ò²¿ÉÒÔÉêÇëµÄ£¬ÉêÇë¸ñʽ Ö°Òµ£¨c/c++/mfc ÈÎѡһ»òÕ߶ࣩ ¹¤×÷ÄêÏÞ£¨Ñ§ÉúÖ±½Óд´ó¼¸£©¾ÍÐÐÁË£¬ÈëȺµÄÒªÇó¾ÍÊÇÒª» ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
ÔÚ¸ùĿ¼/libÖдæ·ÅÒ»¸ölog.c£¬log.h£¬²¢ÓÃÏÂÃæµÄÓï¾ä£º
gcc -c log.c
ar crv liblog.a log.o
±àÒë³öÒ»¸öliblog.a¾²Ì¬¿â£¬È»ºóÔÚÎļþ¼Ð£º/testfileÖд´½¨Ò»¸ötest.cºÍtestc.c£¬test.cÖÐÒýÓÃÁËtestc.cÖж¨ÒåµÄ·½·¨ ......