¡¡¡¡Ðí¶à¿ª·¢ÕߺÍÓû§¶¼ÔÚѰÕÒ³Ì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»¿É·Ö¸îµÄÒ»²¿·Ö,Èç¹ûÄúÒª×ªÔØ±¾ÎÄÕÂ,Çë±£ÁôÒÔÉÏÐÅÏ¢£¬Ð»Ð»!



