SpringBoot简单整合Mybatis

SpringBoot整合Mybatis
第一次，所以这里映射文件使用的还是mapper.xml，后面一定会改正。
如何新建的项目太简单了这里就省略了。抱歉

结构

依赖

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>2.1.0</version>
    </dependency>

    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <scope>runtime</scope>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-tomcat</artifactId>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
</dependencies>

启动类

@MapperScan("com.zsl.springbootmybatis.mapper") //扫描的mapper
@SpringBootApplication
public class SpringbootmybatisApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringbootmybatisApplication.class, args);
    }

}

pojo

/**
 * @author ZSL
 * @ClassName User
 * @description
 * @date 2019/8/5
 */
public class User implements Serializable {

  private Integer id;
  private String userName;
  private String passWord;
  private String realName;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getPassWord() {
        return passWord;
    }

    public void setPassWord(String passWord) {
        this.passWord = passWord;
    }

    public String getRealName() {
        return realName;
    }

    public void setRealName(String realName) {
        this.realName = realName;
    }

    public User(Integer id, String userName, String passWord, String realName) {
        this.id = id;
        this.userName = userName;
        this.passWord = passWord;
        this.realName = realName;
    }

    public User() {
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", userName='" + userName + '\'' +
                ", passWord='" + passWord + '\'' +
                ", realName='" + realName + '\'' +
                '}';
    }
}

Mapper接口

/**
 * @author ZSL
 * @ClassName UserMapper
 * @description
 * @date 2019/8/5
 */
@Repository
public interface UserMapper {

    public User selById(Integer id);
}

Mapper.xml映射文件

<?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.zsl.springbootmybatis.mapper.UserMapper">

    <resultMap id="BaseResultMap" type="com.zsl.springbootmybatis.pojo.User">
        <result column="id" jdbcType="INTEGER" property="id" />
        <result column="userName" jdbcType="VARCHAR" property="userName" />
        <result column="passWord" jdbcType="VARCHAR" property="passWord" />
        <result column="realName" jdbcType="VARCHAR" property="realName" />
    </resultMap>

    <select id="selById" resultType="com.zsl.springbootmybatis.pojo.User">
        select * from user where id = #{id}
    </select>

</mapper>

Service接口

/**
 * @author ZSL
 * @ClassName IUserService
 * @description
 * @date 2019/8/5
 */
public interface IUserService {

    public User selById(Integer id);
}

Service实现类

@Service
public class UserServiceImpl implements IUserService {

    @Autowired
    private UserMapper userMapper;

    @Override
    public User selById(Integer id) {

        return userMapper.selById(id);
    }
}

controller

/**
 * @author ZSL
 * @ClassName UserController
 * @description
 * @date 2019/8/5
 */
@RestController
public class UserController {

    @Autowired
    private IUserService userService;

    @GetMapping("/sel")
    public User selById(Integer id){

        return userService.selById(id);
    }
}

application

server.port=8080

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=xxx
spring.datasource.password=xxx
spring.datasource.url=jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC

mybatis.mapper-locations=classpath:mapping/*Mapper.xml
mybatis.type-aliases-package=com.zsl.springbootmybatis.pojo


#showSql
logging.level.com.zsl.springbootmybatis.mapper = debug