新手入门2------springboot项目集成mybatis操作数据库简单案例

补充上文说。。。。。。。。

一、准备环境

0、确保有mysql环境，然后设计数据库（我用的是mysql5.7）

表结构如下：

复制下列sql，运行导入数据即可

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for l_depart_info
-- ----------------------------
DROP TABLE IF EXISTS `l_depart_info`;
CREATE TABLE `l_depart_info`  (
  `object_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门id',
  `depart_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `parent_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父级部门',
  PRIMARY KEY (`object_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of l_depart_info
-- ----------------------------
INSERT INTO `l_depart_info` VALUES ('1', 'wy集团', NULL);
INSERT INTO `l_depart_info` VALUES ('1001', '人事行政部', '1');
INSERT INTO `l_depart_info` VALUES ('1002', '商务部', '1');
INSERT INTO `l_depart_info` VALUES ('2001', '研发二组', '1005');

SET FOREIGN_KEY_CHECKS = 1;

完成应该是这样的

 

1、修改pom.xml文件，增加以下配置

        <!--配置mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artif