MAVEN添加SQL SERVER依赖

maven添加SQL SERVER依赖

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

spring-boot配置SQL SERVER连接

#database 数据源
spring.jpa.database=sql_server
spring.datasource.url=jdbc:sqlserver://localhost:1433;DatabaseName=数据库名称
spring.datasource.username=账户
spring.datasource.password=密码
spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver