Mybatis-Generator 使用教程:一键自动完成增删改查

柔光的暖阳◎ 2023-02-28 04:20 3阅读 0赞

**Mybatis-Generator 使用教程**

项目环境：

JDK8+postgresql11+IDEA+MAVEN+SPRINGBOOT

偷懒，直接创建springboot项目mybatis-generator-demo

1、配置依赖

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.3.1.RELEASE</version>
            <relativePath/> 
        </parent>
        <groupId>com.daodao</groupId>
        <artifactId>mybatis-generator-demo</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>mybatis-generator-demo</name>
        <description>Demo project for Spring Boot</description>
    
        <properties>
            <java.version>1.8</java.version>
            <mbg.version>1.3.7</mbg.version>
            
            <targetJavaProject>${basedir}/src/main/java</targetJavaProject>
            <targetMapperPackage>com.daodao.mybatisgeneratordemo.dao</targetMapperPackage>
            <targetModelPackage>com.daodao.mybatisgeneratordemo.pojo</targetModelPackage>
            
            <targetResourcesProject>${basedir}/src/main/resource</targetResourcesProject>
            <targetXMLPackage>mapper</targetXMLPackage>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.3</version>
            </dependency>
    
            <dependency>
                <groupId>org.postgresql</groupId>
                <artifactId>postgresql</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
                <exclusions>
                    <exclusion>
                        <groupId>org.junit.vintage</groupId>
                        <artifactId>junit-vintage-engine</artifactId>
                    </exclusion>
                </exclusions>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
                <plugin>
                    
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>${mbg.version}</version>
                    <configuration>
                        
                        <verbose>true</verbose>
                        
                        <configurationFile>${basedir}/src/main/resources/generatorConfig.xml</configurationFile>
                        <overwrite>true</overwrite>
                        <verbose>true</verbose>
                    </configuration>
                    <dependencies>
                        <dependency>
                            
                            <groupId>org.postgresql</groupId>
                            <artifactId>postgresql</artifactId>
                            <version>42.2.14</version>
                        </dependency>
                    </dependencies>
                </plugin>
            </plugins>
        </build>
    </project>

2、配置数据库

server.port=8080
    #配置数据库信息
    spring.datasource.driver-class-name=org.postgresql.Driver
    spring.datasource.url=jdbc:postgresql://112.124.16.77:5432/postgres
    spring.datasource.username=postgres
    spring.datasource.password=密码
    
    #配置mybatis
    mybatis.mapper-locations=classpath:mapper/*.xml

3、配置代码生成器文件

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
            PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    <generatorConfiguration>
        
        <properties resource="application.properties"/>
        
        <classPathEntry location="D:\maven\Repository\org\postgresql\postgresql\42.2.14\postgresql-42.2.14.jar"/>
        <context id="Postgresql" targetRuntime="MyBatis3Simple" defaultModelType="flat">
            
            <property name="autoDelimitKeywords" value="true"/>
            
            <property name="beginningDelimiter" value="`"/>
            <property name="endingDelimiter" value="`"/>
    
            <commentGenerator>
                
                <property name="suppressAllComments" value="true"/>
                
                <property name="suppressDate" value="true"/>
            </commentGenerator>
    
            <jdbcConnection driverClass="${spring.datasource.driver-class-name}"
                            connectionURL="${spring.datasource.url}"
                            userId="${spring.datasource.username}"
                            password="${spring.datasource.password}">
            </jdbcConnection>
    
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="${targetModelPackage}" targetProject="${targetJavaProject}"/>
            
            <sqlMapGenerator targetPackage="${targetXMLPackage}" targetProject="${targetResourcesProject}"/>
            
            <javaClientGenerator targetPackage="${targetMapperPackage}" targetProject="${targetJavaProject}"
                                 type="XMLMAPPER"/>
            
            <table tableName="teacher">
                
                <property name="useActualColumnNames" value="false"/>
            </table>
        </context>
    </generatorConfiguration>

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-pyMSdqCo-1595170652342)(C:\\Users\\刀刀和阳\\AppData\\Roaming\\Typora\\typora-user-images\\image-20200719222755308.png)\]][img-pyMSdqCo-1595170652342_C_Users_AppData_Roaming_Typora_typora-user-images_image-20200719222755308.png]

点击运行插件即可。

看一下效果：

//实体类
    package com.daodao.mybatisgeneratordemo.pojo;
    
    public class Teacher {
        
        private String guid;
    
        private String name;
    
        private Long age;
    
        private Long salary;
    
        private Integer classId;
    
        public String getGuid() {
        
            return guid;
        }
    
        public void setGuid(String guid) {
        
            this.guid = guid;
        }
    
        public String getName() {
        
            return name;
        }
    
        public void setName(String name) {
        
            this.name = name;
        }
    
        public long getAge() {
        
            return age;
        }
    
        public void setAge(Long age) {
        
            this.age = age;
        }
    
        public Long getSalary() {
        
            return salary;
        }
    
        public void setSalary(Long salary) {
        
            this.salary = salary;
        }
    
        public Integer getClassId() {
        
            return classId;
        }
    
        public void setClassId(Integer classId) {
        
            this.classId = classId;
        }
    }

//dao层
    package com.daodao.mybatisgeneratordemo.dao;
    
    import com.daodao.mybatisgeneratordemo.pojo.Teacher;
    import java.util.List;
    
    public interface TeacherMapper {
        
        int deleteByPrimaryKey(String guid);
    
        int insert(Teacher record);
    
        Teacher selectByPrimaryKey(String guid);
    
        List<Teacher> selectAll();
    
        int updateByPrimaryKey(Teacher record);
    }

<?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.daodao.mybatisgeneratordemo.dao.TeacherMapper">
      <resultMap id="BaseResultMap" type="com.daodao.mybatisgeneratordemo.pojo.Teacher">
        <id column="guid" jdbcType="VARCHAR" property="guid" />
        <result column="name" jdbcType="VARCHAR" property="name" />
        <result column="age" jdbcType="NUMERIC" property="age" />
        <result column="salary" jdbcType="NUMERIC" property="salary" />
        <result column="class_id" jdbcType="INTEGER" property="classId" />
      </resultMap>
      <delete id="deleteByPrimaryKey" parameterType="java.lang.String">
        delete from teacher
        where guid = #{guid,jdbcType=VARCHAR}
      </delete>
      <insert id="insert" parameterType="com.daodao.mybatisgeneratordemo.pojo.Teacher">
        insert into teacher (guid, `name`, age, 
          salary, class_id)
        values (#{guid,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, #{age,jdbcType=NUMERIC}, 
          #{salary,jdbcType=NUMERIC}, #{class_id,jdbcType=INTEGER})
      </insert>
      <update id="updateByPrimaryKey" parameterType="com.daodao.mybatisgeneratordemo.pojo.Teacher">
        update teacher
        set `name` = #{name,jdbcType=VARCHAR},
          age = #{age,jdbcType=NUMERIC},
          salary = #{salary,jdbcType=NUMERIC},
          class_id = #{class_id,jdbcType=INTEGER}
        where guid = #{guid,jdbcType=VARCHAR}
      </update>
      <select id="selectByPrimaryKey" parameterType="java.lang.String" resultMap="BaseResultMap">
        select guid, `name`, age, salary, class_id
        from teacher
        where guid = #{guid,jdbcType=VARCHAR}
      </select>
      <select id="selectAll" resultMap="BaseResultMap">
        select guid, `name`, age, salary, class_id
        from teacher
      </select>
    </mapper>

以上。

[img-pyMSdqCo-1595170652342_C_Users_AppData_Roaming_Typora_typora-user-images_image-20200719222755308.png]: /images/20230209/2b0ee1bf49b8402c848cae7622c917ec.png