springboot+mybatis+mysql（入门练习-超详细）

一个简单的springboot项目

所以决定记录一下

postman测试CRUD的结果图

postman测试数据

新增
http://localhost:8080/user/add
{
	"username":"姓名02",
	"password":"7802",
	"address":"20220729"
}

修改
http://localhost:8080/user/update
{
	"id":"fc8f671db3514bf38b6ce10f8807ef89",
	"username":"66",
	"password":"667",
	"address":"6678"
}

删除
http://localhost:8080/user/delete
{
	"id":"c4b9acb1a5fc4955b4b1fb003184168c"
}

查询
http://localhost:8080/user/selectUserByid
{
	"id":"fc8f671db3514bf38b6ce10f8807ef89"
}

后端代码结构图 

 必读文件README.md

# demo

#### 介绍
SpringBoot整合MyBatis+mysql增删改查简单案例

#### 软件架构
软件架构说明


#### 需要安装的软件

1.  安装 mysql
2.  安装 idea
3.  安装 postman


#### 操作步骤

1.  在idea中导入demo项目
2.  在mysql数据库中新建库demo,在demo库中导入user.sql,已放在项目下的user.sql中
3.  在postman中增加测试接口以及请求参数，已放在项目下的postman数据中
4.  运行项目，执行postman进行测试
5.  postman的数据只供开始测试用，熟悉后参数的值可随意修改

mysql数据库

sql文件内容

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('00846f43ec564673a7fd600d01dd681e', '1', '12', '123');
INSERT INTO `user` VALUES ('15ea8ddc96d44b75b59fc483f0ed5ada', '7', '78', '789');
INSERT INTO `user` VALUES ('5c104ff8a4cd43b8a5f09e69e7aa1b4d', '5', '56', '567');
INSERT INTO `user` VALUES ('76d8781486f744c9aa1a8ce5e137fed3', '7', '78', '20220729');
INSERT INTO `user` VALUES ('7b14c4cf691b472f9a19e1431aac6c69', '7788', '78', '20220729');
INSERT INTO `user` VALUES ('847f5904e02141898dcb49f4e58e977c', '2', '23', '234');
INSERT INTO `user` VALUES ('900c751a4d6c4b148e7cc6a35d8fcb3f', '4', '45', '456');
INSERT INTO `user` VALUES ('92050a5c670a4996bf2085439188e2ff', '3', '34', '345');
INSERT INTO `user` VALUES ('997066a87dd94a799761a41d6ff816d2', '姓名02', '7802', '20220729');
INSERT INTO `user` VALUES ('a3b6257fca434473805f75cc87ab4eb1', '7', '78', '789');
INSERT INTO `user` VALUES ('fc8f671db3514bf38b6ce10f8807ef89', '66', '667', '6678');

SET FOREIGN_KEY_CHECKS = 1;

下载地址：
springboot+mybatis+mysql+postman（适合新手）-Java文档类资源-CSDN下载