[笔记]MyBatis Spring Boot Starter配置 mybatis

1.在 pom 引入mybatis-spring-boot-starter及其他依赖（jdbc 数据库 web）

 <dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.3</version>
</dependency>

2.application 配置

server:
  port: 9999
spring:
  datasource:
    driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
    schema-username: ****
    url: jdbc:sqlserver://****;DatabaseName=****
    username: ****
    password: ****
  servlet:
    multipart:
      # 上传文件总的最大值
      max-request-size: 10MB
      # 单个文件的最大值
      max-file-size: 10MB
mybatis:
  type-aliases-package: com.xhz.ari.mybatis.pojo
  ///mapper.xml目录  （卸载 resource 目录下）
  mapper-locations: classpath:mybatis/mapper/*.xml

3.mapper 接口，mapper.xml，实体类编写

@Mapper
@Repository
public interface SysUserMapper {
    @Select("select * from Sys_UserInfo")
    List<Map> findAll();
    SysUser getUserByNameAndPassword(String userName);
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xhz.ari.mybatis.mapper.SysUserMapper">
    <select id="getUserByNameAndPassword" resultType="com.xhz.ari.mybatis.pojo.SysUser">
       select  * from Sys_UserInfo where IsValid=1
        and UserName=#{param1};
    </select>
</mapper>

4.使用

@RestController
@RequestMapping("api")
public class TestController {
    @Autowired
    SysUserMapper mapper;
    @RequestMapping("findAll")
    List<Map> findAll() {
        return mapper.findAll();
    }

}