mybatis的使用及源码分析(十三) 测试mybatis-plus使用AR模式

最新推荐文章于 2024-01-05 16:40:15 发布

码农-文若书生

最新推荐文章于 2024-01-05 16:40:15 发布

阅读量189

点赞数

CC 4.0 BY-SA版权

分类专栏： mybatis mybatis-plus 文章标签： mybatis mybatisplus ar plus的AR模式

本文链接：https://blog.csdn.net/u011943534/article/details/115496214

mybatis 同时被 2 个专栏收录

20 篇文章

订阅专栏

mybatis-plus

6 篇文章

订阅专栏

本文介绍了如何使用Mybatis-Plus的ActiveRecord (AR) 模式进行数据库操作，包括创建表结构、定义实体类继承Model、编写Mapper接口，并通过Controller实现增删改查(CRUD)操作，展示了从模型到实际应用的完整流程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

AR即为ActiveRecord,是一种领域模型模式，一个模型类对应一个表。通过实体类对象直接进行表的CRUD操作。

1、导入测试的一个表

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for test_mp_ar
-- ----------------------------
DROP TABLE IF EXISTS `test_mp_ar`;
CREATE TABLE `test_mp_ar`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

2、定义实体继承Model

/**
 * 测试mybatis-plus AR模式
 *
 * @author zhuquanwen
 * @vesion 1.0
 * @date 2021/4/7 20:54
 * @since jdk1.8
 */
@Data
public class TestMpAr extends Model<TestMpAr> {
    @TableId(type = IdType.AUTO)
    private Integer id;
    private String name;
}

3、定义Mapper
必须定义Mapper,否则不能使用AR模式

/**
 *
 * @author zhuquanwen
 * @vesion 1.0
 * @date 2021/4/7 20:56
 * @since jdk1.8
 */
@Repository
@Mapper
public interface TestMpArMapper extends BaseMapper<TestMpAr> {
}

4、测试CURD

/**
 *
 * @author zhuquanwen
 * @vesion 1.0
 * @date 2021/4/7 20:57
 * @since jdk1.8
 */
@RequestMapping("/test/mp/ar")
@RestController
public class TestMapArController extends BaseController {

    @PostMapping("/insert")
    public ResponseEntity insert() {
        ResponseEntity response = getResponse();
        TestMpAr testMpAr = new TestMpAr();
        testMpAr.setName("test1");
        testMpAr.insert();
        return response;
    }

    @PutMapping("/update")
    public ResponseEntity update() {
        ResponseEntity response = getResponse();
        TestMpAr testMpAr = new TestMpAr();
        testMpAr = testMpAr.selectById(1);
        testMpAr.setName("test111");
        testMpAr.updateById();
        return response;
    }

    @GetMapping("/search")
    public ResponseEntity search() {
        ResponseEntity response = getResponse();
        TestMpAr testMpAr = new TestMpAr();
        QueryWrapper<TestMpAr> queryWrapper = new QueryWrapper<>();
        queryWrapper.like("name", "test");
        List<TestMpAr> testMpArs = testMpAr.selectList(queryWrapper);
        response.setValue(testMpArs);
        return response;
    }

    @DeleteMapping("/delete")
    public ResponseEntity delete() {
        ResponseEntity response = getResponse();
        TestMpAr testMpAr = new TestMpAr();
        testMpAr.setId(1);
        testMpAr.deleteById();
        return response;
    }

}