IDEA SpringBoot Mybatis逆向工程

冷不防 2021-12-01 14:44 378阅读 0赞

## IDEA SpringBoot Mybatis逆向工程 ##

1.  添加依赖
    
        
                <dependency>
                    <groupId>org.mybatis.spring.boot</groupId>
                    <artifactId>mybatis-spring-boot-starter</artifactId>
                    <version>1.3.2</version>
                </dependency>
        
        		
                <dependency>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-core</artifactId>
                    <version>1.3.6</version>
                </dependency>
2.  添加插件
    
        <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>1.3.6</version>
                        <dependencies>
                        
                            <dependency>
                                <groupId>mysql</groupId>
                                <artifactId>mysql-connector-java</artifactId>
                                
                                <version>8.0.13</version>
                            </dependency>
                        </dependencies>
                    </plugin>
                </plugins>
            </build>
3.  在src/main/resources下添加generatorConfig.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="mybatisGenerator" targetRuntime="MyBatis3">
                <commentGenerator>
                    
                    <property name="suppressAllComments" value="true" />
                </commentGenerator>
                
                <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/shiro_csdn_demo?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8" userId="root" password="871403165">
                </jdbcConnection>
        
                
                <javaTypeResolver>
                    <property name="forceBigDecimals" value="false" />
                </javaTypeResolver>
        
                
                <javaModelGenerator targetPackage="com.sqt.generator.bean" targetProject="src/main/java">
                    
                    <property name="enableSubPackages" value="false" />
                    
                    <property name="trimStrings" value="true" />
                </javaModelGenerator>
                
                <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources">
                    
                    <property name="enableSubPackages" value="false" />
                </sqlMapGenerator>
                
                <javaClientGenerator type="XMLMAPPER" targetPackage="com.sqt.generator.mapper" targetProject="src/main/java">
                    
                    <property name="enableSubPackages" value="false" />
                </javaClientGenerator>
                
                <table tableName="sys_permission"></table>
                <table tableName="user_info"></table>
                <table tableName="sys_role"></table>
                <table tableName="sys_role_permission"></table>
                <table tableName="sys_user_role"></table>
        
                
            </context>
        </generatorConfiguration>
    
    注意字节在xml中写&,会因为未转义而报错要将&写成& amp;
    
        connectionURL="jdbc:mysql://localhost:3306/shiro_csdn_demo?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8"
4.  使用插件生成代码

![在这里插入图片描述][20190720194119617.png]

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

![在这里插入图片描述][20190720194155133.png]  
5. 如果使用的是java类而不是plugin来生成代码需要添加依赖, 但是可以将build中的plugin删除掉

<dependency>
          <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
           <version>8.0.16</version>
    </dependency>

在java包中添加java代码, 执行该代码可以生成, 达到plugin同样的效果

public class Generator { 
        public void generator() throws Exception{ 
            List<String> warnings = new ArrayList<String>();
            boolean overwrite = true;
            /**指向逆向工程配置文件*/
            File configFile = new File("src/main/resources/generatorConfig.xml");
            ConfigurationParser parser = new ConfigurationParser(warnings);
            Configuration config = parser.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();
            } catch (Exception e) { 
                e.printStackTrace();
            }
        }
    }

[20190720194119617.png]: /images/20211201/18ffb3819d894ae8bed5b48a15d20b76.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FuZ2VyV2luZA_size_16_color_FFFFFF_t_70]: /images/20211201/34ae60777d294ac39eac5b011b285a12.png
[20190720194155133.png]: /images/20211201/367040a7d62245b09017aa2a2c06eb2f.png