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  
Ïà¹ØÎĵµ£º
ÔÚ¿Í»§/·þÎñÆ÷ͨÐÅģʽÖУ¬¿Í»§¶ËÖ÷¶¯´´½¨Óë·þÎñÆ÷Á¬½ÓµÄSocket£¬·þÎñÆ÷ÊÕµ½¿Í»§¶ËµÄÁ¬½ÓÇëÇó£¬Ò²´´½¨ÁËÓë¿Í»§¶ËÁ¬½ÓµÄSocket¡£
¿Í»§¶ËÖ÷¶¯´´½¨Socketʱºò£¬ÐèÒª×öÏÂÃæÒ»Ð©ÊÂÇ飺
1. ¹¹ÔìSocket.
2. É趨µÈ´ý½¨Á¢Á¬½ÓµÄ³¬Ê±Ê±¼ä
&nb ......
Ê×ÏȽéÉÜһϻ·¾³±äÁ¿µÄÉèÖ÷½·¨£º
£¨ÕâÀïÒÔjdk1.5À´°²×°£¬ÆäËû°æ±¾Ò»Ñù£©
ÔÚ°Ñjdk1.5°²×°µ½¼ÆËã»úÖÐÖ®ºó£¬ÎÒÃÇÀ´½øÐÐÉèÖÃʹjava»·¾³Äܹ»Ê¹Óá£
Ê×ÏÈÓÒ¼üµãÎҵĵçÄÔ¡£´ò¿ªÊôÐÔ¡£È»ºóÑ¡Ôñ“¸ß¼¶”ÀïÃæµÄ“»·¾³±äÁ¿”£¬ÔÚеĴò¿ª½çÃæÖеÄϵͳ±äÁ¿Ð ......
½ñÌì¿´µ½Ä³ÍøÓѹØÓÚ“ÈçºÎÒÔJavaʵÏÖÍøÒ³½ØÍ¼¼¼Êõ”µÄ×ÉѯÌû£¬ÓÉÓÚ³öÏÖ¸Ã×ÉѯµÄµØµã·Ç³£²»ÊʺϽϳ¤»Ø¸´£¬¹ÊÒÔ²©ÎÄÐÎʽ»Ø´ð¡£
ÊÂʵÉÏ£¬Èç¹ûÄúÏëÒÔJavaʵÏÖÍøÒ³½ØÍ¼£¬Ò²¾ÍÊÇ“ÊäÈëÒ»¶ÎÍøÖ·£¬¼¸ÃëÖÓ¹ýºó¾ÍÄܽØÈ¡Ò»ÕÅÍøÒ³ËõÂÔͼ”µÄЧ¹û¡£ÄÇô£¬ÄúÖÁÉÙÓÐ3ÖÖ·½Ê½¿ÉÒÔÑ¡Ôñ¡£
1¡¢×îÖ±½ÓµÄ·½Ê½—— ......
EclipseÖÐĬÈÏÊÇÊäÈë"."ºó³öÏÖ×Ô¶¯Ìáʾ£¬ÓÃÓÚÀà³ÉÔ±µÄ×Ô¶¯Ìáʾ£¬¿ÉÊÇÓÐʱºòÎÒÃÇÏ£ÍûËüÄÜÔÚÎÒÃÇÊäÈëÀàµÄÊ××Öĸºó¾Í³öÏÖ×Ô¶¯Ìáʾ£¬¿ÉÒÔ½ÚÊ¡´óÁ¿µÄÊäÈëʱ¼ä£¨ËäÈ»°´alt + /»á³öÏÖÌáʾ£¬µ«»¹ÊÇÒª¶à°´Ò»´Î°´¼ü£¬Ì«Âé·³ÁË£©¡£
´ÓWindow -> preferences -> Java -> Editor -> Content assist - ......
ÿ¸öJava³õѧÕß¶¼Ó¦¸ÃÃ÷°×µÄÎÊÌâ
¶ÔÓÚÕâ¸öϵÁÐÀïµÄÎÊÌ⣬ÿ¸öѧJavaµÄÈ˶¼Ó¦¸Ã¸ã¶®¡£µ±È»£¬Èç¹ûÖ»ÊÇѧJavaÍæÍæ¾ÍÎÞËùνÁË¡£Èç¹ûÄãÈÏΪ×Ô¼ºÒѾ³¬Ô½³õѧÕßÁË£¬È´²»ºÜ¶®ÕâЩÎÊÌ⣬Ç뽫Äã×Ô¼ºÖعé³õѧÕßÐÐÁС£ÄÚÈݾùÀ´×ÔÓÚCSDNµÄ¾µäÀÏÌù¡£
¡¡¡¡ÎÊÌâÒ»£ºÎÒÉùÃ÷ÁËʲô£¡
String s = "Hello world!";
¡¡¡¡Ðí¶àÈ˶¼×ö¹ýÕâÑùµÄ ......