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Óï¾ä);
Ïà¹ØÎĵµ£º
×î½üѧÁËservletºÍoracle£¬Ò²¾Í°ÑËûÃǽáºÏÏ£¬×ö¸ö·ÖÒ³µÄÒ³Ãæ³öÀ´¡£ËãÊÇÒ»ÖÖ¸´Ï°°É¡£
1.Ê×ÏÈÊÇoracleµÄ·ÖÒ³ÏÔʾSQLÓï¾ä£º
select * from(select a.*, rownum rn from (select * from Person) a where rownum <= MaxN ......
»Øµ÷¸ÅÄî:
Èí¼þÄ£¿éÖ®¼ä×ÜÊÇ´æÔÚ×ÅÒ»¶¨µÄ½Ó¿Ú£¬´Óµ÷Ó÷½Ê½ÉÏ£¬¿ÉÒÔ°ÑËûÃÇ·ÖΪÈýÀࣺͬ²½µ÷Óᢻص÷ºÍÒì²½µ÷Óá£Í¬²½µ÷ÓÃÊÇÒ»ÖÖ×èÈûʽµ÷Ó㬵÷Ó÷½ÒªµÈ´ý¶Ô·½Ö´ÐÐÍê±Ï²Å·µ»Ø£¬ËüÊÇÒ»ÖÖµ¥Ïòµ÷Ó㻻ص÷ÊÇÒ»ÖÖË«Ïòµ÷ÓÃģʽ£¬Ò²¾ÍÊÇ˵£¬±»µ÷Ó÷½ÔÚ½Ó¿Ú±»µ÷ÓÃʱҲ»áµ÷ÓöԷ½µÄ½Ó¿Ú£»Òì²½µ÷ÓÃÊÇÒ»ÖÖÀàËÆÏûÏ¢»òʼþµÄ»úÖÆ£¬² ......
½ñÌì·¢ÏÖÒ»¸öºÜNBµÄÍæÒ⣬ÈÃÎÒÃÇÔÚ¿ª·¢µÄʱºòÐÞ¸ÄJavaÎļþ£¬²»ÓÃÖØÆô·þÎñÆ÷Á¢¿ÌÉúЧ£¡Ö§³ÖJetty tomcat jbossµÈºÜ¶à·þÎñÆ÷£¬Ëü¾ÍÊÇJRebel¡£ http://www.zeroturnaround.com/jrebel/installation/ ÕâÀïÓÐÕë¶Ô²»Í¬·þÎñÆ÷µÄ°²×°·½·¨£¬»ù±¾ÉÏÖ÷Á÷µÄ¶¼º¸ÇÁË£¬¾ø´ó¶àÊý³ÌÐòÔ±¶¼ÄÜʹÓã¡ÎÒÃǹ«Ë¾ÓÃmaven/jetty¶ÔÏîÄ¿½øÐй¹½¨ºÍ¿ª ......
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 ......
ʲôÊÇURI
WebÉÏ¿ÉÓõÄÿÖÖ×ÊÔ´ - HTMLÎĵµ¡¢Í¼Ïñ¡¢ÊÓÆµÆ¬¶Î¡¢³ÌÐòµÈ - ÓÉÒ»¸öͨ¹ýͨ
ÓÃ×ÊÔ´±êÖ¾·û£¨Universal Resource Identifier, ¼ò³Æ"URI"£©½øÐж¨Î»¡£
URIÒ»°ãÓÉÈý²¿·Ö×é³É£º
·ÃÎÊ×ÊÔ´µÄÃüÃû»úÖÆ¡£
´æ·Å×ÊÔ´µÄÖ÷»úÃû¡£
×ÊÔ´×ÔÉíµÄÃû³Æ£¬ÓÉ·¾¶±íʾ¡£
¿¼ÂÇÏÂÃæµÄURI£¬Ëü±íʾÁ˵±Ç°µÄHTML ......