SpringBoot-2.3.4集成MybatisPlus-3.4.0
版本环境
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();
}
}