在 application.yaml 配置文件里sqlserver配置

在 application.yaml 配置文件里

#spring:

#  datasource:

#    driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver

#    url: jdbc:sqlserver://ip地址:端口;DatabaseName=数据库名

#    username: 用户名

#    password: 密码

#    maxActive: 20

#    initialSize: 1

#    maxWait: 60000

#    minIdle: 1

#    timeBetweenEvictionRunsMillis: 60000

#    minEvictableIdleTimeMillis: 300000

#    validationQuery: select 1

#    testWhileIdle: true

#    testOnBorrow: true

#    testOnReturn: true

#    poolPreparedStatements: true

#    maxOpenPreparedStatements: 20

spring:

  datasource:

    driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver

    url: jdbc:sqlserver://localhost:1433;DatabaseName=HR

    username: sa

    password: 123456

    maxActive: 20

    initialSize: 1

    maxWait: 60000

    minIdle: 1

    timeBetweenEvictionRunsMillis: 60000

    minEvictableIdleTimeMillis: 300000

    validationQuery: select 1

    testWhileIdle: true

    testOnBorrow: true

    testOnReturn: true

    poolPreparedStatements: true

    maxOpenPreparedStatements: 20