mapper 接口与 mapper xml 文件不在同一级目录

当mapper 接口与 mapper xml 文件不在同一个目录下，JavaBean 配置，无法加载到相应的文件。
image.png

  1. Exception in thread "main" org.apache.ibatis.binding.BindingException: Type interface com.demo.activiti7.common.export.databse.ExportDatabaseTableModelMapper is not known to the MapperRegistry.
  2.     at org.apache.ibatis.binding.MapperRegistry.getMapper(MapperRegistry.java:47)
  3.     at org.apache.ibatis.session.Configuration.getMapper(Configuration.java:845)
  4.     at org.apache.ibatis.session.defaults.DefaultSqlSession.getMapper(DefaultSqlSession.java:291)
  5.     at com.demo.activiti7.ExportDatabaseTableModelTest.main(ExportDatabaseTableModelTest.java:69)

JavaBean 方式目前未找到不使用 xml 方式来指定 xml 文件位置的办法。
只好按照要求，要么把 xml 写到 src/main/java 中，要么最终打包到相同的目录中（即 src/main/java mapper 接口要与 src/main/resource mapper.xml 目录一致）
**
参考：Mybatis中接口和对应的mapper文件位置配置详解

本人的小部分代码

  1. package com.demo.activiti7;
  3. import com.alibaba.excel.EasyExcel;
  4. import com.alibaba.excel.ExcelWriter;
  5. import com.alibaba.excel.write.metadata.WriteSheet;
  6. import com.alibaba.excel.write.metadata.WriteTable;
  7. import com.demo.activiti7.common.export.databse.ColumnInfoDto;
  8. import com.demo.activiti7.common.export.databse.DataBaseTableModelDto;
  9. import com.demo.activiti7.common.export.databse.ExportDatabaseTableModelMapper;
  10. import java.util.ArrayList;
  11. import java.util.Arrays;
  12. import java.util.List;
  13. import javax.sql.DataSource;
  14. import org.apache.ibatis.datasource.unpooled.UnpooledDataSource;
  15. import org.apache.ibatis.mapping.Environment;
  16. import org.apache.ibatis.session.Configuration;
  17. import org.apache.ibatis.session.SqlSession;
  18. import org.apache.ibatis.session.SqlSessionFactory;
  19. import org.apache.ibatis.session.SqlSessionFactoryBuilder;
  20. import org.apache.ibatis.transaction.TransactionFactory;
  21. import org.apache.ibatis.transaction.jdbc.JdbcTransactionFactory;
  23. public class ExportDatabaseTableModelTest {
  25.     public static void main(String[] args) {
  26.         // .setDatabaseSchema("activiti7")
  27.         //                .setJdbcUrl(
  28.         //                        "jdbc:mysql:///activiti_demo?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true")
  29.         //                .setDbHistoryUsed(true)
  30.         //                .setJdbcPassword("123456")
  31.         //                .setJdbcUsername("root")
  32.         //                .setJdbcDriver("com.mysql.cj.jdbc.Driver")
  33.         //                .setHistoryLevel(HistoryLevel.FULL)
  34.         //                .setDatabaseType("mysql")
  36.         //  url: jdbc:mysql://192.168.0.211:30093/produce?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8
  37.         //      username: root
  38.         //      password: produce#123
  39.         DataSource dataSource = new UnpooledDataSource("com.mysql.cj.jdbc.Driver",
  40.                 "jdbc:mysql://192.168.0.211:30093/produce?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8",
  41.                 "root",
  42.                 "produce#123");
  44.         TransactionFactory transactionFactory = new JdbcTransactionFactory();
  45.         Environment environment = new Environment("development", transactionFactory, dataSource);
  46.         Configuration configuration = new Configuration(environment);
  47.         /*
  48.         <!-- 第一种：注册sql映射文件-->
  49.         <mapper resource="com/spldeolin/mapper/UserMapper.xml" />
  51.         <!-- 第二种：注册接口   sql映射文件必须与接口同名，并且放在同一目录下-->
  52.         <!--<mapper class="com.spldeolin.mapper.UserMapper" />-->
  54.         <!-- 第三种：注册基于注解的接口  基于注解   没有sql映射文件，所有的sql都是利用注解写在接口上-->
  55.         <!--<mapper class="com.spldeolin.mapper.TeacherMapper" />-->
  57.         <!-- 第四种：批量注册  需要将sql配置文件和接口放到同一目录下-->
  58.         <package name="com.spldeolin.mapper" />
  59.          */
  60. //        configuration.addLoadedResource("mapper/ExportDatabaseTableModelMapper.xml");
  61.         configuration.addMapper(ExportDatabaseTableModelMapper.class);
  63.         configuration.getTypeAliasRegistry().registerAlias("dataBaseTableModelDto", DataBaseTableModelDto.class);
  64.         configuration.setMapUnderscoreToCamelCase(true);
  66.         SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);
  67.         SqlSession sqlSession = sqlSessionFactory.openSession();
  68.         ExportDatabaseTableModelMapper exportDatabaseTableModelMapper =
  69.                 sqlSession.getMapper(ExportDatabaseTableModelMapper.class);
  70.         String database = "produce";
  71.         List<DataBaseTableModelDto> produceList = exportDatabaseTableModelMapper.getDatabaseTableModel(database);
  73.         String fileName = database + ".xlsx";
  74.         ExcelWriter excelWriter = EasyExcel.write(fileName)
  75. //                .needHead(true)
  76. //                .head(headers)
  77.                 .automaticMergeHead(true)
  78.                 .autoCloseStream(true)
  79.                 .build();
  80.         // 把sheet设置为不需要头 不然会输出sheet的头 这样看起来第一个table 就有2个头了
  81.         WriteSheet writeSheet = EasyExcel.writerSheet("数据表模型").needHead(Boolean.FALSE).build();
  82.         for (int i = 0; i < produceList.size(); i++) {
  83.             DataBaseTableModelDto dataBaseTableModelDto = produceList.get(i);
  84.             List<List<String>> headers = new ArrayList<>();
  85.             String mainHeader = String.format("表 %d：%s", i + 1, dataBaseTableModelDto.getTableName());
  86.             List<ColumnInfoDto> columns = dataBaseTableModelDto.getColumns();
  88.             // 添加两列空行
  89.             columns.add(new ColumnInfoDto());
  90.             columns.add(new ColumnInfoDto());
  91.             headers.add(Arrays.asList(mainHeader, "字段名称"));
  92.             headers.add(Arrays.asList(mainHeader, "字段类型"));
  93.             headers.add(Arrays.asList(mainHeader, "字段说明"));
  94.             headers.add(Arrays.asList(mainHeader, "是否主键"));
  95.             headers.add(Arrays.asList(mainHeader, "是否为空"));
  96.             headers.add(Arrays.asList(mainHeader, "默认值"));
  97. //            headers.add(Arrays.asList(mainHeader, "字段类型（仅有类型）"))
  98.             ;
  100.             // 这里必须指定需要头，table 会继承sheet的配置，sheet配置了不需要，table 默认也是不需要
  101.             WriteTable writeTable = EasyExcel.writerTable(i)
  102.                     .head(headers)
  103.                     .automaticMergeHead(true)
  104.                     .needHead(Boolean.TRUE)
  105. //                    .excludeColumnIndexes(Arrays.asList(6))
  106. //                    .excludeColumnFiledNames(Arrays.asList("字段类型（仅有类型）"))
  107.                     .build();
  108.             excelWriter.write(columns, writeSheet, writeTable);
  109.         }
  110.         excelWriter.finish();
  111.         sqlSession.flushStatements();
  112.         sqlSession.close();
  113.     }
  115. }
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="com.demo.activiti7.common.export.databse.ExportDatabaseTableModelMapper">
  5.     <resultMap id="DataBaseTableModelDtoMap" 
  6.         type="com.demo.activiti7.common.export.databse.DataBaseTableModelDto">
  7.         <id property="tableName" column="tableName" />
  8.         <collection property="columns" ofType="com.demo.activiti7.common.export.databse.ColumnInfoDto">
  9.             <result property="columnName" column="columnName" />
  10.             <result property="columnType" column="columnType" />
  11.             <result property="columnComment" column="columnComment" />
  12.             <result property="columnKey" column="columnKey" />
  13. <!--            <result property="columnDataType" column="columnDataType" />-->
  14.             <result property="columnDefault" column="columnDefault" />
  15.             <result property="columnIsNullable" column="columnIsNullable" />
  16.         </collection>
  17.      </resultMap>
  19.   <select id="getDatabaseTableModel"
  20.     resultMap="DataBaseTableModelDtoMap">
  21.     SELECT
  22.             t.TABLE_SCHEMA,
  23.             t.TABLE_COMMENT,
  24.             CONCAT(
  25.                 t.TABLE_COMMENT,
  26.                 '（',
  27.                 t.TABLE_NAME,
  28.                 '）'
  29.             ) AS tableName,
  30.             c.COLUMN_NAME AS columnName,
  31.             c.COLUMN_TYPE AS columnType,
  32.             c.COLUMN_COMMENT AS columnComment,
  33.             c.COLUMN_KEY AS columnKey,
  34.             c.DATA_TYPE AS columnDataType,
  35.             c.COLUMN_DEFAULT AS columnDefault,
  36.             c.IS_NULLABLE AS columnIsNullable
  37.         FROM
  38.             information_schema.`TABLES` t,
  39.             information_schema.`columns` c
  40.         WHERE
  41.             c.TABLE_NAME = t.TABLE_NAME
  42.         AND t.TABLE_SCHEMA = #{databaseName}
  43.   </select>
  44. </mapper>