Springboot配置Sqlserver
Pom配置：
1 <dependency> 2 <groupId>com.microsoft.sqlserver</groupId> 3 <artifactId>sqljdbc4</artifactId> 4 <version>4.0</version> 5 </dependency>
mybatis配置
1 <?xml version="1.0" encoding="UTF-8" ?> 2 3 <!DOCTYPE configuration PUBLIC 4 "-//mybatis.org//DTD Config 3.0//EN" 5 "http://mybatis.org/dtd/mybatis-3-config.dtd"> 6 7 <configuration> 8 <typeAliases> 9 <typeAlias alias="xxx" type="com.myproject.demo.model.xxx" /> 10 </typeAliases> 11 12 <environments default="development"> 13 <environment id="development"> 14 <transactionManager type="JDBC" /> 15 <dataSource type="POOLED"> 16 <property name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" /> 17 <property name="url" value="jdbc:sqlserver://***.*.*.*:1433;databaseName=Northwind; catalogName=Northwind" /> 18 <property name="username" value="sa" /> 19 <property name="password" value="********" /> 20 <property name="poolMaximumActiveConnections" value="50" /> 21 </dataSource> 22 </environment> 23 </environments> 24 25 <mappers> 26 <mapper resource="maps/sqlmap.xml" /> 27 </mappers> 28 </configuration>
记录下自己以后学习用
