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

在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";