javaÁ¬½ÓÊý¾Ý¿â
1.javaÁ¬½ÓOracleÊý¾Ý¿â£º
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@127.0.0.1:1521:È«¾ÖÊý¾Ý¿âÃû";
String uname="Óû§Ãû";
String pwd="ÃÜÂë";
Connection cn =DriverManager.getConnection(url,uname,pwd);
Statement s=cn.createStatement();
ResultSet rs=s.executeQuery(sqlÓï¾ä);
2.jdbcÇŽÓodbc
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:odbcÊý¾ÝÔ´";
String uname="Óû§Ãû";
String pwd="ÃÜÂë";
Connection cn =DriverManager.getConnection(url,uname,pwd);
Statement s=cn.createStatement();
ResultSet rs=s.executeQuery(sqlÓï¾ä);
3.javaÁ¬½Ómysql
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://127.0.0.1:3306/Êý¾Ý¿âÃû";
String uname="Óû§Ãû";
String pwd="ÃÜÂë";
Connection cn =DriverManager.getConnection(url,uname,pwd);
Statement s=cn.createStatement();
ResultSet rs=s.executeQuery(sqlÓï¾ä);
Ïà¹ØÎĵµ£º
×î½üÔÚÕÒ¹¤×÷£¬»ù±¾¶¼ÊÇjava¿ª·¢µÄ·½Ïò£¬ºÜ¶à±ÊÊÔ¡¢ÃæÊÔÌâ¶¼ÊÇÎ§ÈÆStringÀà¶ÔÏóÕ¹¿ªµÄ£¬»¨ÑùºÜ¶à£¬µ«ÊÇÍò±ä²»ÀëÆäÖУ¬ÕÆÎÕÁË»ù±¾µÄÔÀí£¬ÎÞÂÛÔõô±ä£¬ÊµÖʶ¼ÊÇÒ»ÑùµÄ¡£ÏÂÃæ×ܽáһϹØÓÚStringµÄ»ù±¾ÖªÊ¶µã£º
£¨Ò»£©StringÊÇfinalµÄ
¿ÉÄÜÎÒÃǺܶàÈËÓöµ½¹ýÕâ¸öÎÊÌâfinal¹Ø¼ü×ÖÓÐʲô×÷Óã¬ÆäÖÐÒ»¸ö»Ø´ð¾ÍÊÇfinalÐÞÊÎ ......
JavaɳÏäʵÏÖÊÇÖØÐ´Àà¼ÓÔØÆ÷ºÍ°²È«¹ÜÀíÆ÷,ͨ¹ýÉèÖõÄÈ«¾Ö°²È«¹ÜÀíÆ÷À´¿ØÖÆÖ´ÐгÌÐòµÄȨÏÞ
˵Ã÷: °²È«²ßÂÔÖ»¶Ô°²×°°²È«¹ÜÀíÆ÷Ö®ºóµÄÀàÉúЧ,֮ǰµÄÀ಻Ôٴ˹ÜÀí·¶Î§Ö®ÄÚ,ÀûÓÃÕâÒ»µã¿ÉÒÔÔ¤ÏÈÉèÖÃÎÒÃÇÐèÒªµÄ²Ù×÷,¶ø¶Ôij¸öµãÖ®ºóµÄËùÓзǷ¨²Ù×÷½øÐÐȨÏÞÉèÖÃ.
Àà¼ÓÔØÆ÷ÖØÐ´
/**
* [ÖØÐ´µÄÀà¼ÓÔØÆ÷]
* ɳÏä³ÌÐòÀà¼ÓÔØÆ÷,¿ ......
1. JDBC Çý¶¯³ÌÐò
1.1 DB2 JDBC Type 2 Çý¶¯³ÌÐò
DB2 ¿Í»§»ú
²»½¨ÒéʹÓÃ
COM.ibm.db2.jdbc.app.DB2Driver µ÷ÓÃClass.forName() ·½·¨¡£
1.2 IBM DB2 ͨÓÃJDBC ºÍSQLJ Çý¶¯³ÌÐò
ÌṩÁËType 2 Á¬½ÓÐÔºÍType 4 Á¬½ÓÐÔ
¿ÉÒÔ½«Õâ¸öÇý¶¯³ÌÐòÓÃÓÚapp ......
¹ØÓÚ¾ø¶Ô·¾¶ºÍÏà¶Ô·¾¶£º
¾ø¶Ô·¾¶¾ÍÊÇÄãµÄÖ÷Ò³ÉϵÄÎļþ»òĿ¼ÔÚÓ²ÅÌÉÏÕæÕýµÄ·¾¶£¬(URLºÍÎïÀí·¾¶)ÀýÈ磺C:xyz est.txt ´ú±íÁËtest.txtÎļþµÄ¾ø¶Ô·¾¶¡£http://www.sun.com/index.htmÒ²´ú±íÁËÒ»¸öURL¾ø¶Ô·¾¶¡£Ïà¶Ô·¾¶£ºÏà¶ÔÓëij¸ö»ù׼Ŀ¼µÄ·¾¶¡£°üº¬WebµÄÏà¶Ô·¾¶£¨HTMLÖеÄÏà¶ÔĿ¼£©£¬ÀýÈ磺ÔÚServletÖУ¬" ......
×î½üÏîÄ¿ÖÐÓиöÐèÇó£¬ÒªÓÃSocketʵÏÖ³¤Á¬½Ó£¬²¢ÇÒÔÚͨÐŹý³ÌÖÐÒª»¥ÎªserverºÍclient£¬¼´ÔÚÒ»¸öÁ¬½ÓÖУ¬¼ÈÄܹ»·¢ËÍÏûÏ¢£¬£¨´Ëʱ×÷Ϊ¿Í»§¶Ë£©£¬ÓÖÒªÄܹ»½ÓÊÕÏûÏ¢£¨´Ëʱ×÷Ϊserver¶Ë£©£¬Ñо¿ÁËÏ£¬ÊµÏÖ·½Ê½ÈçÏ£º
Ò»¡¢·¢ËÍÏûϢʱ½¨Á¢Á¬½Ó£¬¹¹½¨Í¨µÀ¡£
Socket socket = new Socket();
SocketAddress endpoint = new In ......