• SpringBoot SSMP整合案例

     简而言之：

     具体步骤如下：

    一、创建项目

    1、创建新模块，并勾选web与sql技术集：

    2、手动导入所需的额外依赖：

    1.         <dependency>
    2.             <groupId>com.baomidougroupId>
    3.             <artifactId>mybatis-plus-boot-starterartifactId>
    4.             <version>3.5.1version>
    5.         dependency>
    6.  
    7.         <dependency>
    8.             <groupId>com.alibabagroupId>
    9.             <artifactId>druid-spring-boot-starterartifactId>
    10.             <version>1.2.6version>
    11.         dependency>
    12.  
    13.         <dependency>
    14.             <groupId>org.projectlombokgroupId>
    15.             <artifactId>lombokartifactId>
    16.         dependency>

    3、修改配置文件：

    1. server:
    2.   port: 80
    3.  
    4. spring:
    5.   datasource:
    6.     druid:
    7.       driver-class-name: com.mysql.cj.jdbc.Driver
    8.       url: jdbc:mysql://localhost:3306/test?rewriteBatchedStatements=true
    9.       username: root
    10.       password: mypassword
    11.  
    12. mybatis-plus:
    13.   configuration:
    14.     log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

    4、表：

    5、构建实体类：

    1. @Data
    2. @NoArgsConstructor
    3. @AllArgsConstructor
    4. @TableName("boot_book")
    5. public class Book extends Model {
    6.  
    7.     @TableId(type = IdType.AUTO)
    8.     private Integer id;
    9.     private String type;
    10.     private String name;
    11.     private String description;
    12.  
    13. }

    二、数据层开发

    1、构建mapper接口：

    1. @Mapper
    2. public interface BookMapper extends BaseMapper {
    3. }

    2、配置文件中开启日志，并设置为标准输出：

    1. mybatis-plus:
    2.   configuration:
    3.     log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

    3、配置MP分页插件：

    由于没有applicationContext.xml，配置方法与传统MP不同

    1. package com.kvno.config;
    2.  
    3. import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
    4. import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
    5. import org.springframework.context.annotation.Bean;
    6. import org.springframework.context.annotation.Configuration;
    7.  
    8. @Configuration
    9. public class MPConfig {
    10.  
    11.     //分页插件
    12.     @Bean
    13.     public MybatisPlusInterceptor mybatisPlusInterceptor(){
    14.         MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
    15.         interceptor.addInnerInterceptor(new PaginationInnerInterceptor());
    16.         return interceptor;
    17.     }
    18.  
    19. }

    4、编写测试类：

    1. @SpringBootTest
    2. public class MapperTestCase {
    3.     @Autowired
    4.     BookMapper bookMapper;
    5.  
    6.     @Test
    7.     public void testGetById() {
    8.         System.out.println(bookMapper.selectById(1));
    9.     }
    10.  
    11.     @Test
    12.     public void testInsert() {
    13.         Book book = new Book();
    14.         book.setName("海绵宝宝");
    15.         book.setType("CH");
    16.         book.setDescription("yellow");
    17.  
    18.         boolean result = book.insert();
    19.         System.out.println(result);
    20.     }
    21.  
    22.     @Test
    23.     public void testUpdate() {
    24.         Book book = new Book();
    25.         book.setId(3);
    26.         book.setName("海绵宝宝");
    27.         book.setType("CH");
    28.         book.setDescription("square");
    29.  
    30.         boolean result = book.updateById();
    31.         System.out.println(result);
    32.     }
    33.  
    34.     @Test
    35.     public void testGetAll() {
    36.         List books = bookMapper.selectList(null);
    37.         for (Book book: books) {
    38.             System.out.println(book);
    39.         }
    40.     }
    41.  
    42.     @Test
    43.     public void testGetPage() {
    44.         IPage page = new Page<>(1,1);
    45.         bookMapper.selectPage(page,null);
    46.         System.out.println(page.getCurrent());
    47.         System.out.println(page.getSize());
    48.         System.out.println(page.getTotal());
    49.         System.out.println(page.getPages());
    50.         System.out.println(page.getRecords());
    51.     }
    52.  
    53.     @Test
    54.     public void testWrapper() {
    55.         QueryWrapper userQueryWrapper = new QueryWrapper<>();
    56.         userQueryWrapper.eq("type","CH");
    57.         bookMapper.selectList(userQueryWrapper);
    58.     }
    59. }

    三、业务层开发

     1、定义接口并编写实现类：

    1. public interface BookService {
    2.     Boolean insert(Book book);
    3.     Boolean update(Book book);
    4.     Boolean delete(Integer id);
    5.     Book getById(Integer id);
    6.     List getAll();
    7.     IPage getPage(Integer currentpage,Integer sizePage);
    8. }
    1. @Service
    2. public class BookServiceImpl implements BookService {
    3.     @Autowired
    4.     private BookMapper bookMapper;
    5.  
    6.     @Override
    7.     public Boolean insert(Book book) {
    8.         return book.insert();
    9.     }
    10.  
    11.     @Override
    12.     public Boolean update(Book book) {
    13.         return book.updateById();
    14.     }
    15.  
    16.     @Override
    17.     public Boolean delete(Integer id) {
    18.         return bookMapper.deleteById(id) > 0;
    19.     }
    20.  
    21.     @Override
    22.     public Book getById(Integer id) {
    23.         return bookMapper.selectById(id);
    24.     }
    25.  
    26.     @Override
    27.     public List getAll() {
    28.         return bookMapper.selectList(null);
    29.     }
    30.  
    31.     @Override
    32.     public IPage getPage(Integer currentpage, Integer sizePage) {
    33.         IPage page = new Page(currentpage,sizePage);
    34.         return bookMapper.selectPage(page,null);
    35.     }
    36.  
    37. }

    2、编写测试类：

    1. @SpringBootTest
    2. public class ServiceTestCase {
    3.     @Autowired
    4.     private BookService bookService;
    5.  
    6.     @Test
    7.     void testGetById() {
    8.         System.out.println(bookService.getById(1));
    9.     }
    10.  
    11.     @Test
    12.     public void testInsert() {
    13.         Book book = new Book();
    14.         book.setName("test");
    15.         book.setType("CH");
    16.         book.setDescription("service");
    17.         bookService.insert(book);
    18.     }
    19.  
    20.     @Test
    21.     void testUpdate(){
    22.         Book book = new Book();
    23.         book.setId(4);
    24.         book.setDescription("测试数据service");
    25.         bookService.update(book);
    26.     }
    27.  
    28.     @Test
    29.     void testDelete(){
    30.         bookService.delete(4);
    31.     }
    32.  
    33.     @Test
    34.     void testGetAll(){
    35.         bookService.getAll();
    36.     }
    37.  
    38.     @Test
    39.     public void testGetPage() {
    40.         IPage page = bookService.getPage(2,1);
    41.         System.out.println(page.getCurrent());
    42.         System.out.println(page.getSize());
    43.         System.out.println(page.getTotal());
    44.         System.out.println(page.getPages());
    45.         System.out.println(page.getRecords());
    46.     }
    47. }

    快速开发方案

    • 使用MyBatisPlus提供有业务层通用接口（ISerivce）快速开发service接口，使用业务层通用实现类（ServiceImpl)快速开发service实现类；

    • 在通用类基础上做功能重载或功能追加；

    • 可以编写额外方法，注意重载时不要覆盖原始操作，避免原始提供的功能丢失。

    与MP提供的BaseMapper类似，封装了各种业务层方法。简化了开发过程。

    1、接口与实现类：

    1. public interface IBookService extends IService {
    2.     boolean saveBook(Book book);
    3.  
    4.     IPage getPage(int currentPage, int pageSize, Book book);
    5. }
    1. @Service
    2. public class QuickBookServiceImp extends ServiceImpl implements IBookService {
    3.     @Autowired
    4.     private BookMapper bookMapper;
    5.  
    6.     @Override
    7.     public boolean saveBook(Book book) {
    8.         return bookMapper.insert(book) > 0;
    9.     }
    10.  
    11.  
    12.     @Override
    13.     public IPage getPage(int currentPage, int pageSize, Book book) {
    14.         LambdaQueryWrapper wrapper = new LambdaQueryWrapper();
    15.         wrapper.like(Strings.isNotEmpty(book.getType()),Book::getType,book.getType());
    16.         wrapper.like(Strings.isNotEmpty(book.getName()),Book::getName,book.getName());
    17.         wrapper.like(Strings.isNotEmpty(book.getDescription()),Book::getDescription,book.getDescription());
    18.         IPage page = new Page(currentPage,pageSize);
    19.         bookMapper.selectPage(page,wrapper);
    20.  
    21.         return page;
    22.     }
    23. }

    2、测试：

    1. @SpringBootTest
    2. public class QuickServiceTestCase {
    3.     @Autowired
    4.     private IBookService bookService;
    5.  
    6.     @Test
    7.     void testGetById() {
    8.         System.out.println(bookService.getById(1));
    9.     }
    10.  
    11.     @Test
    12.     public void testSave() {
    13.         Book book = new Book();
    14.         book.setName("test");
    15.         book.setType("CH");
    16.         book.setDescription("service");
    17.         bookService.save(book);
    18.     }
    19.  
    20.     @Test
    21.     void testUpdate(){
    22.         Book book = new Book();
    23.         book.setId(4);
    24.         book.setDescription("测试数据service");
    25.         bookService.updateById(book);
    26.     }
    27.  
    28.     @Test
    29.     void testDelete(){
    30.         bookService.removeById(4);
    31.     }
    32.  
    33.     @Test
    34.     void testGetAll(){
    35.         bookService.list();
    36.     }
    37.  
    38.     @Test
    39.     public void testGetPage() {
    40.         IPage page = new Page(2,1);
    41.         bookService.page(page);
    42.         System.out.println(page.getCurrent());
    43.         System.out.println(page.getSize());
    44.         System.out.println(page.getTotal());
    45.         System.out.println(page.getPages());
    46.         System.out.println(page.getRecords());
    47.     }
    48. }

    四、表现层开发

    • 基于Restful进行表现层接口开发
    • 使用Postman测试接口功能

    表现层业务接口测试

    1、编写controller：

    注：@RequestBody：接收前端传递给后端的请求体中的数据。

    1. /*
    2.    表现层 测试业务层接口
    3.    @RequestBody:接收前端传递给后端的请求体中的数据
    4.  */
    5.  
    6. //@RestController
    7. @RequestMapping("/books")
    8. public class BookControllerTest {
    9.     @Autowired
    10.     private IBookService bookService;
    11.  
    12.     @GetMapping
    13.     public List getAll() {
    14.         return bookService.list();
    15.     }
    16.  
    17.     @PostMapping
    18.     public Boolean save(@RequestBody Book book) { //@RequestBody
    19.         return bookService.save(book);
    20.     }
    21.  
    22.     @PutMapping
    23.     public Boolean update(@RequestBody Book book) {
    24.         return bookService.updateById(book);
    25.     }
    26.  
    27.     @DeleteMapping("/{id}")
    28.     public Boolean delete(@PathVariable(value = "id") Integer id) {
    29.         return bookService.removeById(id);
    30.     }
    31.  
    32.     @GetMapping("/{id}")
    33.     public Book getById(@PathVariable(value = "id") Integer id) {
    34.         return bookService.getById(id);
    35.     }
    36.  
    37.     @GetMapping("/{currentPage}/{pageSize}")
    38.     public IPage getPage(@PathVariable int currentPage, @PathVariable int pageSize){
    39.         IPage page = new Page(currentPage,pageSize);
    40.         return bookService.page(page);
    41.     }
    42.  
    43. }

    2、测试：

    表现层消息一致性处理

    返回数据类型不一致会给前端带来不便：

     单纯地封装数据又会造成误解，如数据为null时：

     故采用以下格式：

    优点：

    示例：

    1、设计表现层返回结果的模型类，用于后端与前端进行数据格式统一，也称为前后端数据协议：

    1. /*
    2.    统一表现层响应的数据返回值类型
    3.  */
    4. @Data
    5. @NoArgsConstructor
    6. @AllArgsConstructor
    7. public class R { //Result
    8.     private Boolean flag;
    9.     private Object data;
    10.  
    11.     public R(Boolean flag) {
    12.         this.flag = flag;
    13.     }
    14. }

    2、编写controller：

    1. /*
    2.    统一了返回值类型的正式版表现层
    3.  */
    4.  
    5. @RestController
    6. @RequestMapping("/books")
    7. public class BookController {
    8.     @Autowired
    9.     private IBookService bookService;
    10.  
    11.     @GetMapping
    12.     public R getAll() {
    13.         return new R(true,bookService.list());
    14.     }
    15.  
    16.     @PostMapping
    17.     public R save(@RequestBody Book book) { //@RequestBody:接收前端传递给后端的请求体中的数据
    18.         return new R(bookService.save(book));
    19.     }
    20.  
    21.     @PutMapping
    22.     public R update(@RequestBody Book book) {
    23.         return new R(bookService.updateById(book));
    24.     }
    25.  
    26.     @DeleteMapping("/{id}")
    27.     public R delete(@PathVariable(value = "id") Integer id) {
    28.         return new R(bookService.removeById(id));
    29.     }
    30.  
    31.     @GetMapping("/{id}")
    32.     public R getById(@PathVariable(value = "id") Integer id) {
    33.         return new R(true,bookService.getById(id));
    34.     }
    35.  
    36.     @GetMapping("/{currentPage}/{pageSize}")
    37.     public R getPage(@PathVariable int currentPage, @PathVariable int pageSize){
    38.         return new R(true,bookService.page(new Page(currentPage,pageSize)));
    39.     }
    40.  
    41. }

    3、测试：

     

     

    异常消息一致性处理

    1、使用注解@RestControllerAdvice定义SpringMVC异常处理器，异常处理器必须被扫描加载，否则无法生效；对异常消息进行统一处理，出现异常后返回指定类型：

    1. @RestControllerAdvice
    2. public class ProjectExceptionAdvice {
    3.  
    4.     //拦截所有的异常信息
    5.     @ExceptionHandler(Exception.class)
    6.     public R doException(Exception ex){
    7.         //记录日志
    8.         //通知运维
    9.         //通知开发
    10.         ex.printStackTrace(); //控制台仍然要显示异常
    11.         return new R(false,"服务器故障，请稍后再试！");
    12.     }
    13.  
    14. }

    2、修改表现层返回结果的模型类，封装出现异常后对应的信息：

    1. @Data
    2. @NoArgsConstructor
    3. @AllArgsConstructor
    4. public class R { //Result
    5.     private Boolean flag;
    6.     private Object data;
    7.     private String msg;
    8.  
    9.     public R(Boolean flag) {
    10.         this.flag = flag;
    11.     }
    12.  
    13.     public R(Boolean flag,Object data) {
    14.         this.flag = flag;
    15.         this.data = data;
    16.     }
    17.  
    18.     public R(Boolean flag,String msg) {
    19.         this.flag = flag;
    20.         this.msg = msg;
    21.     }
    22. }

    五、前端页面开发

    前后端分离结构设计中页面归属前端服务器，但本案例是但服务器结构，故将页面放在项目工程resources 目录下的 static 目录中，建议放置完后执行Maven的clean命令：

    页面html：

    1. html>
    2.  
    3. <html>
    4.  
    5. <head>
    6.  
    7.     
    8.  
    9.     <meta charset="utf-8">
    10.  
    11.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
    12.  
    13.     <title>SpringBoot整合SSM案例title>
    14.  
    15.     <meta content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no" name="viewport">
    16.  
    17.     
    18.  
    19.     <link rel="stylesheet" href="../plugins/elementui/index.css">
    20.  
    21.     <link rel="stylesheet" href="../plugins/font-awesome/css/font-awesome.min.css">
    22.  
    23.     <link rel="stylesheet" href="../css/style.css">
    24.  
    25. head>
    26.  
    27. <body class="hold-transition">
    28.  
    29. <div id="app">
    30.  
    31.     <div class="content-header">
    32.  
    33.         <h1>图书管理h1>
    34.  
    35.     div>
    36.  
    37.     <div class="app-container">
    38.  
    39.         <div class="box">
    40.  
    41.             <div class="filter-container">
    42.                 <el-input placeholder="图书类别" v-model="pagination.type" style="width: 200px;" class="filter-item">el-input>
    43.                 <el-input placeholder="图书名称" v-model="pagination.name" style="width: 200px;" class="filter-item">el-input>
    44.                 <el-input placeholder="图书描述" v-model="pagination.description" style="width: 200px;" class="filter-item">el-input>
    45.                 <el-button @click="getAll()" class="dalfBut">查询el-button>
    46.                 <el-button type="primary" class="butT" @click="handleCreate()">新建el-button>
    47.             div>
    48.  
    49.             <el-table size="small" current-row-key="id" :data="dataList" stripe highlight-current-row>
    50.  
    51.                 <el-table-column type="index" align="center" label="序号">el-table-column>
    52.  
    53.                 <el-table-column prop="type" label="图书类别" align="center">el-table-column>
    54.  
    55.                 <el-table-column prop="name" label="图书名称" align="center">el-table-column>
    56.  
    57.                 <el-table-column prop="description" label="描述" align="center">el-table-column>
    58.  
    59.                 <el-table-column label="操作" align="center">
    60.  
    61.                     <template slot-scope="scope">
    62.  
    63.                         <el-button type="primary" size="mini" @click="handleUpdate(scope.row)">编辑el-button>
    64.  
    65.                         <el-button type="danger" size="mini" @click="handleDelete(scope.row)">删除el-button>
    66.  
    67.                     template>
    68.  
    69.                 el-table-column>
    70.  
    71.             el-table>
    72.  
    73.             
    74.             <div class="pagination-container">
    75.                 
    76.                 <el-pagination
    77.                         class="pagiantion"
    78.  
    79.                         layout="total, prev, pager, next, jumper"
    80.  
    81.                         @current-change="handleCurrentChange"
    82.  
    83.                         :current-page.sync="pagination.currentPage"
    84.  
    85.                         :page-size="pagination.pageSize"
    86.  
    87.                         :total="pagination.total">
    88.  
    89.                 el-pagination>
    90.  
    91.             div>
    92.  
    93.             
    94.  
    95.             <div class="add-form">
    96.  
    97.                 <el-dialog title="新增图书" :visible.sync="dialogFormVisible">
    98.  
    99.                     <el-form ref="dataAddForm" :model="formData" :rules="rules" label-position="right" label-width="100px">
    100.  
    101.                         <el-row>
    102.  
    103.                             <el-col :span="12">
    104.  
    105.                                 <el-form-item label="图书类别" prop="type">
    106.  
    107.                                     <el-input v-model="formData.type"/>
    108.  
    109.                                 el-form-item>
    110.  
    111.                             el-col>
    112.  
    113.                             <el-col :span="12">
    114.  
    115.                                 <el-form-item label="图书名称" prop="name">
    116.  
    117.                                     <el-input v-model="formData.name"/>
    118.  
    119.                                 el-form-item>
    120.  
    121.                             el-col>
    122.  
    123.                         el-row>
    124.  
    125.  
    126.                         <el-row>
    127.  
    128.                             <el-col :span="24">
    129.  
    130.                                 <el-form-item label="描述">
    131.  
    132.                                     <el-input v-model="formData.description" type="textarea">el-input>
    133.  
    134.                                 el-form-item>
    135.  
    136.                             el-col>
    137.  
    138.                         el-row>
    139.  
    140.                     el-form>
    141.  
    142.                     <div slot="footer" class="dialog-footer">
    143.  
    144.                         <el-button @click="cancel()">取消el-button>
    145.  
    146.                         <el-button type="primary" @click="handleAdd()">确定el-button>
    147.  
    148.                     div>
    149.  
    150.                 el-dialog>
    151.  
    152.             div>
    153.  
    154.             
    155.  
    156.             <div class="add-form">
    157.  
    158.                 <el-dialog title="编辑检查项" :visible.sync="dialogFormVisible4Edit">
    159.  
    160.                     <el-form ref="dataEditForm" :model="formData" :rules="rules" label-position="right" label-width="100px">
    161.  
    162.                         <el-row>
    163.  
    164.                             <el-col :span="12">
    165.  
    166.                                 <el-form-item label="图书类别" prop="type">
    167.  
    168.                                     <el-input v-model="formData.type"/>
    169.  
    170.                                 el-form-item>
    171.  
    172.                             el-col>
    173.  
    174.                             <el-col :span="12">
    175.  
    176.                                 <el-form-item label="图书名称" prop="name">
    177.  
    178.                                     <el-input v-model="formData.name"/>
    179.  
    180.                                 el-form-item>
    181.  
    182.                             el-col>
    183.  
    184.                         el-row>
    185.  
    186.                         <el-row>
    187.  
    188.                             <el-col :span="24">
    189.  
    190.                                 <el-form-item label="描述">
    191.  
    192.                                     <el-input v-model="formData.description" type="textarea">el-input>
    193.  
    194.                                 el-form-item>
    195.  
    196.                             el-col>
    197.  
    198.                         el-row>
    199.  
    200.                     el-form>
    201.  
    202.                     <div slot="footer" class="dialog-footer">
    203.  
    204.                         <el-button @click="cancel()">取消el-button>
    205.  
    206.                         <el-button type="primary" @click="handleEdit()">确定el-button>
    207.  
    208.                     div>
    209.  
    210.                 el-dialog>
    211.  
    212.             div>
    213.  
    214.         div>
    215.  
    216.     div>
    217.  
    218. div>
    219.  
    220. body>
    221.  
    223.  
    224. <script src="../js/vue.js">script>
    225.  
    226. <script src="../plugins/elementui/index.js">script>
    227.  
    228. <script type="text/javascript" src="../js/jquery.min.js">script>
    229.  
    230. <script src="../js/axios-0.18.0.js">script>
    231.  
    232. <script>
    233.     var vue = new Vue({
    234.         el: '#app',
    235.         data:{
    236.             dataList: [],//当前页要展示的列表数据
    237.             dialogFormVisible: false,//添加表单是否可见
    238.             dialogFormVisible4Edit:false,//编辑表单是否可见
    239.             formData: {},//表单数据
    240.             rules: {//校验规则
    241.                 type: [{ required: true, message: '图书类别为必填项', trigger: 'blur' }],
    242.                 name: [{ required: true, message: '图书名称为必填项', trigger: 'blur' }]
    243.             },
    244.             pagination: {//分页相关模型数据
    245.                 currentPage: 1,//当前页码
    246.                 pageSize:10,//每页显示的记录数
    247.                 total:0,//总记录数
    248.                 //条件查询
    249.                 type: "",
    250.                 name: "",
    251.                 description: ""
    252.             },
    253.         },
    254.  
    255.  
    256.         //钩子函数，VUE对象初始化完成后自动执行，效果为每次打开页面都会执行该操作
    257.         created() {
    258.             this.getAll();
    259.         },
    260.  
    261.         methods: {
    262.             // //列表
    263.             // getAll() {
    264.             //     //发送异步请求
    265.             //     axios.get("/books").then((res)=>{
    266.             //         // console.log(res.data);
    267.             //         this.dataList = res.data.data;
    268.             //     });
    269.             // },
    270.  
    271.             //分页查询
    272.             getAll() {
    273.                 //组织条件查询参数，拼接url请求地址
    274.                 param = "?type="+this.pagination.type;
    275.                 param +="&name="+this.pagination.name;
    276.                 param +="&description="+this.pagination.description;
    277.  
    278.                 //发送异步请求
    279.                 axios.get("/books/"+this.pagination.currentPage+"/"+this.pagination.pageSize+param).then((res)=>{
    280.                     this.pagination.pageSize = res.data.data.size;
    281.                     this.pagination.currentPage = res.data.data.current;
    282.                     this.pagination.total = res.data.data.total;
    283.  
    284.                     this.dataList = res.data.data.records;
    285.                 });
    286.             },
    287.  
    288.             //切换页码
    289.             handleCurrentChange(currentPage) {
    290.                 //修改页码值为当前选中的页码值
    291.                 this.pagination.currentPage = currentPage;
    292.                 //执行查询
    293.                 this.getAll();
    294.             },
    295.  
    296.             //弹出添加窗口
    297.             handleCreate() {
    298.                 this.dialogFormVisible = true;
    299.                 this.resetForm(); //重置表单
    300.             },
    301.  
    302.             //重置表单
    303.             resetForm() {
    304.                 this.formData = {};
    305.             },
    306.  
    307.             //添加
    308.             handleAdd () {
    309.                 axios.post("/books",this.formData).then((res)=>{
    310.                     //判断当前操作是否成功
    311.                     if(res.data.flag){
    312.                         //1.关闭弹层
    313.                         this.dialogFormVisible = false;
    314.                         this.$message.success(res.data.msg);
    315.                     }else{
    316.                         this.$message.error(res.data.msg);
    317.                     }
    318.                 }).finally(()=>{
    319.                     //2.重新加载数据
    320.                     this.getAll();
    321.                 });
    322.             },
    323.  
    324.             //取消
    325.             cancel(){
    326.                 this.dialogFormVisible = false;
    327.                 this.dialogFormVisible4Edit = false;
    328.                 this.$message.info("当前操作取消");
    329.             },
    330.  
    331.             // 删除
    332.             handleDelete(row) {
    333.                 this.$confirm("此操作永久删除当前信息，是否继续？","提示",{type:"info"}).then(()=>{
    334.                     axios.delete("/books/"+row.id).then((res)=>{
    335.                         if(res.data.flag){
    336.                             this.$message.success("删除成功");
    337.                         }else{
    338.                             this.$message.error("数据同步失败，自动刷新");
    339.                         }
    340.                     }).finally(()=>{
    341.                         //2.重新加载数据
    342.                         this.getAll();
    343.                     });
    344.                 }).catch(()=>{
    345.                     this.$message.info("取消操作");
    346.                 });
    347.             },
    348.  
    349.             //弹出编辑窗口
    350.             handleUpdate(row) {
    351.                 axios.get("/books/"+row.id).then((res)=>{
    352.                     if(res.data.flag && res.data.data != null ){
    353.                         this.dialogFormVisible4Edit = true;
    354.                         this.formData = res.data.data;
    355.                     }else{
    356.                         this.$message.error("数据同步失败，自动刷新");
    357.                     }
    358.                 }).finally(()=>{
    359.                     //2.重新加载数据
    360.                     this.getAll();
    361.                 });
    362.             },
    363.  
    364.             //修改
    365.             handleEdit() {
    366.                 axios.put("/books",this.formData).then((res)=>{
    367.                     //判断当前操作是否成功
    368.                     if(res.data.flag){
    369.                         //1.关闭弹层
    370.                         this.dialogFormVisible4Edit = false;
    371.                         this.$message.success("修改成功");
    372.                     }else{
    373.                         this.$message.error("修改失败");
    374.                     }
    375.                 }).finally(()=>{
    376.                     //2.重新加载数据
    377.                     this.getAll();
    378.                 });
    379.             },
    380.  
    381.         }
    382.     })
    383.  
    384. script>
    385.  
    386. html>

    整合需求后的controller：

    1. @RestController
    2. @RequestMapping("/books")
    3. public class BookController {
    4.     @Autowired
    5.     private IBookService bookService;
    6.  
    7.     @GetMapping
    8.     public R getAll() {
    9.         return new R(true,bookService.list());
    10.     }
    11.  
    12.     @PostMapping
    13.     public R save(@RequestBody Book book) throws IOException { //@RequestBody:接收前端传递给后端的请求体中的数据
    14.         //测试异常消息一致性处理
    15.         /*if(book.getName().equals("123")) {
    16.             throw new IOException();
    17.         }*/
    18.  
    19.         Boolean flag = bookService.save(book);
    20.         return new R(flag,flag ? "添加成功" : "添加失败");
    21.     }
    22.  
    23.     @PutMapping
    24.     public R update(@RequestBody Book book) {
    25.         return new R(bookService.updateById(book));
    26.     }
    27.  
    28.     @DeleteMapping("/{id}")
    29.     public R delete(@PathVariable(value = "id") Integer id) {
    30.         return new R(bookService.removeById(id));
    31.     }
    32.  
    33.     @GetMapping("/{id}")
    34.     public R getById(@PathVariable(value = "id") Integer id) {
    35.         return new R(true,bookService.getById(id));
    36.     }
    37.  
    38.     @GetMapping("/{currentPage}/{pageSize}")
    39.     public R getPage(@PathVariable int currentPage, @PathVariable int pageSize,Book book){
    40.         IPage page = bookService.getPage(currentPage, pageSize,book);
    41.         //如果当前页码值大于了总页码值，那么重新执行查询操作，使用最大页码值作为当前页码值
    42.         if( currentPage > page.getPages()){
    43.             page = bookService.getPage((int)page.getPages(), pageSize,book);
    44.         }
    45.         return new R(true, page);
    46.     }
    47.  
    48. }

    效果：

    六、总结

    至此，SpringBoot基础篇学习完毕。

  • 相关阅读:
    vscode - 环境准备 - 修改缓存路径
    基于SqlSugar的开发框架循序渐进介绍（20）-- 在基于UniApp+Vue的移动端实现多条件查询的处理
    003. 电话号码的字母组合——回溯算法
    作为物联网技术最重要的数据采集入口，传感器将迎来巨大的发展良机？
    ARM异常处理(4)：SVC和PendSV的作用详解
    Spring Boot之AJAX异步发送帖子
    公有云攻击案例
    简单总结下近期遇到的网络概念gcp、anycast IP、vlan
    insertAdjacentHTML() 作用
    使用IntelliJ Idea必备的插件！
  • 原文地址：https://blog.csdn.net/qq_57389269/article/details/126149458