mybatis自动生成xml的配置

深碍√TFBOYSˉ_ 2024-04-17 22:35 63阅读 0赞

idea通过数据库直接生成mybatis的xml和实体文件，很简单，一共分三步  
1.配置generatorConfig.xml  
2.配置pom  
3.配置命令 mybatis-generator:generate -e

<dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.4.1</version>
            </dependency>

1.配置generatorConfig.xml  
以下会自动生成entity，mapper，和xml文件  
mapper上是没有@Mapper注解的呦

<!DOCTYPE generatorConfiguration
            PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    <generatorConfiguration>
        
        <classPathEntry location="F:\aaaRepository\java\repository\mysql\mysql-connector-java\8.0.17\mysql-connector-java-8.0.17.jar"/>
        <context id="mysql">
                <commentGenerator>
                    <property name="suppressDate" value="true" />
                    <property name="suppressAllComments" value="true" />
                </commentGenerator>
                <jdbcConnection
                        connectionURL="jdbc:mysql://localhost:3306/aaa?serverTimezone=GMT%2B8"
                        driverClass="com.mysql.cj.jdbc.Driver" password="root" userId="root" />
                <javaTypeResolver>
                    <property name="forceBigDecimals" value="false" />
                </javaTypeResolver>
                <javaModelGenerator targetPackage="com.aaa.bbb.entity" targetProject="src/main/java" >
                    <property name="constructorBased" value="false"/>
                </javaModelGenerator>
                <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"/>
                <javaClientGenerator targetPackage="com.aaa.bbb.mapper" targetProject="src/main/java" type="XMLMAPPER" >
                </javaClientGenerator>
                <table tableName="ccc"  enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"     enableSelectByExample="false"> </table>         	   
           </context>
    </generatorConfiguration>

“context” 的内容必须匹配**按照下面的顺序**配置 ？号的可以没有  
(connectionFactory|jdbcConnection),  
javaTypeResolver?,  
javaModelGenerator,  
sqlMapGenerator?,  
javaClientGenerator?,  
table+

2.配置pom

<build>
    		<plugins>
    			<plugin>
    				<groupId>org.mybatis.generator</groupId>
    				<artifactId>mybatis-generator-maven-plugin</artifactId>
    				<configuration>
    					<verbose>true</verbose>
    					<overwrite>true</overwrite>
    				</configuration>
    			</plugin>
    			<plugin>
    				<groupId>org.springframework.boot</groupId>
    				<artifactId>spring-boot-maven-plugin</artifactId>
    			</plugin>
    		</plugins>
    	</build>

1.  命令 mybatis-generator:generate -e  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlbmdxaW5neXVlYmFpMTk_size_16_color_FFFFFF_t_70]  
    运行上边的命令就行了，实体是驼峰形式的，也可以修改配置和数据库一样

public class Ccc{
        private Integer id;
    
        private String identifyCode;
    
        public Integer getId() {
            return id;
        }
    
        public void setId(Integer id) {
            this.id = id;
        }
    
        public String getIdentifyCode() {
            return identifyCode;
        }
    
        public void setIdentifyCode(String identifyCode) {
            this.identifyCode = identifyCode;
        }
    
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlbmdxaW5neXVlYmFpMTk_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/34b2fa2dedf24f1283eebe51a7003cb7.png