mybatis代码自动生成

怼烎@ 2023-02-14 13:07 7阅读 0赞

## mybatis代码自动生成 ##

利用mybatis代码自动生成工具，可以根据mysql中的数据表，生成一些文件。  
依赖

<dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.4</version>
    </dependency>
    
    <dependency>
      <groupId>org.mybatis.generator</groupId>
      <artifactId>mybatis-generator-core</artifactId>
      <version>1.3.5</version>
    </dependency>
    
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.36</version>
    </dependency>

启动类

public class Generator { 
        public void generator() throws Exception{ 
    
    
            List<String> warnings = new ArrayList<String>();
    //已经创建了是否覆盖
            boolean overwrite = true;
    //注意这里最好采用绝对路径，否则容易出现找不到文件
            File configFile = new File("C:\\Users\\chengluo\\Desktop\\mybatisgen\\src\\main\\resource\\generator.xml");
            ConfigurationParser cp = new ConfigurationParser(warnings);
            Configuration config = cp.parseConfiguration(configFile);
            DefaultShellCallback callback = new DefaultShellCallback(overwrite);
            MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config,
                    callback, warnings);
            myBatisGenerator.generate(null);
    
    
        }
        public static void main(String[] args) throws Exception { 
            try { 
                Generator generatorSqlmap = new Generator();
                generatorSqlmap.generator();
                System.out.println("mybatis 代码生成成功。。。");
            } catch (Exception e) { 
                e.printStackTrace();
            }
        }
    }

配置文件：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="testTables" targetRuntime="MyBatis3">
            <commentGenerator>
                
                <property name="suppressAllComments" value="true" />
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                            connectionURL="jdbc:mysql://127.0.0.1:3306/txdyl" userId="root"
                            password="123456">
            </jdbcConnection>
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    
    
            
            <javaModelGenerator targetPackage="com.iflytek.robot.entity"
                                targetProject=".\src\main\java">
                
                <property name="enableSubPackages" value="false" />
                
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="mapper"
                             targetProject=".\src\main\resource">
                
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
            
            <javaClientGenerator type="XMLMAPPER"
                                 targetPackage="com.iflytek.robot.dao"
                                 targetProject=".\src\main\java">
                
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
            
            
            <table tableName="tb_user" domainObjectName="UserInfoPojo"
                   enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
                   enableSelectByExample="false" selectByExampleQueryId="false" >
                <property name="useActualColumnNames" value="false"/>
            </table>
        </context>
    </generatorConfiguration>

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDk5MDgxOA_size_16_color_FFFFFF_t_70_pic_center]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDk5MDgxOA_size_16_color_FFFFFF_t_70_pic_center]: https://img-blog.csdnimg.cn/202008122328408.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDk5MDgxOA==,size_16,color_FFFFFF,t_70#pic_center