jdbc连接各大数据库的连接字符串和驱动类

oracle:

driverClass：oracle.jdbc.driver.OracleDriver
url：jdbc:oracle:thin:@127.0.0.1:1521:dbname

oracle的jdbc包无法直接从maven下载,需要手动下载jar包再添加到本地仓库
ojdbc6.jar
添加jar包到maven仓库

mysql:

driverClass：com.mysql.jdbc.Driver
url：jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=true   
#注意: 高版本的 mysql 需要显示指定 useSSL
maven:
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.36</version>
    </dependency>

DB2

driverClass：com.ibm.db2.jcc.DB2Driver
url：jdbc:db2://127.0.0.1:50000/dbname

sybase

driverClass：com.sybase.jdbc.SybDriver
url：jdbc:sybase:Tds:localhost:5007/dbname

PostgreSQL

driverClass：org.postgresql.Driver
url：jdbc:postgresql://localhost/dbname

Sql Server

driverClass：com.microsoft.sqlserver.jdbc.SQLServerDriver
url：jdbc:sqlserver://localhost:1433; DatabaseName=dbname