SpringBoot+Mbatis项目实战（手把手教学）

久九酒氿

已于 2022-10-13 17:04:05 修改

阅读量233

点赞数 1

于 2022-10-13 16:54:42 首次发布

本文链接：https://blog.csdn.net/m0_61841555/article/details/127302144

版权

SpringBoot+Mbatis+MySQL 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1.新建一个项目，如下图

2. 输入my，勾选MyBatis Framework与MySQL Driver，继续输入spring，勾选Spring Web

3.出现如下目录则成功

4.在MySql任意一个数据库中创建user表格（记住数据库名，后面要用到）

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` int(11) NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '张三', 82, '男');
INSERT INTO `user` VALUES (2, '李四', 35, '男');
INSERT INTO `user` VALUES (3, '王五', 56, '男');
INSERT INTO `user` VALUES (4, '赵六', 13, '男');

SET FOREIGN_KEY_CHECKS = 1;