Table Configuration apiCallLog matched more than one table
MyBatis Generator 生成器把其他数据库的同名表也生成的问题。
在 jdbc 连接配置添加属性:
1 2 3 4 5 6 7 8 |
<!--数据库链接地址账号密码--> <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/apg?useSSL=false&useUnicode=true&characterEncoding=utf8&allowMultiQueries=true&autoReconnect=true&failOverReadOnly=false&socketTimeout=20000&serverTimezone=Hongkong" userId="admin" password="password"> <property name="nullCatalogMeansCurrent" value="true"/> </jdbcConnection> |

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 |
# 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> <properties resource="generator/config.properties"/> <context id="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat"> <!--处理sql中的`符号--> <property name="beginningDelimiter" value="`"/> <property name="endingDelimiter" value="`"/> <!--添加自定义的继承接口--> <plugin type="tk.mybatis.mapper.generator.MapperPlugin"> <property name="mappers" value="tk.mybatis.mapper.common.Mapper"/> <property name="lombok" value="Getter,Setter,ToString,Accessors"/> <!--lombok 插件使用--> </plugin> <!--数据源配置--> <jdbcConnection driverClass="${spring.datasource.driver-class-name}" connectionURL="${spring.datasource.url}" userId="${spring.datasource.username}" password="${spring.datasource.password}"> <property name="nullCatalogMeansCurrent" value="true"/> <!--避免不同数据库 表名称相同 --> </jdbcConnection> <!--model包路径--> <javaModelGenerator targetPackage="com.itmuch.usercenter.domain.entity.${modelName}" targetProject="src/main/java"/> <!--mapper.xml包路径--> <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"/> <!--mapper包路径--> <javaClientGenerator targetPackage="com.itmuch.usercenter.dao.${modelName}" targetProject="src/main/java" type="XMLMAPPER"/> <!--表配置,tableName支持%,表示全部生成--> <table tableName="${tableName}" domainObjectName="${tableName}"> <!--mysql 配置--> <generatedKey column="id" sqlStatement="Mysql" identity="true"/> </table> </context> </generatorConfiguration> |
