给大家提个问题,jdbc和database的

Question

============ORACLE 8i============================
Class.forName ("oracle.jdbc.driver.OracleDriver"); 
Connection conn = 
   DriverManager.getConnection ("jdbc:oracle:thin:@myhost:1521:orcl",
       "scott", "tiger");=============MySQL=================================
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://myhost:3306/dbname","user","passwd");============InfoMax================================
Class.forName("com.informix.jdbc.IfxDriver");
conn = DriverManager.getConnection("jdbc:informix-sqli://myhost:1533:informixserver=myserver;user=rdtest;password=test");

Answer 1

============InforMix================================
Class.forName("com.informix.jdbc.IfxDriver");
conn = DriverManager.getConnection("jdbc:informix-sqli://myhost:1533:informixserver=myserver;user=rdtest;password=test");

Answer 2

还是skyyoung好，那jdbc driver呢

Answer 3

=============SQLServer2000=========================
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://server1:1433","username","password");

Answer 4

jdbc driver download:SQLServer:http://www.microsoft.com/sql/downloads/default.asp
MySQL:http://www.mysql.com/downloads/api-jdbc.html
Oracle:http://otn.oracle.com/software/content.html

Answer 5

实际上很大驱动都有dbping这个东东的，用那个不就知道如何配置了吗

Answer 6

一般jdbc驱动的包里面都有一个readme，里面说得清清楚楚，为什么不看一下先？

Answer 7

skyyoung(路人甲)同志不错，值得表扬。本帖结分，加入精华。

Answer 8

mm.mysql jdbc怎么安装呀在linux72下。

Answer 9

---------------------DB2--------------------
---------------------   --------------------
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();//For Application
      String url = "jdbc:db2:sample";
      con = DriverManager.getConnection(url, userid, passwd);
Class.forName("COM.ibm.db2.jdbc.net.DB2Driver").newInstance();//For Applet
        String url = "jdbc:db2:// "+server+":"+port+"/sample"; 
        con = DriverManager.getConnection(url, userid, password );