Spring Boot整合Mybatis

      
         org.mybatis.spring.boot
         mybatis-spring-boot-starter
         2.2.0
       

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

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

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

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

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 selectAllUser();

}

resources/mybtis/mapper/UserMapper.xml

    
        select * from user;
    

import com.konlsvg.pojo.User;

import java.util.List;

public interface UserService {
    List selectAllUser();
}

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 selectAllUser() {
        return userMapper.selectAllUser();
    }
}

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 selectAllUser(){
        List userList = userService.selectAllUser();
        return userList;
    }

}