mybatis逆向工程配置及异常处理

作者: 冬月廿拾 | 来源:发表于2020-10-14 18:21 被阅读0次

mybatis逆向工程配置及异常处理
ssm
ssm
SpringBoot2(三)：整合mybatis完整版
Mybatis 基础介绍与逆向工程的构建
Springboot中MyBatis逆向工程生成model和ma
MyBatis中selectByExample和selectBy
mybatis逆向工程配置
mybatis教程
用IDEA开发MyBatis逆向工程

使用逆向工程自动生成实体类及mapper

配置

1.新增逆向工程的包

<!-- mybatis逆向工程的包 -->
        <!--  https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core  -->
        <dependency>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-core</artifactId>
            <version>1.3.3</version>
        </dependency>

2.加入mybatis-generator自动生成代码插件

<build>
        <plugins>
            <!-- mybatis-generator自动生成代码插件 -->
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <configuration>
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>
                </configuration>
                <executions>
                    <execution>
                        <id>Generate MyBatis Artifacts</id>
                        <goals>
                            <goal>generate</goal>
                        </goals>
                    </execution>
                </executions>
            </plugin>
        </plugins>
    </build>

3.添加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>
    <!-- 数据库驱动:选择你的本地硬盘上面的数据库驱动包-->
    <classPathEntry  location="你的目录/mysql-connector-java-5.1.26.jar"/>
    <context id="DB2Tables"  targetRuntime="MyBatis3">
        <commentGenerator>
            <property name="suppressDate" value="true"/>
            <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>
        <!--数据库链接URL，用户名、密码
           1.一般jdbc数据库的版本6.x以上，都是com.mysql.cj.jdbc.Driver  其他的低版本就是com.mysql.cj.jdbc.Driver
         -->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://111.229.111.111:3306/test01?useSSL=false"
                        userId="root"
                        password="123456">
        </jdbcConnection>
        <javaTypeResolver>
            <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>
        <!-- 生成模型的包名和位置-->
        <javaModelGenerator targetPackage="com.springbootdata.demo.dal.dao" targetProject="src/main/java">
            <property name="enableSubPackages" value="true"/>
            <property name="trimStrings" value="false"/>
        </javaModelGenerator>
        <!-- 生成映射文件的包名和位置-->
        <sqlMapGenerator targetPackage="mybatis.mapper" targetProject="src/main/resources">
            <property name="enableSubPackages" value="true"/>
        </sqlMapGenerator>
        <!-- 生成DAO的包名和位置-->
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.springbootdata.demo.dal.mapper" targetProject="src/main/java">
            <property name="enableSubPackages" value="true"/>
        </javaClientGenerator>
        <!-- 要生成的表 tableName是数据库中的表名或视图名 domainObjectName是实体类名-->
<!--        <table tableName="machine" domainObjectName="machine" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>-->
        <table tableName="machine" domainObjectName="Machine" >
<!-- 可选 指定字段的类型-->
            <columnOverride column="id" property="id" javaType="java.lang.Integer" />
            <columnOverride column="enabled" property="enabled" javaType="java.lang.Integer" />
            <columnOverride column="operation_type" property="operationType" javaType="java.lang.Integer" />
            <columnOverride column="from_state" property="fromState" javaType="java.lang.Integer" />
            <columnOverride column="from_state_final" property="fromStateFinal" javaType="java.lang.Integer" />
        </table>
    </context>
</generatorConfiguration>

4.双击执行插件

image.png

生成结果

image.png

异常处理

https://blog.csdn.net/j18423532754/article/details/86488448
https://blog.csdn.net/qq_40307945/article/details/81351302
https://blog.csdn.net/qq_35246620/article/details/54412648

启动时bean注入异常

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'helloController': Unsatisfied dependency expressed through field 'factorMapper'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'factorMapper' defined in file [/Users/apple/My/springboot-data/target/classes/com/springbootdata/demo/dal/mapper/FactorMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [/Users/apple/My/springboot-data/target/classes/mybatis/mapper/MachineMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [/Users/apple/My/springboot-data/target/classes/mybatis/mapper/MachineMapper.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.springbootdata.demo.dal.mapper.MachineMapper.BaseResultMap
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:643) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:130) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1420) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879) ~[spring-context-5.2.9.RELEASE.jar:5.2.9.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) ~[spring-context-5.2.9.RELEASE.jar:5.2.9.RELEASE]
    at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) ~[spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE]
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) [spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE]
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) [spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE]
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) [spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) [spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE]
    at com.springbootdata.demo.SpringbootDataApplication.main(SpringbootDataApplication.java:14) [classes/:na]

原因：有mapper.xml内有多个<resultMap id="BaseResultMap"
image.png
image.png
出现多个<resultMap id="BaseResultMap" 的原因是同一个表使用逆向工程生成了两次
解决删除xml文件重新生成

打包时执行了mybatis-generator-maven-plugin插件

解决：在pom.xml中添加如下

<!-- mybatis-generator自动生成代码插件 -->
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <configuration>
                    <!--配置文件的位置-->
                    <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>

                </configuration>
<!--添加executions中的内容，添加后在项目package或install时不会执行mybatis.generatorp.plugin命令-->
                <executions>
                    <execution>
                        <id>Generate MyBatis Artifacts</id>
                        <phase>deploy</phase>
                        <goals>
                            <goal>generate</goal>
                        </goals>
                    </execution>
                </executions>
                <dependencies>
                    <dependency>
                        <groupId>org.mybatis.generator</groupId>
                        <artifactId>mybatis-generator-core</artifactId>
                        <version>1.3.2</version>
                    </dependency>
                </dependencies>
            </plugin>

mybatis逆向工程配置及异常处理
使用逆向工程自动生成实体类及mapper 配置 1.新增逆向工程的包 2.加入mybatis-generator自...
ssm
工程目录结构 mybatis逆向工程逆向工程配置文件 generatorConfig.xml文件逆向工程代码 ...
ssm
mybatis逆向工程逆向工程配置文件 generatorConfig.xml文件逆向工程代码测试类(可以在...
SpringBoot2(三)：整合mybatis完整版
1. 修改pom.xml文件添加mybatis、mysql、逆向工程，连接池等依赖配置mybatis逆向工程m...
Mybatis 基础介绍与逆向工程的构建
Mybatis 基础介绍与逆向工程的构建 Mybatis系列：Mybatis 基础介绍与逆向工程的构建：http...
Springboot中MyBatis逆向工程生成model和ma
使用org.mybatis.generator逆向工程生成model和mapper 1、引入MyBatis逆向工程...
MyBatis中selectByExample和selectBy
先贴一段MyBatis逆向工程自动生成的xml配置文件片段这样在逆向工程时，param_data列的jdbcTy...
mybatis逆向工程配置
转载整合自：【项目管理】Mybatis-Generator之最完美配置详解和 generator自动生成myba...
mybatis教程
mybatis逆向工程步骤: 添加逆向工程插件 https://mvnrepository.com/artifac...
用IDEA开发MyBatis逆向工程
title: 用IDEA开发MyBatis逆向工程tags: MyBatiscategories: MyBatis...