mybatis-generator 自动生成实体类和mapper.xml文件项目搭建

1.创建空java maven项目

2.pom引入数据库驱动和mybatbis自动生成工具依赖 mysql数据库

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.bsoft</groupId>
    <artifactId>pesmybatisgenerator</artifactId>
    <version>1.0-SNAPSHOT</version>

    <dependencies>
        <!-- mysql驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.35</version>
        </dependency>
        <!-- mybatis自动生成实体类-->
        <dependency>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-core</artifactId>
            <version>1.3.5</version>
        </dependency>
    </dependencies>
</project>

3. resources 下创建mybatis-generator.xml文件

<?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>
    <context id="DB2Tables" targetRuntime="MyBatis3Simple">
        <commentGenerator>
            <property name="suppressDate" value="true" />
            <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
            <!-- 这个注释是generator的注释。不是建表时手输的，没什么卵用-->
            <property name="suppressAllComments" value="true" />
        </commentGenerator>
        <!--数据库链接URL，用户名、密码 -->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://x.x.x.x/cloudpes20220308?useUnicode=true&amp;characterEncoding=utf-8&amp;useSSL=false"
                        userId="jkgl" password="xxxx">
        </jdbcConnection>
        <javaTypeResolver>
            <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>
        <!-- 设置Java类生成的位置 -->
        <javaModelGenerator targetPackage="com.bsoft.entity"
                            targetProject="E:\developerSoft\workSpaceForIdea\温州卫健委干部保健项目公众端\pesmybatisgenerator\\\src\\main\\java">
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="true" />
        </javaModelGenerator>
        <!-- 生成映射文件的包名和位置 ***mapper.xml-->
        <sqlMapGenerator targetPackage="\mappers"
                         targetProject="E:\developerSoft\workSpaceForIdea\温州卫健委干部保健项目公众端\pesmybatisgenerator\\\src\\main\\resources">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
        <!-- 生成DAO的包名和位置 ***mapper.java-->
        <javaClientGenerator type="XMLMAPPER"
                             targetPackage="com.bsoft.dao" targetProject="E:\developerSoft\workSpaceForIdea\温州卫健委干部保健项目公众端\pesmybatisgenerator\\\src\\main\\java">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>
        <!-- 所有要生成的表名 -->
        <table tableName="yypt_test"></table>
        <!--<table tableName="table1"></table>-->
        <!--<table tableName="table2"></table>-->

    </context>
</generatorConfiguration>

4.创建main启动方法PesMybatisgenerator.java

package com.bsoft;

import org.mybatis.generator.