postgresql 表生成实体和mapper 文件的工具

我会带着你远行 2022-12-15 06:13 234阅读 0赞

postgresql 表生成实体和mapper 文件的工具：

1、xml文件：generatorConfig.xml  放到resources 目录下：

<?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="sss" targetRuntime="MyBatis3" defaultModelType="flat">
    
        
        
        
        
    
        
        
        
        
        
        
    
        <commentGenerator>
            
            <property name="suppressAllComments" value="true" />
            <property name="suppressDate" value="false" /> 
            <property name="mbggenerated" value="true" /> 
        </commentGenerator>
    
        
        <jdbcConnection driverClass="org.postgresql.Driver"
                        connectionURL="jdbc:postgresql://10.10.16.276:28830/nmp_dds_data_access" userId="postgres"
                        password="cmp">
        </jdbcConnection>
    
    
    
    
        
        <javaModelGenerator targetPackage="com.navinfo.cmp.dds.dataaccess.pojo" targetProject="src/main/java/">
            <property name="enableSubPackages" value="false"/>
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>
        
    
        
        <sqlMapGenerator targetPackage="conf" targetProject="src/main/resources/">
        </sqlMapGenerator>
    
        
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.navinfo.cmp.dds.dataaccess.mapper" targetProject="src/main/java/">
            <property name="enableSubPackages" value="false"/>
        </javaClientGenerator>
    
        
        <table tableName="interface_logs_message" domainObjectName="InterfaceLogsMessage"
    
               enableCountByExample="false" enableUpdateByExample="false"
               enableDeleteByExample="false" enableSelectByExample="false"
               selectByExampleQueryId="true">
    
        </table>
        
    </context>
    </generatorConfiguration>

2、pom.xml文件中配置插件：

<plugin>
       <groupId>org.apache.maven.plugins</groupId>
       <artifactId>maven-compiler-plugin</artifactId>
       <configuration>
          <source>1.8</source>
          <target>1.8</target>
       </configuration>
       <version>3.3</version>
    </plugin>
    <plugin>
       <groupId>org.mybatis.generator</groupId>
       <artifactId>mybatis-generator-maven-plugin</artifactId>
       <version>1.3.2</version>
       <dependencies>
          <dependency>
             <groupId>org.postgresql</groupId>
             <artifactId>postgresql</artifactId>
             <version>9.4-1201-jdbc4</version>
          </dependency>
       </dependencies>
    </plugin>

3、然后点击：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25hbmRhbzE1OA_size_16_color_FFFFFF_t_70][]

就生成了相应的实体和mapper  文件

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25hbmRhbzE1OA_size_16_color_FFFFFF_t_70]: /images/20221123/1c539fd150034804bc0ab4d3c045e79d.png