SpringBoot-2.3.4集成MybatisPlus-3.4.0

MybatisPlus官方文档

版本环境

IntelliJ IDEA:2020.1.2 java:jdk-14.0.1 springboot:v2.3.4.RELEASE gradle:gradle-6.7-rc-4 springfox(swagger):version: '3.0.0' swagger-bootstrap-ui:version: '1.9.6' mysql-connector-java:version: '8.0.16' mybatis-plus-boot-starter:version: '3.4.0'

MybatisPlus配置

配置 MapperScan 注解

@SpringBootApplication @EnableOpenApi @MapperScan("com.insentek.gradlespringboot.dao") public class GradleSpringBootApplication { public static void main(String[] args) { SpringApplication.run(GradleSpringBootApplication.class, args); } }

数据库配置

spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/mytest?useSSL=false&serverTimezone=GMT%2B8 username: root password: rootroot create table mytest.user ( id int auto_increment primary key, name varchar(30) not null, pass varchar(30) not null, age int null, email varchar(30) null, constraint user_name_uindex unique (name) );

实现查数据

domain

User.java

@NoArgsConstructor @Data @ApiModel(value = "用户实体", description = "用户实体类") public class User { @ApiModelProperty(value = "用户名") private String name; @JsonIgnore @ApiModelProperty(value = "用户密码") private String pass; @ApiModelProperty(value = "用户年龄") private Integer age; @ApiModelProperty(value = "用户邮件") private String email; @ApiModelProperty(value = "用户id") private Integer id ; }

dao

UserMapper.java

@Mapper public interface UserMapper extends BaseMapper<User> { }

service

UserService.java

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

UserServiceImpl.java

@Service public class UserServiceImpl implements UserService { @Autowired UserMapper userMapper; @Override public List<User> selectAllUser (){ List<User> list=userMapper.selectList(null); list.forEach(System.out::println); return list; } }

controller

UserController.java

@Api(value = "api/v1/dev/user") @RestController @RequestMapping(value ="api/v1/dev/user") public class UserController { @Autowired UserService userService; @ApiOperation(value = "用户", notes = "查询所有用信息") @GetMapping(value = "", produces = MediaType.APPLICATION_JSON_VALUE) public List<User> selectUser() { return userService.selectAllUser(); } }