Springboot后台管理系统(六)spring集成Mybatis实现数据查询

spring集成Mybatis实现数据查询

配置文件更新application.yml

server:
  port: 9091

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/vue?serverTimeZone=GMT%2b8
    username: root
    password: root123456

数据库建表 ———-sys_user

entity — User

@Data
//@NoArgsConstructor
//@AllArgsConstructor
public class User{
    private Integer id;
    private String username;
    private String password;
    private String nickname;
    private String email;
    private String phone;
    private String address;
}

mapper —UserMapper

@Mapper
public interface UserMapper {

    /***
     * 查询所有数据
     * @return List<User>
     */
    @Select("select * from sys_user")
    List<User> findAll();
}

controller —UserController

@RestController
public class UserController {

    @Autowired
    private UserMapper userMapper;

    @GetMapping("/")
    public List<User> index(){
        List<User> all =userMapper.findAll();
        return all;
    }
}