几种常见数据库的driverClassName和url

 

DB2:

 

driverClassName:com.ibm.db2.jcc.DB2Driver

 

url:jdbc:db2://localhost:50000/sample

 

Oracle:

 

driverClassName:oracle.jdbc.driver.OracleDriver

 

url:jdbc:oracle:thin:@localhost:1521:orcl

 

MySql:

 

driverClassName:com.mysql.jdbc.Driver

 

url:jdbc:mysql://localhost:3306/test

 

SqlServer:

 

driverClassName:com.microsoft.sqlserver.jdbc.SQLServerDriver

 

url:jdbc:sqlserver://localhost:1433;databaseName=test