1.properties配置
类似于mysql
spring:
datasource:
url: jdbc:sqlserver://${sqlserver_url:192.108.108.141}:${sqlserver_port:1433};DatabaseName=${database_name:NCDB}
username: ${sqlserver_name:sa}
password: ${sqlserver_password:Qwe!@#123}
driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
#pagehelper分页插件
pagehelper:
helperDialect: sqlserver2012 #分页插件方言选择
autoRuntimeDialect: true
reasonable: true #合理化参数,设为true时pageNum<=0 时会查第一页, pageNum>pages(超过总数时),会查询最后一页
supportMethodsArguments: true
2.依赖包
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<scope>runtime</scope>
</dependency>