Spring--8.mapper扫描

1      第一种 在conf

1.1             目录

 

1.2             配置

<!--3.sqlSessionFactory 配置和MyBatis的整合 -->
<bean id="sqlSessionFactory"class="org.mybatis.spring.SqlSessionFactoryBean">
   <!-- 3.1注入数据源 -->
   <property name="dataSource" ref="dataSource"></property>

   <!-- 3.2  指定mybatis   全局配置文件  -->
   <property name="configLocation"value="classpath:mybatis/SqlMapConfig.xml"/>

   <!-- 3.3指定mybatis,mapper文件的位置-->
   <propertyname="mapperLocations" value="classpath:mapper/*.xml"></property>
</bean>
 
<!-- 4. 配置mybatis扫描器,-->
<!-- 4.1 将mybatis接口的实现加入到ioc容器中  dao接口 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
   <property name="basePackage" value="cn.e3mall.mapper"></property>
   <!-- 使用sqlSessionFactoryBeanName -->
   <property name="sqlSessionFactoryBeanName"value="sqlSessionFactory"/>
</bean> 

2      第二种 在同包下

2.1             目录

2.2             配置

缺少指定mapper位置

 

<!--3.sqlSessionFactory 配置和MyBatis的整合 -->
<bean id="sqlSessionFactory"class="org.mybatis.spring.SqlSessionFactoryBean">
   <!-- 3.1注入数据源 -->
   <property name="dataSource" ref="dataSource"></property>

   <!-- 3.2  指定mybatis   全局配置文件  -->
   <property name="configLocation"value="classpath:mybatis/SqlMapConfig.xml"/>

  
</bean>
 
<!-- 4. 配置mybatis扫描器,-->
<!-- 4.1 将mybatis接口的实现加入到ioc容器中  dao接口 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
   <property name="basePackage" value="cn.e3mall.mapper"></property>
   <!-- 使用sqlSessionFactoryBeanName -->
   <property name="sqlSessionFactoryBeanName"value="sqlSessionFactory"/>
</bean> 

2.3             Pom中加载配置

多一步 pom加载xml

 

<build>
    <finalName>${project.artifactId}</finalName>
    <resources>
        <resource>
            <directory>src/main/java</directory>
            <includes>
                <include>**/*.properties</include>
                <include>**/*.xml</include>
            </includes>
            <filtering>false</filtering>
        </resource>
    </resources>
</build>

3      第三种 在不同包下

3.1             目录

 

 

3.2             配置

<!-- 创建SqlSessionFactory,同时指定数据源 -->
<bean id="sqlSessionFactory"class="org.mybatis.spring.SqlSessionFactoryBean">
   <property name="dataSource" ref="dataSource" />
   <!--configLocation属性指定mybatis的核心配置文件 -->
   <property name="mapperLocations">
      <list>
         <value>classpath:com/founder/**/sqlmap/*.xml</value>
      </list>
   </property>
</bean>

<!-- MapperScannerConfigurer配置 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
   <!-- basePackage指定要扫描的包,在此包之下的映射器都会被搜索到。可指定多个包,包与包之间用逗号或分号分隔 -->
   <property name="basePackage" value="com.founder.**.dao"/>
</bean>

 

3.3             配置2

2      问题

2.1             如果发现无法扫描xml

参考https://blog.csdn.net/zjccsg/article/details/69257487

思考是不是打包就没有扫描到

这idea问题,在pom文件加上

<build>
  <finalName>innovation</finalName>
  <resources>
    <!--编译之后包含xml-->
    <resource>
      <directory>src/main/java</directory>
      <includes>
        <include>**/*.xml</include>
      </includes>
      <filtering>true</filtering>
    </resource>
  </resources>
</build>

 

 



 

 

java.lang.IllegalStateException: Failed to execute CommandLineRunner at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798) [spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE] at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:779) [spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE] at org.springframework.boot.SpringApplication.run(SpringApplication.java:322) [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.unkown.data.hw.ipran.straight.collect.UnkownDataHwIpranStraightCollectApplication.main(UnkownDataHwIpranStraightCollectApplication.java:39) [classes/:na] Caused by: org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.unkown.data.hw.ipran.straight.collect.dao.RTrsHwIpranCircuitDao.queryById at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235) ~[mybatis-3.5.5.jar:3.5.5] at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:53) ~[mybatis-3.5.5.jar:3.5.5] at org.apache.ibatis.binding.MapperProxy.lambda$cachedInvoker$0(MapperProxy.java:115) ~[mybatis-3.5.5.jar:3.5.5] at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660) ~[na:1.8.0_271] at org.apache.ibatis.binding.MapperProxy.cachedInvoker(MapperProxy.java:102) ~[mybatis-3.5.5.jar:3.5.5] at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85) ~[mybatis-3.5.5.jar:3.5.5] at com.sun.proxy.$Proxy108.queryById(Unknown Source) ~[na:na] at com.unkown.data.hw.ipran.straight.collect.service.impl.RTrsHwIpranCircuitServiceImpl.queryById(RTrsHwIpranCircuitServiceImpl.java:29) ~[classes/:na] at com.unkown.data.hw.ipran.straight.collect.controller.RTrsHwIpranCircuitController.IpranSend(RTrsHwIpranCircuitController.java:54) ~[classes/:na] at com.unkown.data.hw.ipran.straight.collect.MyRunner.run(MyRunner.java:24) ~[classes/:na] at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:795) [spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE] ... 5 common frames omitted
05-18
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值