ÊÖ»úÕ¾
ÍøÍ¨·ÖÕ¾
µçÐÅÖ÷Õ¾
ÃÜ¡¡Âë:
Óû§Ãû£º
µ±Ç°Î»Öà : Ö÷Ò³>³ÌÐòÉè¼Æ>Java¼¼Êõ>Áбí

JDBC¼¼Êõ½éÉÜ

À´Ô´£º»¥ÁªÍø ×÷Õߣºwest263.com ʱ¼ä£º2008-02-23
Î÷²¿ÊýÂë-È«¹úÐéÄâÖ÷»ú10Ç¿£¡40ÓàÏîÐéÄâÖ÷»ú¹ÜÀí¹¦ÄÜ,È«¹úÁìÏÈ!Ë«Ïß¶àÏßÐéÄâÖ÷»úÄϱ±·ÃÎʳ©Í¨ÎÞ×è!Ãâ·ÑÔùËÍÆóÒµÓʾÖ,.CNÓòÃû,×ÔÖú½¨Õ¾480ÔªÆð,Ãâ·ÑÊÔÓÃ7Ìì,ÂúÒâÔÙ¸¶¿î! P4Ö÷»ú×âÓÃ799Ôª/ÔÂ.Ô¸¶Ãâѹ½ð!
1. ½é ÉÜ Java

¡¡¡¡Ðí¶à¿ª·¢ÕߺÍÓû§¶¼ÔÚѰÕÒ³ÌJavaÐòÖзÃÎÊÊý¾Ý¿âµÄ±ã½Ý·½·¨¡£ÓÉÓÚÊÇdownload Ò»¸ö½¡×³£¬°²È«£¬Ò×ÓÚʹÓõģ¬Ò×ÓÚÀí½âÇÒ¿ÉÒÔ´ÓÍøÂçÖÐ×Ô¶¯£¬CËùÒÔËü³ÉΪ¿ª·¢Êý¾Ý¿âÓ¦ÓõÄÒ»ÖÖÁ¼ºÃµÄÓïÑÔ»ù´¡¡£ËüÌṩÁË,C Smalltalk ,, BASIC, COBOL, and 4GLsµÄJavaÐí¶àÓŵ㡣Ðí¶à¹«Ë¾ÒѾ­¿ªÊ¼ÔÚÓëDBMSµÄ Á¬½Ó·½Ãæ×ö¹¤×÷¡£ Java

¡¡¡¡Ðí¶àÓ¦DBMSÓÿª·¢Õß¶¼Ï£ÍûÄܹ»±àд¶ÀÁ¢ÓÚÌØ¶¨µÄDBMS³ÌÐò£¬¶øÎÒÃÇÒ²ÏàÐÅÒ»¸ö¶ÀÁ¢ÓÚµÄDBMS½Ó¿Ú½«Ê¹µÃÓë¸÷ÖÖ¸÷ÑùÁ¬SQL½Ó±äµÃ×îΪ±ã½Ý£¬¿ª·¢¸ü¼ÓѸËÙ¡£ËùÒÔÎÒÃÇÈÏΪ¶¨ÒåÒ»¸öͨÓõÄÊýJava¾Ý¿â´æÈ¡¿ò¼Ü£¬ÔÚ¸÷ÖÖ¸÷ÑùµÄÌṩÊý¾Ý¿âÁ¬½ÓÄ£¿éÉÏÌṩͳһµÄ½çÃæÊÇÊ®·ÖÓÐÒâÒåµÄ¡£Õâʹ³ÌÐòÔ±¿ÉÒÔÃæ¶Ôµ¥Ò»µÄÊý¾Ý¿â½çÃæ£¬Ê¹Êý¾Ý¿âÎ޹صŤSQL¾ßºÍ²úÆ·³ÉΪ¿ÉÄÜ£¬Ê¹µÃÊý¾Ý¿âÁ¬½ÓµÄ¿ª·¢Õß¿ÉÒÔÌṩ¸÷ÖÖ¸÷ÑùµÄÁ¬½Ó·½°¸¡£ÎÒÃÇ¿´µ½ÎÒÃǶ¨ÒåÒ»¸öͨÓõͲãµÄ£¬Ö§³Ö»ù±¾¹¦JavaDataBase Connectivity ÄܵÄ(JDBC)APIµÄ ½ôÆÈÈÎÎñ¡£ SQL API

¡¡¡¡ÐÒÔ˵ÄÊÇÎÒÃDz»±Ø´ÓÍ·Éè¼ÆÒ»¸ö¡£ XÎÒÃÇ¿ÉÒÔ°ÑÎÒÃǵŤ×÷½¨Á¢ÔÚ/Open SQL CLI (Microsoftµ÷Óòã½Ó¿Ú)Ö®ÉÏ(ËüÒ²ÊÇ's ODBC µÄ »ù´¡)¡£ Java

¡¡¡¡ÎÒÃÇÖ÷ÒªÈÎÎñÊǶ¨ÒåÒ»¸ö×ÔÈ»µÄ½ÓX¿ÚÀ´Óë/Open CLIÖÐ ¶¨ÒåµÄ»ù±¾µÄ³éÏó²ãºÍ¸ÅÄîÁ¬½Ó¡£ JDBC API

¡¡¡¡µÃISVµ½Êý¾Ý¿â¿ª·¢³§ÉÌ£¬Á¬½Ó¿ª·¢³§ÉÌ£¬,ODBCÒÔ¼°Ó¦Óÿª·¢ÕßµÄÖ§³ÖÊÇÊ®·ÖÖØÒªµÄ¡£ÎÒÃÇÏàÐŰÑÎÒÃǵŤ×÷½¨Á¢ÔÚ³éJDBCÏó²ãµÄ»ù´¡ÉϽ«¸üODBC¼ÓÈÝÒ׵õ½´ó¼ÒµÄ½ÓÊÜ¡£¶øÇÒ´Ó¼¼ÊõÉÏÀ´Ëµ£¬ÊÇ ÎÒÃÇÉè¼Æ¹¤×÷µÄÒ»¸öÁ¼ºÃ»ù´¡¡£ ODBC

¡¡¡¡ÒòΪÊÇCÒ»¸öÓïODBCÑÔ½Ó¿Ú£¬ËùÒÔÔÚJavaÖÐJavaÖ±½ÓʹÓò»Êʵ±¡£´ÓÖÐCÀ´µ÷ÓôúJavaÂëÔÚ°²È«ÐÔ£¬½¡×³ÐÔ£¬ÊµÏֵķ½±ã£¬¿ÉÒÆÖ²ÐԵȵȷ½ÃæÓÐÐí¶à²»±ã¡£ËüʹµÃÔÚ ÕâЩ·½ÃæµÄÐí¶àÓŵãµÃ²»µ½·¢»Ó¡£ ODBC

¡¡¡¡ÎÒÃÇÒѾ­ÔÚ¶ÌÆÚÀïÃæÊµÏÖÁËÒ»¸ö½¨Á¢ÔÚÉÏAPIµÄ¡£ ³¤Ô¶À´¿´£¬ÎÒÃÇ¿ÉÒÔͨ¹ýÆäËû·½Ê½ÌṩʵÏÖ¡£ 1. 1.

×¢ Òâ JDBC

¡¡¡¡ÎÒÃǷdz£¸ÐлÔÚÊý¾Ý¿â£¬Êý¾Ý¿âÁ¬½ÓºÍÊý¾Ý¿â¹¤¾ßÁìÓòµÄÐí¶àÔçÆÚµÄ¹¤×÷Õß¡£ËûÃÇΪµÄ ÔçÆÚ²Ý°¸ÌṩÁ˺ܺõÄÒâ¼ûºÍ½¨Òé¡£ËûÃǵŤ×÷¶Ô±¾¹æ·¶ÆðÁ˲»¿É¹ÀÁ¿µÄ×÷Óá£

¡¡ 2.

Ä¿ ±êÓëÕÜѧ API

¡¡¡¡Õâ¸ö²¿·ÖÃèÊöÁËÖ¸ÒýÕâ¸ö¿ª ·¢µÄÄ¿±êÒÔ¼°ÕÜѧ¡£ 2. 1. SQL

¼¶ API Java

¡¡¡¡ÎÒÃǵÄÖ÷ҪĿ±êÊÇΪ¶¨call-levelÒåÒ»¸ö"µ÷Óü¶¡±()SQLµÄ½ÓSQL¿Ú¡£×ÅÒâζ×ÅÎÒÃÇÖ÷ÒªµÄ×¢ÒâÁ¦¼¯ÖÐÔÚÖ´ÐÐÔ­Ô­±¾±¾µÄÓïAPI¾ä²¢ÇÒÈ¡»Ø½á¹û¡£ÎÒÃÇÔ¤¼Æ¸ß²ãµÄÒ² ½«±»¶¨Ò壬ÕâЩ¿ÉÄܽ«½¨Á¢ÔÚ»ù²ãµÄ½Ó¿ÚÉÏ¡£ Java

¡¡¡¡ÕâЩ¸ß²ã½Ó¿Ú°üÀ¨ÏóÖ±½ÓµØ¡¢Í¸Ã÷µØ°Ñ±íÀïÃæµÄÊý¾ÝÓ°Éäµ½ÀàJavaÀïÃæ£¬ÓÃÓï·¨Ê÷±íʾ¸ü¼ÓͨÓõIJéѯ£¬ÒÔ¼°ÄÚSQLǶµÄÓï ·¨¡£ API

¡¡¡¡ÎÒÃÇÏ£Íû´óÁ¿µÄÓ¦Óÿª·¢¹¤¾ß½«Ê¹ÓÃÎÒÃǵġ£APIÈ»¶øÎÒÃÇҲϣÍû³ÌÐòÔ±Äܹ»Ê¹ÓÃÎÒÃǵģ¬JavaÓÈÆäÊÇĿǰÕâÑùÔÚÀï ûÓÐÈÎºÎÆäËûÊÖ¶Î(Ó¦¸ÃÊÇ˵Êý¾Ý¿â·ÃÎÊÊÖ¶Î)µÄÇé¿öÏ¡£ 2. 2.

×ñSQL Ñ­ SQL

¡¡¡¡Êý¾Ý¿âϵͳ֧³Ö¸÷ʽ¸÷ÑùµÄÓïSQL·¨ºÍÓïÒ壬ËüÃÇÏ໥֮¼äÔڱȽϸ߼¶µÄ¹¦ÄÜÀýÈçÍⲿÁ¬½Ó£¬ÄÚǶ¹ý³ÌµÈ·½Ãæ²¢²»Ò»Ö£¬¾¡¹ÜÎÒÃÇÄܹ»ÅÎÍû×ÅËæÊ±¼äµÄÍÆÒÆÕâЩ²¿·ÖµÄ¿É ÒÔ»ñµÃ±ê×¼»¯¡£Í¬Ê±ÎÒÃDzÉÈ¡ÕâÑùµÄ̬¶ÈÓëÁ¢³¡£º In fact

¡¡¡¡, an application query need not even be SQL, or it may be a specialized derivative of SQL, e.g. for document or image queries, designed for specific DBMSs. In order to pass JDBC compliance tests and to be called

¡¡¡¡"JDBC COMPLIANT " we require that a driver support at least ANSI SQL-2 Entry Level. This gives applications that want wide portability a guaranteed least common denominator. We believe ANSI SQL-2 Entry Level is reasonably powerful and is reasonably widely supported today. * JDBC

ÔÊSQLÐí²éѯ±í´ïʽֱ½Ó´«µÝµ½µ×²ãµÄÊý¾ÝÇý¶¯£¬ÕâÑùÒ»¸ö³ÌÐò¿ÉÒÔ»ñµÃ¾¡Á¿¶àµÄ¹¦DBMSÄÜ£¬µ«ÊÇ¿ÉÄܱ»¾ÜSQL¾ø¡£ÊÂʵÉÏ£¬Ò»¸ö³ÌÐòµÄ²éѯÉõÖÁ¿ÉÒÔ²»ÊǵÄSQL£¬»òÕßÊÇµÄ Ò»¸öÌØÊâÑÝ»¯£¬ÀýÈ磺ΪרÃÅÊý¾Ý¿âÉè¼ÆµÄÎı¾»òÕßͼÐβéѯ¡£ *

ΪJDBCÁËͨ¹ý¼æJDBCÈݵIJâÊÔ£¬²¢ÇÒÄܹ»±»³ÆÎª¼æANSI SQL-2ÈÝ£¬ÎÒÃÇÒªÇóÒ»¸öÇý¶¯ÖÁÉÙÖ§³ÖµÄThis gives applications that want wide portability a guaranteed least common denominator.±ê×¼¡£ÕâʹµÃÄÇЩÐèÒª¹ã·ºÒÆÖ²ÐԵijÌÐò»ñµÃÒ»¸ö×îСµÄ·Öĸ(Õâ¾ä»°µÄÔ­ÎÄÊÇ£º)ANSI SQL-2¡£ÎÒÃÇÏàÐÅÊÇ ×㹻ǿ´óµÄ£¬²¢ÇÒÊǵõ½×ã¹»Ö§³ÖµÄ¡£ 2. 3. JDBC

±Ø Ðë¿ÉÒÔ½¨Á¢ÔÚÏÖÓеÄÊý¾Ý¿â½Ó¿ÚÉÏ JDBC SQL API

¡¡¡¡ÎÒÃDZØÐëÄܹ»±£Ö¤ÄÜSQL API¹»½¨Á¢ÔÚÆÕͨµÄÉÏODBC£¬ÓÈÆäÊÇ¡£OUT parameterÕâЩҪÇóÒѾ­¶ÔÕâ¸ö¹æ·¶µÄһЩ²¿·Ö²úÉúÁËÓ°Ï죬ÓÈÆäÊǶԴ«³ö²ÎÊý() ºÍ´óÊý¾Ý¿éµÄ´¦Àí¡£ 2. 4.

±ØJAVAÐë±£Ö¤Õâ¸ö½Ó¿ÚÓëϵ ͳµÄÆäËû²¿·Ö±£³ÖÒ»Ö JAVA

¡¡Ä¿Ç°¶ÔµÄJava»ý¼«»ØÓ¦ÒѾ­Ê®·ÖÈÈÁÒ¡£ºÜ´ó³Ì¶ÈÉÏÊÇÓÉÓÚÕâ¸öÓïÑÔ±ê×¼ÒÔ¼°±ê×¼ÔËÐÐʱ¿â±»ÈÏΪÊÇÒ»Ö£¬¼òµ¥ºÍÇ¿´óµÄ¡£ÎÒÃǽ«¾¡ÎÒÃÇËùÄÜ£¬ÌṩÕâ¸öÊýJava¾Ý¿â½Ó¿Ú£¬Õâ¸ö½Ó¿Ú½«½¨Á¢ÔÚÄÚ ºËÏÖÓеÄÕâÖÖ·ç¸ñ£¬²¢ÇÒ½«½øÒ»²½¼ÓÇ¿Ëü¡£ 2. 5.

±£ ³Ö¼òµ¥ We would prefer to keep this base API as simple as possible

¡¡¡¡, at least initially. In general we would prefer to provide a single mechanism for performing a particular task, and avoid provid-ing duplicate mechanisms. We will extend the API later if any important functionality is miss-ing. API

¡¡¡¡ÎÒÃǽ«Á¦ÕùʹµÃ»ù±¾µÄ¾¡APIÁ¿¼òµ¥£¬ÖÁÉÙ¿ªÊ¼µÄʱºòÊÇÕâÑùµÄ¡£Ò»°ãÀ´Ëµ£¬ÎÒÃÇÏ£Íû¶ÔʵÏÖÿ¸öÌØ¶¨µÄÈÎÎñÖ»ÌṩһÖÖ·½°¸£¬¶ø±ÜÃâÌṩ¶àÖÖ·½°¸¡£Èç¹ûÒ»Ð©ÖØÒªµÄ¹¦ÄÜÒÅ©ÁË£¬ÄÇôÎÒÃÇÔÚÍíЩʱºò½«À©³äÕâ¸ö¡£ 2. 6.

¾¡ Á¿±£³ÖÇ¿µÄ¡¢¾²Ì¬µÄÀàÐÍ JDBC API

¡¡¡¡ÎÒÃÇÏ£ÍûÕâ¸ö±£ ³Ö¾¡Á¿Ç¿µÄÀàÐͼì²é£¬Ê¹µÃ¾¡¿ÉÄܶàµÄÀàÐÍÐÅÏ¢¿ÉÒÔ¾²Ì¬µØ±í´ï¡£×ÅʹµÃ¾¡¿ÉÄܶàµÄ´íÎó¿ÉÒÔÔÚ±àÒëµÄʱºò±»·¢ÏÖ¡£ SQL

¡¡¡¡ÓÉÓÚ±¾SELECTÉíÊǶ¯Ì¬ÀàÐ͵ģ¬ËùÒÔÎÒÃÇ¿ÉÄÜ»áÔÚ³ÌÐòÔËÐеÄʱºòÓöµ½ÀàÐͲ»ÄÜÆ¥ÅäµÄÎÊÌâ¡£ÀýÈ磺µ±Ò»¸ö³ÌÐòÔ±ÔÚÏ£Íû·µfoo»ØÒ»¸öÕûÊý£¬µ«ÊÇʵ¼Ê·µ»ØµÄÊÇÒ»¸ö×Ö·û´®"¡±. µ« ÊÇÎÒÃÇÒÀȻϣÍû³ÌÐòÔ±°ÑËûÃÇËùÏ£ÍûµÄÀàÐÍÔÚ±àÒëµÄʱºò¾ÍÄܹ»±í´ïÇå³þ£¬ÕâÑùÎÒÃÇ¿ÉÒÔ×ö¾¡¿ÉÄܶàµÄ¾²Ì¬¼ì²é¡£ÎÒÃÇҲϣÍûÔÚ±ØÒªµÄʱºòÄܹ»Ö§³Ö¶¯Ì¬ÀàÐͽӿڣ¨¼ûµÚËÄÕ£© 2. 7.

ÎÄÕÂÕûÀí£ºÎ÷²¿ÊýÂë--רҵÌṩÓòÃû×¢²á¡¢ÐéÄâÖ÷»ú·þÎñ
http://www.west263.com
ÒÔÉÏÐÅÏ¢ÓëÎÄÕÂÕýÎÄÊDz»¿É·Ö¸îµÄÒ»²¿·Ö,Èç¹ûÄúÒª×ªÔØ±¾ÎÄÕÂ,Çë±£ÁôÒÔÉÏÐÅÏ¢£¬Ð»Ð»!