1.2. MyBatis Connect to SQL Server

The 1.1 example uses MyBatis to connect to the MySQL database, and if you use a SQL Server database, you can set the following

1. Adding dependencies to the SQL Server connection in the Pom file

<Dependency>    <groupId>Com.microsoft.sqlserver</groupId>    <Artifactid>Sqljdbc4</Artifactid>    <version>4.0</version></Dependency>

2, modify the configuration of MyBatis

<DataSourcetype= "unpooled">    < Propertyname= "Driver"value= "Com.microsoft.sqlserver.jdbc.SQLServerDriver" />    < Propertyname= "url"value= "Jdbc:sqlserver://127.0.0.1;database=mybatis;" />    < Propertyname= "username"value= "sa" />    < Propertyname= "Password"value= "sa" /></DataSource>

1.2, MyBatis Connect to SQL Server