´«ÖDz¥¿ÍjavaÅàѵ java»ù´¡Ö®JDBC
×òÌì˯µÃÌ«Íí£¬ÑÏÖØÓ°ÏìÁ˽ñÌìµÄѧϰ£¬ÊµÔÚÊǵò»³¥Ê§£¡
¹ØÓÚjavaµÄ»ù´¡ÖªÊ¶»¹ÓжþÊ®Ìì¾ÍÒª½áÊøÁË£¬ÏÖÔÚÎÒÃÇÒѾ¿ªÊ¼×öһЩСµÄÁ·Ï°£¬·¢ÏÖ×Ô¼ºµÄ˼·ÓÐʱºò¸ú²»ÉÏ£¬
ÕæÉÏ»ð£¡
ѧ¶øÊµÏ°Ö®£¬²»ÄܶªÁËÎ÷¹Ï¼ñÖ¥Â飬ÉÏ¿ÎÒª½ô¸úÀÏʦ½Ú×࣬²»ÄÜ×Ô¼º×ö×Ô¼ºµÄ£¬ÀÏʦ½²ÀÏʦµÄ£¡
µ÷ÕûÐÄ̬£¬ÓúõÄѧϰ·½·¨·½ÄÜʰ빦±¶£»
JDBC£¨Java Database Connnectivity£©
JDBC±¾ÉíÊÇjavaÁ¬½ÓÊý¾Ý¿âµÄÒ»¸ö±ê×¼£¬ÊǽøÐÐÊý¾Ý¿âÁ¬½ÓµÄ³éÏó²ã£¬ÓÉjava±àдµÄÒ»×éÀà»ò½Ó¿Ú£¬
javaµÄʵÏÖÓɸ÷´óÊý¾Ý¿â³§ÉÌÀ´Íê³É¡£
±¾µØÐÒéµÄ´¿ Java Çý¶¯³ÌÐò£º
1¶àÊýÊý¾Ý¿â³§ÉÌÒѾ֧³ÖÔÊÐí¿Í»§³ÌÐòͨ¹ýÍøÂçÖ±½ÓÓëÊý¾Ý¿âͨÐŵÄÍøÂçÐÒé¡£
2ÕâÖÖÀàÐ͵ÄÇý¶¯³ÌÐòÍêȫʹÓà Java ±àд£¬Í¨¹ýÓëÊý¾Ý¿â½¨Á¢µÄ Socket Á¬½Ó£¬
²ÉÓþßÌåÓë³§É̵ÄÍøÂçÐÒé°Ñ JDBC µ÷ÓÃת»»ÎªÖ±½ÓÁ¬½ÓµÄÍøÂçµ÷ÓÃ
jbdcÇý¶¯£¬ÊµÏÖjdbc¹æ·¶µÄÀàµÄ¼¯ºÏ£¬Ò²¾ÍÊǸ÷´óÊý¾Ý¿â³§ÉÌÓÃÀ´ÊµÏÖ½Ó¿ÚºóµÄÀàµÄ·â×°°ü£¬¼´jar°ü¡£
±ÈÈçmysqlÇý¶¯£¬oralceÇý¶¯¡£
ODBC
JDBC-ODBCÇÅÊÇÓÉsun¹«Ë¾¿ª·¢£¬API×îУ¬ÐÔÄܲ»¸ß£¬²ã´ÎÌ«¶àÁË£¡
ÎÒÃÇʹÓõÄÊÇ£º
±¾µØÐÒéµÄ´¿java´úÂ룺
java´úÂë---JDBAPI---- -----Êý¾Ý¿â
ÔÚjavaÖÐ
JDBCÖ±½Ó·ÃÎÊÊý¾Ý¿â
µÚÈý·½µÄO/R¹¤¾ß£¬ÈçHIBERNATE£¬ibatisµÈ
ÔÚÒ»¸öjavaÀàÖÐÈçºÎ·ÃÎʵ½Êý¾Ý¿âÄØ£¿
×¢²áÇý¶¯£¬Çý¶¯¹ÜÀíÆ÷£¬»ñµÃconnection¶ÔÏó£¬statment¶ÔÏó
µÚÒ»ÖÖ£º
String url="jdbc:mysql://localhost:3306:/test" jdbc:<×ÓÐÒé>:<×ÓÃû³Æ>:ÊÇÒ»¸öJNI·½Ê½µÄÃüÃû
×¢£ºJNIÊÇJava Native InterfaceµÄËõд¡£´ÓJava 1.1¿ªÊ¼£¬Java Native Interface (JNI)±ê×¼³ÉΪjavaƽ̨µÄÒ»²¿·Ö£¬
ËüÔÊÐíJava´úÂëºÍÆäËûÓïÑÔдµÄ´úÂë½øÐн»»¥¡£
Class.froName("org.mysql.jdbc.Driver"); ¼ÓÔØ×Ö½ÚÂëÎļþ,»áµ÷ÓÃÀàÖеľ²Ì¬´úÂë¿é,µ«²»»áµ÷ÓÃÀàµÄ¹¹Ôì·½·¨
Connection conn=DriverManager.getConnection(url,"root","root"); »ñÈ¡Á¬½Ó
µÚ¶þÖÖ£º
String url="jdbc:mysql://localhost:3306/test"
DriverManager.registerDriver(new com.mysql.jdbc.Dri
Ïà¹ØÎĵµ£º
1£¬OCP(Open-Close Principle)¿ª±ÕÔÔò
Software entities should be open for extension,but closed for modification,(ÔÚÉè¼ÆÒ»¸öÄ£¿éµÄʱºò£¬Ó¦µ±Ê¹Õâ¸öÄ£¿é¿ÉÒÔÔÚ²»±»Ð޸ĵÄǰÌáÏÂÀ©Õ¹)¡£
&nbs ......
ÔÚ
JAVA
ÖУ¬ÓÐÁù¸ö²»Í¬µÄµØ·½¿ÉÒÔ´æ´¢Êý¾Ý£º
1.
¼Ä´æÆ÷£¨
register
£©¡£ÕâÊÇ×î¿ìµÄ´æ´¢Çø£¬ÒòΪËüλÓÚ²»Í¬ÓÚÆäËû´æ´¢ÇøµÄµØ·½——´¦ÀíÆ÷ÄÚ²¿¡£µ«ÊǼĴæÆ÷µÄÊýÁ¿¼«
ÆäÓÐÏÞ£¬ËùÒԼĴæÆ÷ÓɱàÒëÆ÷¸ù¾ÝÐèÇó½øÐзÖÅä¡£Äã²»ÄÜÖ±½Ó¿ØÖÆ£¬Ò²²»ÄÜÔÚ³ÌÐòÖиоõµ½¼Ä´æÆ÷´æÔÚµÄÈκμ£Ïó¡£
2.
¶ÑÕ»£¨
stac ......
1. ·ç¸ñÎñ±Ø±£³ÖÒ»¹áÐÔ(Consistent)
Ç°ÃæËµµ½µÄÄǸöÅóÓѵÄÎÊÌ⣬¾ÍÊÇ·ç¸ñÒ»¹áÐÐÎÊÌâ¡£ÆäʵËûµÄ·ç¸ñ£¬±¾À´Ò²Ã»ÓÐʲô
ÎÊÌ⣬µ«ÔÚÏîÄ¿ÀºÍÆäËû³ÌÐòÔ±µÄ³ÌÐòµÄ·ç¸ñ£¬ÏÔµÃìçÒ죬ÄǾʹæÔÚÎÊÌâÁË¡£
±ÈÈçÕâ¸öËõ½ø£¬ÓÖ±ÈÈç±äÁ¿ÃüÃû·½·¨£¬²»Í¬µÄÀ࣬²»Í¬µÄMethodsÀ¸÷×Ô²»Í¬£¬
Õâ³ÌÐò¾ÍºÜÄÑ¿´ÁË¡£ËùÒÔÒ»µ©ÄãÑ¡ÔñÁ ......
½ñÌìÊǸöºÃÈÕ×Ó£¬ÎªÊ²Ã´ÕâÃ´ËµÄØ£¿ÒòΪ½ñÌì½á»éµÄÌØ±ð¶à£¬ÕæµÄÏ൱¶à¡£Ö»ÒªÊǸöÓÐÍ·ÓÐÁ³µÄ·¹µê¶¼»áÓÐÐÂÈËÔÚÄÇÀïÍê³É×Ô¼º×îÃÀÀöµÄ»ØÒä¡£µ«ÎÒµÄÐÄÇéÈ´ÈçǰÁ½ÈÕµÄÁ¬ÌìÓêÒ»Ñù×ÜÊÇÒõÒõµÄÔÚÏÂÓꡣΪÁËÄÜÈÃ×Ô¼ºÔçÈÕ×ß³öÒõö²£¬ÈÃ×Ô¼ºÄܹ»ÔÙ´Î×öÖ÷×Ô¼ºµÄÈËÉú£¬½ñÌìÎÒ¾ö¶¨Òª»Øµ½ÎÒרҵ¿ª·¢µÄµÀ·ÉÏÀ´£ ......
×î½üÒ»¶Îʱ¼ä¶Ôjava¸ÐÉÏÁËÐËȤ£¬ÒòΪ½èÁËÒ»±¾¡¶Thinking in java¡·£¬Ò»Ö±Ã»Ê±¼ä¿´£¬¿ìµ½»¹ÊéµÄʱºòÁË£¬Êé×ܲ»Äܰ׽è°É¡£¿´ÁËÁ½Ì죬´ó¸ÅÊÇɨÁË100¶àÒ³°É¡£×¼±¸±àдµÚÒ»¸öjava³ÌÐò¡£
´ÓÍøÉϲé×ÊÁÏ£¬ÐèÒªJDK£¬ÓÚÊÇÏÂÔØ£¬°²×°¡£¾ßÌåÉèÖÃÈçÏ£º
µÚ ......