在java中使用jdbc的数据库连接大全

  这是DJ老兄整理的, 我给贴出来了.

 

        // 连接 SqlServer

        //String jdbcDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

        //String dbURL = "jdbc:microsoft:sqlserver://DJ:1433";

        //String username = "pspt";

        //String passwd = "pspt";

        //String sqlQuery = "select * from sellingout";

        // 连接 Mysql

        //String jdbcDriver = "org.gjt.mm.mysql.Driver";//现在是"com.mysql.jdbc.Driver"

        //String dbURL = "jdbc:mysql://redhat71:3306/test";

        //String username = "";

        //String passwd = "";

        //String sqlQuery = "select * from job";

       

        // 连接 Informix

        //String jdbcDriver = "com.informix.jdbc.IfxDriver";

        //String dbURL = "jdbc:informix-sqli://197.0.88.200:8888/cmbc:informixserver=onlinef85";

        //String username = "cmbc";

        //String passwd = "12388jj";

        //String sqlQuery = "select * from psmsa";

       

        //连接 Access 文件

        //String jdbcDriver = "sun.jdbc.odbc.JdbcOdbcDriver";

        //String dbURL = "jdbc:odbc:MS Access Database;DBQ=D://myjava//jdbc//db1.mdb";

        //String username = "";

        //String passwd = "";

        //String sqlQuery = "select * from user";

       

        //连接 Teradata

        //String jdbcDriver = "com.ncr.teradata.TeraDriver";

        //String dbURL = "jdbc:teradata://192.168.0.101";

        //String username = "CMBCDVLP";

        //String passwd = "cmbcdvlp";

        //String sqlQuery = "select distinct Org_Num from PDATA1.T05_EVENT_APPLICATION where Org_Num not in (select Org_Num from PDATA1.T04_CMBC_ORG) and App_Cd = '07' and substr(App_Event_ID,11,2) = '02'";

 

        // 连接 DB2

        String jdbcDriver = "COM.ibm.db2.jdbc.app.DB2Driver";

        String dbURL = "jdbc:db2:JCMIS";

        String username = "loan";

        String passwd = "loan";

        String sqlQuery = "select * from xt_czy";