Spring Boot整合Mybatis

Spring Boot整合Mybatis

1、导入依赖

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

2、配置数据库

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT
    driver-class-name: com.mysql.cj.jdbc.Driver

3、配置Mybatis

mybatis:
  #别名
  type-aliases-package: com.konlsvg.pojo
  #扫描包
  mapper-locations: classpath:mybatis/mapper/*.xml

4、实体类User

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private int id;
    private String name;
    private String pwd;
}

5、mapper层UserMapper

import com.konlsvg.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface UserMapper {

    List<User> selectAllUser();

}

6、UserMapper.xml

resources/mybtis/mapper/UserMapper.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.konlsvg.mapper.UserMapper">

    <select id="selectAllUser" resultType="User">
        select * from user;
    </select>

</mapper>

7、service层UserService

import com.konlsvg.pojo.User;

import java.util.List;

public interface UserService {
    List<User> selectAllUser();
}

8、UserServiceImpl

import com.konlsvg.mapper.UserMapper;
import com.konlsvg.pojo.User;
import com.konlsvg.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserMapper userMapper;

    @Override
    public List<User> selectAllUser() {
        return userMapper.selectAllUser();
    }
}

9、controller层UserController

import com.konlsvg.pojo.User;
import com.konlsvg.service.impl.UserServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
public class UserController {
    @Autowired
    private UserServiceImpl userService;

    @RequestMapping("/selectalluser")
    public List<User> selectAllUser(){
        List<User> userList = userService.selectAllUser();
        return userList;
    }

}