java jdbc
JDBC£º
|-- Êý¾Ý¿â»¥Áª¡£
|-- ÓÉSUN¹«Ë¾ËùÖÆ¶¨µÄÓÃÀ´·ÃÎÊÊý¾Ý¿âµÄ¹æ·¶¡£
|-- Êý¾Ý¿âÊý¾Ý <= ½»»¥ => Ó¦ÓóÌÐò¡£
JDBC°üº¬Ö÷ÒªÁ½¸ö²¿·Ö£º
|-- part 1.ÓÉSUN¹«Ë¾Öƶ¨µÄ¹æ·¶½Ó¿Ú
|-- java.sql
--> ºËÐİü
|-- javax.sql --> À©Õ¹°ü
|-- part 2.ÓÉÊý¾Ý¿â³§ÉÌËùÌṩµÄÊý¾Ý¿âÇý¶¯³ÌÐò£¬ËüÃÇʵÏÖÁËpart 1²¿·Ö¡£
JDBCµÄÇý¶¯³ÌÐò°üº¬ÒÔÏÂËÄÖÖÀàÐÍ£º
|-- µÚÒ»´úÇý¶¯£¨JDBC - ODBC Bridge£©
|-- Ê×ÏȰÑJDBCµÄµ÷ÓÃת»»³ÉODBCµÄµ÷Óã¬ÔÙÓÃODBCÓë¾ßÌåµÄÊý¾Ý¿âϵͳͨÐÅ¡£
|-- µÚ¶þ´úÇý¶¯ £¨Native - API party - Java
driver ±¾µØAPI²¿·ÖJavaÇý¶¯£©
|-- Conrerts JDBC calls into calls
on the native client API of a specific RODMS.
|-- ȱµã£º²»Í¬µÄÊý¾Ý¿âÐèÒª°²×°²»Í¬µÄ¿Í»§¶Ë£¨Ã¿Ì¨µçÄÔ¶¼Òª×°£©¡£
|-- µÚÈý´úÇý¶¯ £¨JDBC - net pure Java driver
ÍøÂç´¿JavaÇý¶¯£©
|-- Ìá¹©ÍøÂç½Úµã£¬Í¨¹ýÍøÂç½Úµã·ÃÎÊÊý¾Ý¿â¡£
|-- Translates JDBC calls into a
DBMS independent net protocol, which is then translated
to
a DBMS protocol by a server.
|-- µÚËÄ´úÇý¶¯ £¨Native protocol pure Java
driver ±¾µØÐÒé´¿JavaÇý¶¯£©
|-- Conrerts JDBC calls directly
into the network protocol used by DBMS.
JDBCºËÐÄAPI
java.sql
|-- Driver [Interface] ËùÓÐÇý¶¯±ØÐèʵÏֵĽӿÚ
|-- DriverManager [Class] ÓÃÀ´¹ÜÀíÒ»×éÊý¾Ý¿âµÄÇý¶¯
|-- Connection  
Ïà¹ØÎĵµ£º
1 Áо٠10¸öjavaÓïÑÔµÄÓÅÊÆ
Ãâ·Ñ£¬¿ªÔ´£¬¿çƽ̨£¬¼òµ¥Ò×Ó㬹¦ÄÜÍêÉÆ£¬ÃæÏò¶ÔÏ󣬽¡×³ÐÔ£¬¶àỊ̈߳¬½á¹¹ÖÐÁ¢£¬
ÆóÒµÓ¦ÓõijÉÊìÆ½Ì¨£¬ÎÞÏßÓ¦Óá£
2 ÁоÙjavaÖÐ 10¸öÃæÏò¶ÔÏó±à³ÌµÄÊõÓï
°ü£¬À࣬ʵÀý£¬·â×°£¬¼Ì³Ð£¬¶à̬£¬ÖØÔØ£¬ÖØÐ´£¬¶Ô ......
1£©DOM£¨JAXP Crimson½âÎöÆ÷£©
DOMÊÇÓÃÓëÆ½Ì¨ºÍÓïÑÔÎ޹صķ½Ê½±íʾXMLÎĵµµÄ¹Ù·½W3C±ê×¼¡£DOMÊÇÒÔ²ã´Î½á¹¹×éÖ¯µÄ½Úµã»òÐÅϢƬ¶ÏµÄ¼¯ºÏ¡£Õâ¸ö²ã´Î½á¹¹ÔÊÐí¿ª·¢ÈËÔ±ÔÚÊ÷ÖÐѰÕÒÌØ¶¨ÐÅÏ¢¡£·ÖÎö¸Ã½á¹¹Í¨³£ÐèÒª¼ÓÔØÕû¸öÎĵµºÍ¹¹Ôì²ã´Î½á¹¹£¬È»ºó²ÅÄÜ×öÈκι¤×÷¡£ÓÉÓÚËüÊÇ»ùÓÚÐÅÏ¢²ã´ÎµÄ£¬Òò¶øDO ......
ÿ¸öJava³õѧÕß¶¼Ó¦¸ÃÃ÷°×µÄÎÊÌâ
¶ÔÓÚÕâ¸öϵÁÐÀïµÄÎÊÌ⣬ÿ¸öѧJavaµÄÈ˶¼Ó¦¸Ã¸ã¶®¡£µ±È»£¬Èç¹ûÖ»ÊÇѧJavaÍæÍæ¾ÍÎÞËùνÁË¡£Èç¹ûÄãÈÏΪ×Ô¼ºÒѾ³¬Ô½³õѧÕßÁË£¬È´²»ºÜ¶®ÕâЩÎÊÌ⣬Ç뽫Äã×Ô¼ºÖعé³õѧÕßÐÐÁС£ÄÚÈݾùÀ´×ÔÓÚCSDNµÄ¾µäÀÏÌù¡£
¡¡¡¡ÎÊÌâÒ»£ºÎÒÉùÃ÷ÁËʲô£¡
String s = "Hello world!";
¡¡¡¡Ðí¶àÈ˶¼×ö¹ýÕâÑùµÄ ......
±¾ÎĽéÉܵÄJAVA¹æÔòµÄ˵Ã÷·ÖΪ3¸öÖ÷Òª¼¶±ð£¬Öм¶ÊÇÆ½Ê±¿ª·¢ÓõıȽ϶àµÄ¼¶±ð£¬ÔÚ½ñºó½«Â½ÐøÐ´³öÆäËûµÄ¹æÔò¡£×ñÊØÁËÕâЩ¹æÔò¿ÉÒÔÌá¸ß³ÌÐòµÄЧÂÊ¡¢Ê¹´úÂëÓÖ¸üºÃµÄ¿É¶ÁÐԵȡ£
£¨1£© ÔÚfinally·½·¨Àï¹Øµôinput»òÕßoutput ×ÊÔ´
ÔÙ·½·¨ÌåÀïÃæ¶¨ÒåÁËinput»òÕßoutputÁ÷µÄ»°£¬ÐèÒªÔÚfinallyÀïÃæ°ÑËü¹Øµô¡£
ÒÔÏÂ ......
ÀûÓÃoracle×Ô´øµÄutl_file°ü¿ÉÒÔ·ÃÎÊ´ÅÅÌÎļþ£¬µ«ÓиöÏÞÖÆ--ÎÞ·¨·ÃÎÊÎļþ¼Ð£¿Ê²Ã´ÒâË¼ÄØ£¿¾ÍÊÇ˵oracleÖ»ÄÜ·ÃÎÊÖ¸¶¨µÄÎļþ£¬¶ø²»ÄÜ·ÃÎÊÎļþ¼ÐϵÄδ֪Îļþ¡£ËùÒÔ£¬Èç¹ûҪͨ¹ýoracleÈ¥±éÀúijָ¶¨Â·¾¶ÏµÄËùÓÐÎļþ£¬sorry, impossible! µ«ÊÇ£¬ÓÐÒ»ÖÖÌæ´ú·½°¸¿ÉÒÔÖúÄãÒ»±ÛÖ®Á¦£¡
ÖÚËùÖÜÖªjavaÖ®FileÀàÖ¸ÏòµÄ¿ÉÒÔÊÇĿ¼Ҳ¿ÉÒÔÊ ......