Çá±ãµÄÊý¾Ý´«Ê䷽ʽһֱÊÇÃæÏò·þÎñ¹¹¼Ü£¨SOA£©Ëù¹Ø×¢µÄ½¹µã£¬¶ÔÓÚSOAÀ´Ëµ£¬Ôø¾·¢Õ¹³öÁ˺ܶ෽±ãµÄÊý¾Ý´«Êäģʽ¡£µ«×Ô´ÓXMLÁ÷Ðкó£¬ÕâЩ´«Êäģʽ¶¼Öð½¥ÏûʧÁË£¬Òò´Ë£¬ÏÖÔÚµÄSOAÖеĻù±¾µÄÊý¾Ý´«Êäģʽ¶¼ÊÇ»ùÓÚXMLµÄ¡£ËäÈ»XML¿ÉÒÔÓÃÓÚÏó·þÎñ·¢ËÍÇëÇó¡¢´Ó·þÎñÆ÷»ñµÃÏìÓ¦»ò´«µÝÊý¾Ý±íÖ®ÀàµÄ²Ù×÷£¬µ«ÕâЩ²Ù×÷¶¼Ì«¼òµ¥£¬¶øÓÐʱÎÒÃÇÐèÒª¶ÔXMLÊý¾Ý½øÐи´ÔӵIJÙ×÷£¬Èç¹ûÒªÏóSQL²éѯÊý¾Ý±íÒ»ÑùÀ´²éѯXMLÊý¾Ý¡£Õâ¾ÍÒªÓõ½±¾ÎÄËùÌÖÂÛµÄXQuery¼¼Êõ¡£
±¾ÎÄÖ÷ÒªÌÖÂÛXQueryÒÔ¼°Ïà¹ØµÄÆäËû¼¼Êõ£¬ÈçXQJ£¨»ùÓÚXQueryµÄJava API£©¡£±¾ÎÄÊ×ÏȽéÉÜÁËʲôÊÇXQueryºÍXQJ£¬²¢Ê¹¶ÁÕß¿ÉÒÔÁ˽âʹÓÃÕâЩ¼¼ÊõµÄ»ù±¾·½·¨¡£È»ºóͨ¹ý¾ßÌåµÄʵÀýÀ´Ê¹¶ÁÕßÕæÕýÕÆÎÕXQueryºÍXQJ¼¼Êõ¡£
Ò»¡¢Ê²Ã´ÊÇXQuery
XQueryÊÇÒ»ÖÖ²éѯXMLÊý¾ÝµÄ¼¼Êõ¡£¾ÍÏóÓÃSQLÀ´²éѯ¹ØÏµÊý¾ÝÒ»Ñù¡£ÔÚ¼¸Äêǰ£¬W3C²éѯÓïÑÔ¹¤×÷×鿪·¢³öÁËXQuery1.0¡£ÔÚÒÔǰÎÒÃÇÏë²Ù×÷XMLÊý¾Ý±ØÐëÒªÕÆÎÕSAX»òDOMÖеÄÒ»ÖÖ£¬¶øÔÚ±¾ÎÄÖÐÎÒÃǽ«ÓÐÐÒÁ˽⵽¸üÈÝÒ×ʹÓõÄXQJ¼¼Êõ¡£XQJ¸ü·ûºÏXQuery¹æ·¶£¬ÔÚXQJÓïÑÔÖУ¬ÎÒÃǽ«¶¨ÒåºÜ¶à½Ó¿ÚºÍÀ࣬¶øÌá½»XQJ²éѯºÍ»ñµÃ²éѯ½á¹ûµÄÈÎÎñ¾ÍÊÇÓÉÕâЩÀàÍê³ÉµÄ¡£Í¬Ê±£¬XQJ»¹Ö§³Ö×îеÄXPath2.0¼¼Êõ¡£ÓÉÓÚXQueryÊÇΪ²éѯXMLµÄרÓÃÓïÑ ......
XML Êý¾Ý¸ñʽºÜÄÑËÑË÷£¬µ«ÊÇ×î½üËæ×Å XQuery API µÄ³öÏÖ£¬XML ËÑË÷±äµÃ·Ç³£Áé»îºÍ¼òµ¥¡£¶ÔÓÚʹÓà SAX¡¢DOM¡¢JDOM¡¢JAXP µÈ´¦Àí XML ÎĵµµÄ Java™ ³ÌÐòÔ±À´Ëµ£¬¹¤¾ßÏäÖÐÔö¼Ó XQuery API for Java ÊÇÒ»¼þÖµµÃ¸ßÐ˵ÄÊ¡£ÏÖÔÚ Java ³ÌÐòÔ±²»ÓÃÔÙÇóÖúÓÚϵͳµ÷ÓûòÕß±¿×¾µÄ API ¾ÍÄÜÀûÓà XQuery µÄÇ¿´ó¹¦ÄÜÁË£¬Sun ÌṩÁËÒ»Ì×ÍêÕûµÄ¡¢±ê×¼»¯µÄ°ü¡£
SQL Êý¾Ý¿â¡¢XML Êý¾ÝºÍ²éѯ
ËäÈ»±à³ÌÁìÓò — ÌØ±ðÊÇ Java ±à³Ì — ²»¶Ï·¢Õ¹£¬¿É¹©Ñ¡ÔñµÄ±ê×¼µÄÊýÁ¿Ò²ÔÚÔö³¤¡£»»¾ä»°Ëµ£¬Ô½À´Ô½¶àµÄ API µÃµ½ Sun µÄÈϿɻòÕßÅú×¼¡£±ê×¼»¯µÄ½á¹ûÊÇÔ½À´Ô½¶àµÄ¿ª·¢Õß±³ÆúÁË×Ô¼º×î¾ß¾ºÕùÁ¦µÄ¼¼Êõ£¬¶øÈ¥Ñ§Ï°Ð¼¼Êõ¡£
ÒªÕÆÎÕµÄ×îÓÐÎüÒýÁ¦ºÍ¼ÛÖµµÄÊÇÄÇЩºÍÊý¾Ý´¦ÀíÓйصŤ¾ßºÍ API¡£ÎÞÂÛÓ¦ÓóÌÐò¶àô¿á»òÕßÖÇÄÜ£¬Ëµµ½µ×Ö»ÓÐÄܹ»´¦ÀíÊý¾Ý²ÅÓÐÓá£Í¬Ê±£¬ËäÈ» API ÊýÁ¿µÄ²»¶ÏÔö³¤£¬µ«Á÷ÐкÍͨÓõÄÊý¾Ý¸ñʽÊýÁ¿È´²»¶Ï¼õÉÙ¡£ËäÈ»ÓÐЩÊý¾Ý¹ÜÀíÔ±ÈÔȻʹÓÃÃæÏò¶ÔÏóµÄÊý¾Ý¿â¹ÜÀíϵͳ»òÕß XML Çý¶¯µÄÊý¾Ý¿â£¬µ«¹ØÏµÊý¾Ý¿â£¨RDBMS£©ÒѳÉΪÖ÷Á÷£¬¶øÇÒÈÔÈ»ÊǴ󲿷ÖÊý¾Ý¹ÜÀíÔ±µÄÑ¡Ôñ¡£Òò´Ë Java ¿ª·¢ÈËÔ±±ØÐëͨ¹ý JDBC£¨Êý¾Ý¿âÁ¬½Ó£©»òÕß JDO (Java Data Objects) Óë SQL Êý¾Ý¿â½»»¥¡£
SQL Êý¾Ý¿âÓëÆä ......
¼¯ºÏÀà˵Ã÷¼°Çø±ð
Collection
©ÀList
©¦©ÀLinkedList
©¦©ÀArrayList
©¦©¸Vector
©¦¡¡©¸Stack
©¸Set
Map
©ÀHashtable
©ÀHashMap
©¸WeakHashMap
Collection½Ó¿Ú
¡¡¡¡CollectionÊÇ×î»ù±¾µÄ¼¯ºÏ½Ó¿Ú£¬Ò»¸öCollection´ú±íÒ»×éObject£¬¼´CollectionµÄÔªËØ£¨Elements£©¡£Ò»Ð©
CollectionÔÊÐíÏàͬµÄÔªËØ¶øÁíһЩ²»ÐС£Ò»Ð©ÄÜÅÅÐò¶øÁíһЩ²»ÐС£Java SDK²»Ìṩֱ½Ó¼Ì³Ð×ÔCollectionµÄÀ࣬Java
SDKÌṩµÄÀà¶¼ÊǼ̳Ð×ÔCollectionµÄ“×Ó½Ó¿Ú”ÈçListºÍSet¡£
¡¡¡¡ËùÓÐʵÏÖCollection½Ó¿ÚµÄÀà¶¼±ØÐëÌṩÁ½¸ö±ê×¼µÄ¹¹Ô캯Êý£ºÎÞ²ÎÊýµÄ¹¹Ô캯ÊýÓÃÓÚ´´½¨Ò»¸ö¿ÕµÄCollection£¬ÓÐÒ»¸ö
Collection²ÎÊýµÄ¹¹Ô캯ÊýÓÃÓÚ´´½¨Ò»¸öеÄCollection£¬Õâ¸öеÄCollectionÓë´«ÈëµÄCollectionÓÐÏàͬµÄÔªËØ¡£ºó
Ò»¸ö¹¹Ô캯ÊýÔÊÐíÓû§¸´ÖÆÒ»¸öCollection¡£
¡¡¡¡ÈçºÎ±éÀúCollectionÖеÄÿһ¸öÔªËØ£¿²»ÂÛCollectionµÄʵ¼ÊÀàÐÍÈçºÎ£¬Ëü¶¼Ö§³ÖÒ»¸öiterator()µÄ·½·¨£¬¸Ã·½·¨·µ»ØÒ»¸öµü
´ú×Ó£¬Ê¹Óøõü´ú×Ó¼´¿ÉÖðÒ»·ÃÎÊCollectionÖÐÿһ¸öÔªËØ¡£µäÐ͵ÄÓ÷¨ÈçÏ£º
¡¡¡¡¡¡¡¡Iterator it = collection.iterator(); // »ñµÃÒ»¸öµü´ú×Ó
¡¡¡¡¡¡¡¡while(it.hasNext()) {
¡¡¡¡¡¡¡¡¡¡¡¡Object ......
ÓÃjavaµ÷ÓÃoracle´æ´¢¹ý³Ì×ܽá
1¡¢Ê²Ã´ÊÇ´æ´¢¹ý³Ì¡£´æ´¢¹ý³ÌÊÇÊý¾Ý¿â·þÎñÆ÷¶ËµÄÒ»¶Î³ÌÐò£¬ËüÓÐÁ½ÖÖÀàÐÍ¡£Ò»ÖÖÀàËÆÓÚSELECT²éѯ£¬ÓÃÓÚ¼ìË÷Êý¾Ý£¬¼ìË÷µ½µÄÊý¾ÝÄܹ»ÒÔÊý¾Ý¼¯µÄÐÎʽ·µ»Ø¸ø¿Í»§¡£ÁíÒ»ÖÖÀàËÆÓÚINSERT»òDELETE²éѯ£¬Ëü²»·µ»ØÊý¾Ý£¬Ö»ÊÇÖ´ÐÐÒ»¸ö¶¯×÷¡£ÓеķþÎñÆ÷ÔÊÐíͬһ¸ö´æ´¢¹ý³Ì¼È¿ÉÒÔ·µ»ØÊý¾ÝÓÖ¿ÉÒÔÖ´Ðж¯×÷¡£
2¡¢Ê²Ã´Ê±ºòÐèÒªÓô洢¹ý³Ì
¡¡¡¡Èç¹û·þÎñÆ÷¶¨ÒåÁË´æ´¢¹ý³Ì£¬Ó¦µ±¸ù¾ÝÐèÒª¾ö¶¨ÊÇ·ñÒªÓô洢¹ý³Ì¡£´æ´¢¹ý³Ìͨ³£ÊÇһЩ¾³£ÒªÖ´ÐеÄÈÎÎñ£¬ÕâЩÈÎÎñÍùÍùÊÇÕë¶Ô´óÁ¿µÄ¼Ç¼¶ø½øÐеġ£ÔÚ·þÎñÆ÷ÉÏÖ´Ðд洢¹ý³Ì£¬¿ÉÒÔ¸ÄÉÆÓ¦ÓóÌÐòµÄÐÔÄÜ¡£ÕâÊÇÒòΪ£º
.·þÎñÆ÷ÍùÍù¾ßÓÐÇ¿´óµÄ¼ÆËãÄÜÁ¦ºÍËÙ¶È¡£
.±ÜÃâ°Ñ´óÁ¿µÄÊý¾ÝÏÂÔØµ½¿Í»§¶Ë£¬¼õÉÙÍøÂçÉϵĴ«ÊäÁ¿¡£
¡¡¡¡ÀýÈ磬¼ÙÉèÒ»¸öÓ¦ÓóÌÐòÐèÒª¼ÆËãÒ»¸öÊý¾Ý£¬Õâ¸öÊý¾ÝÐè񻃾¼°µ½Ðí¶à¼Ç¼¡£Èç¹û²»Ê¹Óô洢¹ý³ÌµÄ»°£¬°ÑÕâЩÊý¾ÝÏÂÔØµ½¿Í»§¶Ë£¬µ¼ÖÂÍøÂçÉϵÄÁ÷Á¿¾çÔö¡£
¡¡¡¡²»½öÈç´Ë£¬¿Í»§¶Ë¿ÉÄÜÊÇһ̨ÀϵôÑÀµÄ¼ÆËã»ú£¬ËüµÄÔËËãËٶȺÜÂý¡£¶ø¸ÄÓô洢¹ý³Ìºó£¬·þÎñÆ÷»áºÜ¿ìµØ°ÑÊý¾Ý¼ÆËã³öÀ´£¬²¢ÇÒÖ»Ðè´«µÝÒ»¸öÊý¾Ý¸ø¿Í»§¶Ë£¬ÆäЧÂÊÖ®¸ßÊǷdz£Ã÷ÏԵġ£
3¡¢´æ´¢¹ý³ÌµÄ²ÎÊý
¡¡¡¡ÒªÖ´ÐзþÎñÆ÷ÉϵĴ洢¹ý³Ì£¬ÍùÍùÒª´«µÝһЩ²ÎÊý¡£Õ ......
ÓÃjavaµ÷ÓÃoracle´æ´¢¹ý³Ì×ܽá
1¡¢Ê²Ã´ÊÇ´æ´¢¹ý³Ì¡£´æ´¢¹ý³ÌÊÇÊý¾Ý¿â·þÎñÆ÷¶ËµÄÒ»¶Î³ÌÐò£¬ËüÓÐÁ½ÖÖÀàÐÍ¡£Ò»ÖÖÀàËÆÓÚSELECT²éѯ£¬ÓÃÓÚ¼ìË÷Êý¾Ý£¬¼ìË÷µ½µÄÊý¾ÝÄܹ»ÒÔÊý¾Ý¼¯µÄÐÎʽ·µ»Ø¸ø¿Í»§¡£ÁíÒ»ÖÖÀàËÆÓÚINSERT»òDELETE²éѯ£¬Ëü²»·µ»ØÊý¾Ý£¬Ö»ÊÇÖ´ÐÐÒ»¸ö¶¯×÷¡£ÓеķþÎñÆ÷ÔÊÐíͬһ¸ö´æ´¢¹ý³Ì¼È¿ÉÒÔ·µ»ØÊý¾ÝÓÖ¿ÉÒÔÖ´Ðж¯×÷¡£
2¡¢Ê²Ã´Ê±ºòÐèÒªÓô洢¹ý³Ì
¡¡¡¡Èç¹û·þÎñÆ÷¶¨ÒåÁË´æ´¢¹ý³Ì£¬Ó¦µ±¸ù¾ÝÐèÒª¾ö¶¨ÊÇ·ñÒªÓô洢¹ý³Ì¡£´æ´¢¹ý³Ìͨ³£ÊÇһЩ¾³£ÒªÖ´ÐеÄÈÎÎñ£¬ÕâЩÈÎÎñÍùÍùÊÇÕë¶Ô´óÁ¿µÄ¼Ç¼¶ø½øÐеġ£ÔÚ·þÎñÆ÷ÉÏÖ´Ðд洢¹ý³Ì£¬¿ÉÒÔ¸ÄÉÆÓ¦ÓóÌÐòµÄÐÔÄÜ¡£ÕâÊÇÒòΪ£º
.·þÎñÆ÷ÍùÍù¾ßÓÐÇ¿´óµÄ¼ÆËãÄÜÁ¦ºÍËÙ¶È¡£
.±ÜÃâ°Ñ´óÁ¿µÄÊý¾ÝÏÂÔØµ½¿Í»§¶Ë£¬¼õÉÙÍøÂçÉϵĴ«ÊäÁ¿¡£
¡¡¡¡ÀýÈ磬¼ÙÉèÒ»¸öÓ¦ÓóÌÐòÐèÒª¼ÆËãÒ»¸öÊý¾Ý£¬Õâ¸öÊý¾ÝÐè񻃾¼°µ½Ðí¶à¼Ç¼¡£Èç¹û²»Ê¹Óô洢¹ý³ÌµÄ»°£¬°ÑÕâЩÊý¾ÝÏÂÔØµ½¿Í»§¶Ë£¬µ¼ÖÂÍøÂçÉϵÄÁ÷Á¿¾çÔö¡£
¡¡¡¡²»½öÈç´Ë£¬¿Í»§¶Ë¿ÉÄÜÊÇһ̨ÀϵôÑÀµÄ¼ÆËã»ú£¬ËüµÄÔËËãËٶȺÜÂý¡£¶ø¸ÄÓô洢¹ý³Ìºó£¬·þÎñÆ÷»áºÜ¿ìµØ°ÑÊý¾Ý¼ÆËã³öÀ´£¬²¢ÇÒÖ»Ðè´«µÝÒ»¸öÊý¾Ý¸ø¿Í»§¶Ë£¬ÆäЧÂÊÖ®¸ßÊǷdz£Ã÷ÏԵġ£
3¡¢´æ´¢¹ý³ÌµÄ²ÎÊý
¡¡¡¡ÒªÖ´ÐзþÎñÆ÷ÉϵĴ洢¹ý³Ì£¬ÍùÍùÒª´«µÝһЩ²ÎÊý¡£Õ ......
sqlserverÊý¾Ý¿â£ºjavaÁ¬½Ósqlserver2005Êý¾Ý¿âÐĵÃÌå»á
Ê×ÏȵÃÏÂÔØÇý¶¯³ÌÐòµ½Î¢ÈíÍøÕ¾ÏÂÔØMicrosoft SQL Server 2005 JDBC Driver 1.2¡¡¡¡½âѹMicrosoft SQL Server 2005 jdbc driver1.2.exe
µÃµ½sqljdbc.jar£¬ÓõÃʱºòÖ±½Ó¼Óµ½classpathÖÐÈ¥.
¡¡ÉèÖÃSQL Server·þÎñÆ÷
·ÀÖ¹³öÏÖ
com.microsoft.sqlserver.jdbc.SQLServerException: µ½Ö÷»ú µÄ TCP/IP Á¬½Óʧ°Ü¡£ java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makefromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Dao.GetConnection.getCon(GetConnection.java:1 ......
sqlserverÊý¾Ý¿â£ºjavaÁ¬½Ósqlserver2005Êý¾Ý¿âÐĵÃÌå»á
Ê×ÏȵÃÏÂÔØÇý¶¯³ÌÐòµ½Î¢ÈíÍøÕ¾ÏÂÔØMicrosoft SQL Server 2005 JDBC Driver 1.2¡¡¡¡½âѹMicrosoft SQL Server 2005 jdbc driver1.2.exe
µÃµ½sqljdbc.jar£¬ÓõÃʱºòÖ±½Ó¼Óµ½classpathÖÐÈ¥.
¡¡ÉèÖÃSQL Server·þÎñÆ÷
·ÀÖ¹³öÏÖ
com.microsoft.sqlserver.jdbc.SQLServerException: µ½Ö÷»ú µÄ TCP/IP Á¬½Óʧ°Ü¡£ java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makefromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Dao.GetConnection.getCon(GetConnection.java:1 ......
Õ»Óë¶Ñ¶¼ÊÇJavaÓÃÀ´ÔÚRamÖдæ·ÅÊý¾ÝµÄµØ·½¡£ÓëC++²»Í¬£¬Java×Ô¶¯¹ÜÀíÕ»ºÍ¶Ñ£¬³ÌÐòÔ±²»ÄÜÖ±½ÓµØÉèÖÃÕ»»ò¶Ñ¡£
JavaµÄ¶ÑÊÇÒ»¸öÔËÐÐʱÊý¾ÝÇø,ÀàµÄ¶ÔÏó´ÓÖзÖÅä¿Õ¼ä¡£ÕâЩ¶ÔÏóͨ¹ýnew¡¢newarray¡¢anewarrayºÍmultianewarrayµÈÖ¸ÁÁ¢£¬ËüÃDz»ÐèÒª³ÌÐò´úÂëÀ´ÏÔʽµÄÊÍ·Å¡£
¶Ñ(heap)ÊÇÓÉÀ¬»ø»ØÊÕÀ´¸ºÔðµÄ£¬¶ÑµÄÓÅÊÆÊÇ¿ÉÒÔ¶¯Ì¬µØ·ÖÅäÄÚ´æ´óС£¬Éú´æÆÚÒ²²»±ØÊÂÏȸæËß±àÒëÆ÷£¬ÒòΪËüÊÇÔÚÔËÐÐʱ¶¯Ì¬·ÖÅäÄÚ´æµÄ£¬JavaµÄÀ¬»øÊÕ¼¯Æ÷»á×Ô¶¯ÊÕ×ßÕâЩ²»ÔÙʹÓõÄÊý¾Ý¡£µ«È±µãÊÇ£¬ÓÉÓÚÒªÔÚÔËÐÐʱ¶¯Ì¬·ÖÅäÄڴ棬´æÈ¡ËٶȽÏÂý¡£
Õ»(stack)µÄÓÅÊÆÊÇ£¬´æÈ¡ËٶȱȶÑÒª¿ì£¬½ö´ÎÓڼĴæÆ÷£¬Õ»Êý¾Ý¿ÉÒÔ¹²Ïí¡£µ«È±µãÊÇ£¬´æÔÚÕ»ÖеÄÊý¾Ý´óСÓëÉú´æÆÚ±ØÐëÊÇÈ·¶¨µÄ£¬È±·¦Áé»îÐÔ¡£Õ»ÖÐÖ÷Òª´æ·ÅһЩ»ù±¾ÀàÐ͵ıäÁ¿(int, short, long, byte, float, double, boolean, char)ºÍ¶ÔÏó¾ä±ú¡£
Õ»ÓÐÒ»¸öºÜÖØÒªµÄÌØÊâÐÔ£¬¾ÍÊÇ´æÔÚÕ»ÖеÄÊý¾Ý¿ÉÒÔ¹²Ïí¡£¼ÙÉèÎÒÃÇͬʱ¶¨Ò壺
int a = 3;
int b = 3;
±àÒëÆ÷ÏÈ´¦Àíint a = 3;Ê×ÏÈËü»áÔÚÕ»Öд´½¨Ò»¸ö±äÁ¿ÎªaµÄÒýÓã¬È»ºó²éÕÒ ......