SpringBoot连接Sqlserver

目录

• 1、pom.xml添加sqlserver驱动依赖
• 2、application.yml配置sql连接

1、pom.xml添加sqlserver驱动依赖

        <dependency>
            <groupId>com.microsoft.sqlserver</groupId>
            <artifactId>mssql-jdbc</artifactId>
            <scope>runtime</scope>
        </dependency>

2、application.yml配置sql连接

spring:
  datasource:
    driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
    url: jdbc:sqlserver://127.0.0.1:1433; databaseName=******
    username: sa
    password: ********