根据 SpringBoot 中的数据访问章节中的案例,修改为 SpringBoot + MyBatisPlus 来实现用户的CRUD功能,页面就使用之前的页面即可。
前台效果:
导入的依赖:
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!--导入mybatispuls-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.5.1</version>
</dependency>
<!--导入lombok-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
<!--jdbc驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
</dependency>
</dependencies>
yml配置:
spring:
datasource:
url: jdbc:mysql://localhost:3306/databaseName
driver-class-name: com.mysql.cj.jdbc.Driver
username: username
password: password
controller:
@Autowired
private BookService bookService;
@GetMapping()
public Result getAll(){
return new Result(null,bookService.getAll(),null);
}
@PostMapping
public void add(@RequestBody Book book){
bookService.add(book);
}
@PutMapping
public void update(@RequestBody Book book){
bookService.update(book);
}
@DeleteMapping("/{id}")
public void deleteById(@PathVariable Integer id){
bookService.delete(id);
}
book类:
@TableName("tbl_book")
@Data
public class Book {
private Integer id;
private String type;
private String name;
private String description;
}
dao:
@Mapper
public interface BookDao extends BaseMapper<Book> {
}