Springboot | 基于Rouyi后端单表user的CURD 功能代码和测试

CSMD介绍

CSMD：Controller、Service、Mapper[含Java 和xml]、Domain

创建sql表并添加相应记录

SET NAMES utf8mb4;  
SET FOREIGN_KEY_CHECKS = 0;  
  
-- ----------------------------  
-- Table structure for user  
-- ----------------------------  
DROP TABLE IF EXISTS `user`;  
CREATE TABLE `user`  (  
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,  
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,  
  `age` int NULL DEFAULT NULL,  
  `sex` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,  
  `create_time` datetime NULL DEFAULT NULL,  
  PRIMARY KEY (`id`) USING BTREE  
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;  
  
-- ----------------------------  
-- Records of user  
-- ----------------------------  
INSERT INTO `user` VALUES (1, 'zhangsan', 18, '1', '2023-10-22 10:49:19');  
INSERT INTO `user` VALUES (2, 'wangwu', 19, '1', '2023-10-29 10:49:55');  
  
SET FOREIGN_KEY_CHECKS = 1;

添加CSMD的相关文件

• C：在ruoyi-admin的Controller文件夹下放入HelloController
• S：在ruoyi-system的service下放入UserService
• M：在ruoyi-system的mapper，mapper.system下放入UserMapper,UserMapper.xml
• D：在ruoyi-system的domain放入User

代码内容参考：https://blog.youkuaiyun.com/Tuan_Better/article/details/133974622?spm=1001.2014.3001.5501

屏蔽新加接口安全防护策略

在SecurityConfig.java文件中configure方法下，添加以下内容

// 屏蔽自己写的接口安全策略  
.antMatchers("/hello").anonymous()  
.antMatchers("/hello/*").anonymous()

Apifox测试接口

测试CRUD接口