IDEA好用插件：MybatisX快速生成接口实体类mapper.xml映射文件

逃离我推掉我的手 2024-03-25 17:07 46阅读 0赞

**目录**

1、在Idea中找到下载插件，Install，重启Idea

2、一个测试java文件，里面有com包

3、在Idea中添加数据库 --------以Oracle数据库为例

4、快速生成entity-service-mapper方法

5、查看生成的代码

6、自动生成（增删查改）在TestMapper中快速编写代码

--------------------

#### 1、在Idea中找到下载插件，Install，重启Idea ####

file-->settings -->Plugins

![9ee17a7f5a6d4f3fbda0c4ec4c864e1f.png][]

#### 2、一个测试java文件，里面有com包 ####

![c18d7021bc0d4032a6484b68acdc0d54.png][]

#### 3、在Idea中添加数据库 --------以Oracle数据库为例 ####

![f35dbb6c67044802a718a2082820f1f1.png][]

下一步：按照红色表示的地方配置，其他的地方不用改变

![09cab97c4ca140a3923131e3bad37414.png][]

测试ok后，点击Apply--OK就加好了

#### 4、快速生成entity-service-mapper方法 ####

第一步：以TEST表为例,右键Test表，选择MybatisX-Generator

![1b22a9258cfb4e1ebc59974c900c0a46.png][]

第二步：进入一下页面，填写信息

![e899d0dbcf8b4c1eb5170f6ea21fff74.png][]

第三步：点击Next后，检查路径，文件名，基础选项配置![e82e9be879a34d7d8bd50a48dcf58963.png][]

下一步：点击Finish，就可以了

生成的包名，接口，实体类，实现类为：

![1ac9f3db66ac4f079f196eb45c37bcd1.png][]

#### 5、查看生成的代码 ####

entity包下的Test实体类

package com.entity;
    
    import com.baomidou.mybatisplus.annotation.TableField;
    import com.baomidou.mybatisplus.annotation.TableName;
    import java.io.Serializable;
    import lombok.Data;
    
    /**
     * 
     * @TableName TEST
     */
    @TableName(value ="TEST")
    @Data
    public class Test implements Serializable {
        /**
         * 
         */
        private Long id;
    
        /**
         * 
         */
        private String jan;
    
        /**
         * 
         */
        private String feb;
    
        /**
         * 
         */
        private String mar;
    
        /**
         * 
         */
        private String apr;
    
        /**
         * 
         */
        private String may;
    
        /**
         * 
         */
        private String jun;
    
        /**
         * 
         */
        private String jul;
    
        /**
         * 
         */
        private String aug;
    
        /**
         * 
         */
        private String sep;
    
        /**
         * 
         */
        private String oct;
    
        /**
         * 
         */
        private String nov;
    
        /**
         * 
         */
        private String dec;
    
        @TableField(exist = false)
        private static final long serialVersionUID = 1L;
    }

mapper包下的TestMapper

package com.mapper;
    
    import com.entity.Test;
    import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    
    /**
     * @Entity com.entity.Test
     */
    public interface TestMapper extends BaseMapper<Test> {
    
    }

service包下的TestService

package com.service;
    
    import com.entity.Test;
    import com.baomidou.mybatisplus.extension.service.IService;
    
    /**
     *
     */
    public interface TestService extends IService<Test> {
    
    }

service.impl 包下的TestServiceImpl

package com.service.impl;
    
    import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    import com.entity.Test;
    import com.service.TestService;
    import com.mapper.TestMapper;
    import org.springframework.stereotype.Service;
    
    /**
     *
     */
    @Service
    public class TestServiceImpl extends ServiceImpl<TestMapper, Test> implements TestService{
    
    }

mapper配置文件TestMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper
            PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.mapper.TestMapper">
    
        <resultMap id="BaseResultMap" type="com.entity.Test">
                <result property="id" column="ID" jdbcType="DECIMAL"/>
                <result property="jan" column="JAN" jdbcType="VARCHAR"/>
                <result property="feb" column="FEB" jdbcType="VARCHAR"/>
                <result property="mar" column="MAR" jdbcType="VARCHAR"/>
                <result property="apr" column="APR" jdbcType="VARCHAR"/>
                <result property="may" column="MAY" jdbcType="VARCHAR"/>
                <result property="jun" column="JUN" jdbcType="VARCHAR"/>
                <result property="jul" column="JUL" jdbcType="VARCHAR"/>
                <result property="aug" column="AUG" jdbcType="VARCHAR"/>
                <result property="sep" column="SEP" jdbcType="VARCHAR"/>
                <result property="oct" column="OCT" jdbcType="VARCHAR"/>
                <result property="nov" column="NOV" jdbcType="VARCHAR"/>
                <result property="dec" column="DEC" jdbcType="VARCHAR"/>
        </resultMap>
    
        <sql id="Base_Column_List">
            ID,JAN,FEB,
            MAR,APR,MAY,
            JUN,JUL,AUG,
            SEP,OCT,NOV,
            DEC
        </sql>
    </mapper>

#### 6、自动生成（增删查改）在TestMapper中快速编写代码 ####

自动生成查询-----写select关键字，

自动生成新增-----写insert关键字

自动生成修改-----写update关键字

自动生成删除-----写del关键字

自动带出后面的操作，例如，根据id查询，根据Apr查询，后面也会有根据哪个字段排序等

![bb2211d31eea4f37b2ca45daea960da9.png][]

写完想要的接口后，接口名右键选择Show Context Actions

![5409a44ed6134e2c844019b1c8dbda37.png][]

进入后，选择第一个

![b5cd21142199433b9371ad2ad274776c.png][]

自动生成接口带参数

![600864c974cc4cc58fd956a8d6f53189.png][]

TestMapper.xml

![4ce4803d92f4451eab47ab38de4dad11.png][]

[9ee17a7f5a6d4f3fbda0c4ec4c864e1f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/7255876111cd4ca4a9912bb85e3bdcdc.png
[c18d7021bc0d4032a6484b68acdc0d54.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/9089328f786a4d398f812294e7d22ad2.png
[f35dbb6c67044802a718a2082820f1f1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/f88a7f63816944b9ab4a334cf6dce779.png
[09cab97c4ca140a3923131e3bad37414.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/a879e2b861c14e7dafd4ab4754649097.png
[1b22a9258cfb4e1ebc59974c900c0a46.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/24d7c0b5e9604862a10a7c66d31a2674.png
[e899d0dbcf8b4c1eb5170f6ea21fff74.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/fd779d3f44534f4490cb79d99726727d.png
[e82e9be879a34d7d8bd50a48dcf58963.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/eb29744763df42a0962bce8b486aa622.png
[1ac9f3db66ac4f079f196eb45c37bcd1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/f859c862f4604fd49d4ed0c951a9f9c7.png
[bb2211d31eea4f37b2ca45daea960da9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/76cad42295504a9ea8a5ffff4efed1c5.png
[5409a44ed6134e2c844019b1c8dbda37.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/03f0658ad1504743bd44d72004b29c58.png
[b5cd21142199433b9371ad2ad274776c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/0d02fff116474706b446a454e7fae9c9.png
[600864c974cc4cc58fd956a8d6f53189.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/e10e15437cd94056844eb3c4e86c6d87.png
[4ce4803d92f4451eab47ab38de4dad11.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/3bc4fefbf4624aa8b081b49d155f6907.png