- 在线文档
- 项目创建
- pom.xml
<!-- https://mvnrepository.com/artifact/com.baomidou/mybatis-plus-boot-starter --> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>3.5.3</version> </dependency>
- application.yml
spring: datasource: url: jdbc:mysql://localhost:3306/mybatis-plus username: root password: 123456 driver-class-name: com.mysql.cj.jdbc.Driver
- MySQL脚本
DROP TABLE IF EXISTS user; CREATE TABLE user ( id BIGINT(20) NOT NULL COMMENT '主键ID', name VARCHAR(30) NULL DEFAULT NULL COMMENT '姓名', age INT(11) NULL DEFAULT NULL COMMENT '年龄', email VARCHAR(50) NULL DEFAULT NULL COMMENT '邮箱', PRIMARY KEY (id) ); DELETE FROM user; INSERT INTO user (id, name, age, email) VALUES (1, 'Jone', 18, 'test1@baomidou.com'), (2, 'Jack', 20, 'test2@baomidou.com'), (3, 'Tom', 28, 'test3@baomidou.com'), (4, 'Sandy', 21, 'test4@baomidou.com'), (5, 'Billie', 24, 'test5@baomidou.com');
- 代码生成(MybatisX)
- Mapper扫描
@SpringBootApplication @MapperScan("com.mybatis.plus.mapper") public class MybatisPlusApplication { public static void main(String[] args) { SpringApplication.run(MybatisPlusApplication.class, args); } }
- 接口测试
@RestController @RequestMapping("/user") public class UserController { @Autowired private UserService userService; @PostMapping("/create") public Boolean create(@RequestBody User user) { return userService.save(user); } @GetMapping("/get") public User get(@RequestBody User user) { return userService.getById(user.getId()); } @GetMapping("/getAll") public List<User> getAll() { return userService.list(); } @PutMapping("/update") public Boolean update(@RequestBody User user) { return userService.updateById(user); } @DeleteMapping("/delete") public Boolean delete(@RequestBody User user) { return userService.removeById(user); } @DeleteMapping("/deleteAll") public Boolean deleteAll() { return userService.remove(new QueryWrapper<>()); } }
MyBatis-Plus搭建(从0到1)
于 2023-01-10 23:20:18 首次发布