springboot 整合 mybatis 以及 idea 安装 MybatisCodeHelper 插件

最新推荐文章于 2025-03-19 15:23:26 发布

路克森

最新推荐文章于 2025-03-19 15:23:26 发布

阅读量915

点赞数

分类专栏：整合问题案例文章标签： xml mybatis springboot 插件 idea

本文链接：https://blog.youkuaiyun.com/qq_39057639/article/details/102468254

版权

本文介绍了如何在SpringBoot 2.x项目中集成Mybatis，并分享了如何安装和使用MybatisCodeHelperPro插件以自动生成Mapper和服务层代码。提供了数据库配置、Mapper配置、插件安装及破解方法的详细步骤，帮助开发者提高效率。

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

博主个人主页
(非博主博文)以下教程不生效移步至此处

前言

今天我们来说一下在springboot2.x版本中如何集成mybatis吧并且在分享一个比较好用的idea的插件咯
MybatisCodeHelperPro 这个插件可以很方便的帮助我们生成mapper和service文件和基础增删改查代码

破解包获取地址

链接：https://pan.baidu.com/s/1ZpEFUrkQhG4H6vchTdr-Ww
提取码：7mdy

本文章DEMO获取地址

链接：https://pan.baidu.com/s/1oiS4ykjlDTZHzfAqEwsL7A
提取码：oaeh

开发

首先我们需要创建对应的数据库 test

这里是sql文件内容有点多拿到数据库执行一下即可

/*
 Navicat Premium Data Transfer

 Source Server         : MYSQL
 Source Server Type    : MySQL
 Source Server Version : 50724
 Source Host           : localhost:3307
 Source Schema         : test

 Target Server Type    : MySQL
 Target Server Version : 50724
 File Encoding         : 65001

 Date: 09/10/2019 23:41:29
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for aaa
-- ----------------------------
DROP TABLE IF EXISTS `aaa`;
CREATE TABLE `aaa`  (
  `id` int(10) NOT NULL,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  FULLTEXT INDEX `body`(`body`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of aaa
-- ----------------------------
INSERT INTO `aaa` VALUES (1, 'desc datasoucr manager is very good', 'desc datasoucr manager is very good');
INSERT INTO `aaa` VALUES (2, 'desc datasoucr manager is very good', 'Spring is nice framework');
INSERT INTO `aaa` VALUES (3, 'desc datasoucr manager is very good', 'Mysql is Datasource');
INSERT INTO `aaa` VALUES (4, 'asdasdadad', 'datamanager');

-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product`  (
  `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号',
  `product_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品编号',
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品名称',
  `product_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品图片地址',
  `position_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '职位Id',
  `person_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '员工Id',
  `creator_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建人',
  `create_time` decimal(32, 0) NULL DEFAULT NULL COMMENT '创建时间',
  `modifier_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '修改人',
  `modify_time` decimal(32, 0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of product
-- ----------------------------
INSERT INTO `product` VALUES ('6deb6cc4-c3ba-4d42-a899-7ee1240f5a94', 'F0001', '李经理本人', '/upload/product/20190530/64171851281046.png', '4adf04cddce81b3a843c1430b419f55a', 'fc3e54a8e09ba0df7a2f6a28edef5cc0', '3b8bc77e0f5115aa9d0682223b24a666', 1559198825492, '3b8bc77e0f5115aa9d0682223b24a666', 1559198943674);
INSERT INTO `product` VALUES ('7b236c98-cfd4-4f6d-9888-ecd4a207d77f', 'H0001', '小红添的', NULL, '8d1c00109a504078ac449a143dc42f9b', 'e87a53202ec92097221e3ac4758657a4', '3689a8e52115a724522cf9b3e6f5c921', 1559125165725, '3689a8e52115a724522cf9b3e6f5c921', 1559125165723);
INSERT INTO `product` VALUES ('91519aac-cdd7-43cb-a0f4-60f1faa7cac0', 'F1111', '小白又添的', NULL, '7df9a772b91f445f371244363ad888c7', '72d6dda06fda02896a765e3e4193160d', '3656b5b448297ed1cdf656030099661b', 1559134559262, '3656b5b448297ed1cdf656030099661b', 1559134559259);
INSERT INTO `product` VALUES ('9f20de37-5ff8-41cd-87ec-086ede91519f', 'F0001', '小白填的', NULL, '7df9a772b91f445f371244363ad888c7', '72d6dda06fda02896a765e3e4193160d', '3656b5b448297ed1cdf656030099661b', 1559125030660, '3656b5b448297ed1cdf656030099661b', 1559125090660);
INSERT INTO `product` VALUES ('a3a1ebfa-e68a-4769-a070-eede33a23037'

最低0.47元/天解锁文章