数据库连接Driver Class和JDBC URL大全

时间:2020-12-20 04:39:10

1、MySQL:

driverClass:com.mysql.jdbc.Driver
                      org.gjt.mm.mysql.Driver

jdbcUrl:jdbc:mysql://192.168.0.1:3306/yourDBName

 

2、Oracle:

 (thin模式)

driverClass:oracle.jdbc.driver.OracleDriver

jdbcUrl:jdbc:oracle:thin:@192.168.0.1:1521:yourDBName

 

3、SQL Server:

driverClass:com.microsoft.sqlserver.jdbc.SQLServerDriver(2005版本及以后)

                    com.microsoft.jdbc.sqlserver.SQLServerDriver(2000版本)

jdbcUrl:jdbc:sqlserver://192.168.0.1:1433;databasename=yourDBName

 

4、Sybase:

driverClass:com.sybase.jdbc3.jdbc.SybDriver
                         com.sysbase.jdbc.SybDriver

jdbcUrl:jdbc:sybase:Tds:127.0.0.1:5007/myDB

 

5、DB2:

1)db2java.zip

driverClass:COM.ibm.db2.jdbc.net.DB2Driver

jdbcUrl:jdbc:db2://127.0.0.1:5000/DBNAME

2)db2jcc.jar

driverClass:com.ibm.db2.jcc.DB2Driver

jdbcUrl:jdbc:db2://127.0.0.1:5000/DBNAME
3) driverClass:com.ibm.db2.jdbc.app.DB2DriverjdbcUrl:jdbc:db2://127.0.0.1:5000/yourDBName

 

6、Informix:

driverClass:com.informix.jdbc.IfxDriver

jdbcUrl:jdbc:informix-sqli://127.0.0.1:1533/yourDBName:informixserver=myserver;user=test;password=test123

 

7、PostgreSQL:

driverClass:org.postgresql.Driver

jdbcUrl:jdbc:postgresql://127.0.0.1:5432/yourDBName

 
8、Access:

driverClass:sun.jdbc.odbc.JdbcOdbcDriver

jdbcUrl:jdbc:odbc:dataSourceName


9、Memcached:

driverClass:

jdbcUrl:


10、MongoDB:

driverClass:

jdbcUrl:


11、Redis:

driverClass:

jdbcUrl:


12、SQLite:

driverClass:

jdbcUrl:

 

 

driverClass:

jdbcUrl: