1,MSSQL驱动

• MSSQL驱动版本不正确，报错:不支持“variant”数据类型

参考：尽量到仓库里找较新版本测试

<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>9.2.1.jre8</version>
    <scope>compile</scope>
    <exclusions>
      <exclusion>
        <groupId>com.microsoft.azure</groupId>
        <artifactId>azure-keyvault</artifactId>
      </exclusion>
    </exclusions>
</dependency>

2，durid版本

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.20</version>
 </dependency>

3，配置

# 占位符，便于动态传参
db.addr = localhost:1433;DatabaseName=tab1
db.username = sa
db.pwd=sa
# datasource config
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.url=jdbc:sqlserver://${db.addr}
spring.datasource.username=${db.username}
spring.datasource.password=${db.pwd}
# ds pool config
spring.datasource.initial-size=5
spring.datasource.max-active=10
# 单位:毫秒
spring.datasource.max-wait=1000
spring.datasource.connection-test-query=select 1
spring.datasource.test-on-borrow=false
spring.datasource.test-on-connect=false
spring.datasource.test-on-return=false

4，spring config

@Configuration
public class SpringConfig {
    @Bean(initMethod = "init", destroyMethod = "close")
    @ConfigurationProperties("spring.datasource")
    public DruidDataSource dataSource(){
        //return new DruidDataSource(); // 也可以
        return DataSourceBuilder.create().type(DruidDataSource.class).build();
    }
}