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.±äÁ¿£º
¶ÔÓÚ»ù±¾ÀàÐ͵ÄÈ«¾Ö±äÁ¿£¬ÈôûÓгõʼ»¯£¬ÏµÍ³»á×Ô¶¯³õʼ»¯Îª¸ÃÀàÐ͵ijõʼֵ£»¶ø¶ÔÓÚ¾Ö²¿±äÁ¿£¬Ôò±ØÐëÏÔʾµÄ½øÐгõʼ»¯¡£
2.³£Á¿£º
final int M_Max=111;
final±íʾֻÄܸø±äÁ¿M_MAX¸³ÖµÒ»´Î£¬¸³ÖµÖ®ºó£¬M_MAXµÄÖµ¾Í²»¿ÉÒÔÖØÐ¸³Öµ¡£Ëù¸³µÄÖµ¿ÉÒÔÊÇÒ»¸ö±í´ïʽ£¬Ò²¿ÉÒÔÊÇÒ»¸ö¾ßÌåµÄÖµ¡£
3.Àà³£Á¿£º
static fina ......
ÔÚ¿Í»§/·þÎñÆ÷ͨÐÅģʽÖУ¬¿Í»§¶ËÖ÷¶¯´´½¨Óë·þÎñÆ÷Á¬½ÓµÄSocket£¬·þÎñÆ÷ÊÕµ½¿Í»§¶ËµÄÁ¬½ÓÇëÇó£¬Ò²´´½¨ÁËÓë¿Í»§¶ËÁ¬½ÓµÄSocket¡£
¿Í»§¶ËÖ÷¶¯´´½¨Socketʱºò£¬ÐèÒª×öÏÂÃæÒ»Ð©ÊÂÇ飺
1. ¹¹ÔìSocket.
2. É趨µÈ´ý½¨Á¢Á¬½ÓµÄ³¬Ê±Ê±¼ä
&nb ......
Ê×ÏȽéÉÜһϻ·¾³±äÁ¿µÄÉèÖ÷½·¨£º
£¨ÕâÀïÒÔjdk1.5À´°²×°£¬ÆäËû°æ±¾Ò»Ñù£©
ÔÚ°Ñjdk1.5°²×°µ½¼ÆËã»úÖÐÖ®ºó£¬ÎÒÃÇÀ´½øÐÐÉèÖÃʹjava»·¾³Äܹ»Ê¹Óá£
Ê×ÏÈÓÒ¼üµãÎҵĵçÄÔ¡£´ò¿ªÊôÐÔ¡£È»ºóÑ¡Ôñ“¸ß¼¶”ÀïÃæµÄ“»·¾³±äÁ¿”£¬ÔÚеĴò¿ª½çÃæÖеÄϵͳ±äÁ¿Ð ......
ÀûÓÃoracle×Ô´øµÄutl_file°ü¿ÉÒÔ·ÃÎÊ´ÅÅÌÎļþ£¬µ«ÓиöÏÞÖÆ--ÎÞ·¨·ÃÎÊÎļþ¼Ð£¿Ê²Ã´ÒâË¼ÄØ£¿¾ÍÊÇ˵oracleÖ»ÄÜ·ÃÎÊÖ¸¶¨µÄÎļþ£¬¶ø²»ÄÜ·ÃÎÊÎļþ¼ÐϵÄδ֪Îļþ¡£ËùÒÔ£¬Èç¹ûҪͨ¹ýoracleÈ¥±éÀúijָ¶¨Â·¾¶ÏµÄËùÓÐÎļþ£¬sorry, impossible! µ«ÊÇ£¬ÓÐÒ»ÖÖÌæ´ú·½°¸¿ÉÒÔÖúÄãÒ»±ÛÖ®Á¦£¡
ÖÚËùÖÜÖªjavaÖ®FileÀàÖ¸ÏòµÄ¿ÉÒÔÊÇĿ¼Ҳ¿ÉÒÔÊ ......