springboot项目Mybatis-generator生成bean.dao和xml

绝地灬酷狼 2022-02-20 11:37 217阅读 0赞

首先你要有一个springboot项目：

第一步引入包：直接贴pom

<?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.xxcy.erp</groupId>
        <artifactId>booterp</artifactId>
        <version>1.0-SNAPSHOT</version>
       
    
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.0.1.RELEASE</version>
            <relativePath/>
        </parent>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.30</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.0.0</version>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
            </dependency>
            
            <dependency>
                <groupId>io.springfox</groupId>
                <artifactId>springfox-swagger2</artifactId>
                <version>2.9.2</version>
            </dependency>
            
            <dependency>
                <groupId>io.springfox</groupId>
                <artifactId>springfox-swagger-ui</artifactId>
                <version>2.9.2</version>
            </dependency>
    
        </dependencies>
        
        <build>
            <finalName>erp2boot</finalName>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-compiler-plugin</artifactId>
                    <configuration>
                        <source>1.8</source>
                        <target>1.8</target>
                    </configuration>
                </plugin>
                
                <plugin>
                    
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.5</version>
                    <configuration>
                        
                        <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
                        <verbose>true</verbose>
                        <overwrite>true</overwrite>
                    </configuration>
                    <executions>
                        <execution>
                            <id>Generate MyBatis Artifacts</id>
                            <goals>
                                <goal>generate</goal>
                            </goals>
                        </execution>
                    </executions>
                    <dependencies>
                        <dependency>
                            <groupId>org.mybatis.generator</groupId>
                            <artifactId>mybatis-generator-core</artifactId>
                            <version>1.3.5</version>
                        </dependency>
                    </dependencies>
                </plugin>
            </plugins>
        </build>
    
    
    </project>

第二步：然后在resources 下创建   generatorconfig.xml  这个要和pom的写的对上

下面贴上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>
    	
    	<classPathEntry  location="E:\xxcy\mysql-connector-java-8.0.13.jar"/>
    	<context id="DB2Tables"  targetRuntime="MyBatis3">
    		<commentGenerator>
    			<property name="suppressDate" value="true"/>
    			
    			<property name="suppressAllComments" value="false"/>
    		</commentGenerator>
    		
    		<jdbcConnection driverClass="com.mysql.cj.jdbc.Driver" connectionURL="jdbc:mysql://192.168.1.63:3306/testtable?serverTimezone=GMT%2B8" userId="root" password="Aa123456">
    		</jdbcConnection>
    		<javaTypeResolver>
    			<property name="forceBigDecimals" value="false"/>
    		</javaTypeResolver>
    		
    		<javaModelGenerator targetPackage="com.xxcy.erp.domain" targetProject="E:\booterp\src\main\java">
    			<property name="enableSubPackages" value="true"/>
    			<property name="trimStrings" value="true"/>
    		</javaModelGenerator>
    		
    		<sqlMapGenerator targetPackage="mapping" targetProject="E:\booterp\src\main\resources">
    			<property name="enableSubPackages" value="true"/>
    		</sqlMapGenerator>
    		
    		<javaClientGenerator type="XMLMAPPER" targetPackage="com.xxcy.erp.mapping" targetProject="E:\booterp\src\main\java">
    			<property name="enableSubPackages" value="true"/>
    		</javaClientGenerator>
    
    
    		
    		<table tableName="user" domainObjectName="user"  ></table>
    		
    		
    
    	</context>
    </generatorConfiguration>

注意点：

1.引入的包我是单独下载指定的，你可以用maven下载的

2.idea可能要把所有的地址用绝对路径 eclipse 用相对路径 （未验证eclipse） ,我用的idea所有写的绝对路径

<property name="suppressAllComments" value="false"/> 这个要是改成true没有注释，但是idea生成的xml有sqlmap重复问题

4.表

表名要换自己需要的  后面这些是问是不是生成查询修改或删除  按需修改

还有表名字可以用% 模糊的哈

第三步：点击

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmNodW5fY2hlbmc_size_16_color_FFFFFF_t_70][]

好了,就先记录到这

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmNodW5fY2hlbmc_size_16_color_FFFFFF_t_70]: /images/20220220/93ab063b25094c708841234ec44ae512.png