´«Ö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
Ïà¹ØÎĵµ£º
Ôڳɹ¦ÊµÏÖJavaµ÷ÓÃC++Ö®ºó£¬½ÓÏÂÀ´Ïëµ½ÄÜ·ñͨ¹ýJNAʵÏÖJavaµ÷ÓÃFortran£¬½ñÌìÊÔÑéÁËһϣ¬»¹ÊDZȽÏÈÝÒ׵ġ£
ÍøÉÏÓÐÒ»¸öJavaµ÷ÓÃF95µÄÀý×Ó£¬µ«ÊÇÎÒ¿¼ÂDz»½öҪʵÏÖF95µÄµ÷Ó㬻¹ÒªÊµÏÖF77µÄµ÷Óã¬ËùÒÔ·ÑÁËһЩÖÜÕÛ¡£
ÎÊÌâµÄ¹Ø¼üÔÚÓÚF77Ϊ¹ý³ÌÃû×Ô¶¯Ìí¼ÓÁËÒ»¸öβ²¿µÄÏ»®Ïߣ¬ËùÒÔsub1Õâ¸ö¹ý³Ì£¬µ½JavaÒ»¶Ë£¬¾Í±ä³ÉÁËsub1_£¬ ......
ÔÚ
JAVA
ÖУ¬ÓÐÁù¸ö²»Í¬µÄµØ·½¿ÉÒÔ´æ´¢Êý¾Ý£º
1.
¼Ä´æÆ÷£¨
register
£©¡£ÕâÊÇ×î¿ìµÄ´æ´¢Çø£¬ÒòΪËüλÓÚ²»Í¬ÓÚÆäËû´æ´¢ÇøµÄµØ·½——´¦ÀíÆ÷ÄÚ²¿¡£µ«ÊǼĴæÆ÷µÄÊýÁ¿¼«
ÆäÓÐÏÞ£¬ËùÒԼĴæÆ÷ÓɱàÒëÆ÷¸ù¾ÝÐèÇó½øÐзÖÅä¡£Äã²»ÄÜÖ±½Ó¿ØÖÆ£¬Ò²²»ÄÜÔÚ³ÌÐòÖиоõµ½¼Ä´æÆ÷´æÔÚµÄÈκμ£Ïó¡£
2.
¶ÑÕ»£¨
stac ......
Java±¾µØ½Ó¿Ú(Java Native Interface (JNI))ÔÊÐíÔËÐÐÔÚJavaÐéÄâ»ú(Java Virtual
Machine (JVM))ÉϵĴúÂëµ÷Óñ¾µØ³ÌÐòºÍÀà¿â£¬»òÕß±»ËüÃǵ÷Óã¬ÕâЩ³ÌÐòºÍÀà¿â¿ÉÒÔÊÇÆäËüÓïÑÔ±àдµÄ£¬±ÈÈçC¡¢C++»òÕß»ã±àÓïÑÔ¡£
¡¡¡¡µ±Ò»¸ö³ÌÐòÎÞ·¨ÍêȫʹÓÃJava±àдʱ£¬¿ª·¢Õß¿ÉÒÔͨ¹ýJNIÀ´±àд±¾µØ·½·¨£¬±ÈÈç±ê×¼JavaÀà¿â²¢²»Ö§³ÖµÄÒÀÀµÓÚÆ ......
¸ÅÊö£º±¾Ê¾ÀýʵÏÖ¶ÔÏó°´ÄêÁäÉýÐò ÈËÆøÉýÐòÅÅÐò¹¦ÄÜ ÐÕÃûÉýÐò ½µÐòÅÅÐò¹¦ÄÜ
package ch02;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Comparator;
import java.util.List;
/**
* @author YaoShiyou ʵÏÖ¶ÔÏóÅÅÐò
*
*/
public class Person {
......
ÃüÃû¹æ·¶
¶¨ÒåÕâ¸ö¹æ·¶µÄÄ¿µÄÊÇÈÃÏîÄ¿ÖÐËùÓеÄÎĵµ¶¼¿´ÆðÀ´ÏñÒ»¸öÈËдµÄ£¬Ôö¼Ó¿É¶ÁÐÔ£¬¼õÉÙÏîÄ¿×éÖÐÒòΪ»»È˶ø´øÀ´µÄËðʧ¡££¨ÕâЩ¹æ·¶²¢²»ÊÇÒ»¶¨Òª¾ø¶Ô×ñÊØ£¬µ«ÊÇÒ»¶¨ÒªÈóÌÐòÓÐÁ¼ºÃµÄ¿É¶ÁÐÔ£©
Package µÄÃüÃû
Package µÄÃû×ÖÓ¦¸Ã¶¼ÊÇÓÉÒ»¸öСдµ¥´Ê×é³É¡£
Class µÄÃüÃû
Class µÄÃû×Ö±ØÐë ......