流行的数据库驱动配置

每次都要查一下啊，自己留个记录

ORACLE

• jdbc.driver=oracle.jdbc.driver.OracleDriver
• jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl（oracle安装默认端口1521）
• jdbc.username=username
• jdbc.password=password

Mysql

• jdbc.driver=com.mysql.jdbc.Driver
• jdbc.url=jdbc:mysql://127.0.0.1:3306/mydb?useUnicode=true&characterEncoding=utf-8（mysql默认端口3306）
• jdbc.username=username
• jdbc.password=password

Sqlserver

• jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
• jdbc.url=jdbc:sqlserver://127.0.0.1:1433;instanceName=sqlserver2005;DatabaseName=easysite_2005
• jdbc.username=username
• jdbc.password=password

Spring项目中，application.properties

spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.jdbc-url=xxxx
spring.datasource.username=xxxx
spring.datasource.password=xxxx

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>com.microsoft.sqlserver</groupId>
            <artifactId>mssql-jdbc</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc6</artifactId>
            <version>11.2.0.3</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.35</version>
        </dependency>