Springboot中整合Mybatis,Mapper和Mapper.xml不在一个目录下的问题!org.apache.ibatis.binding.BindingException: Invalid
Springboot中整合Mybatis,Mapper和Mapper.xml不在一个目录下的问题!org.apache.ibatis.binding.BindingException: Invalid
·
近期在springboot整合Mybatis和Thymeleaf模板的过程中出了一个小错误。
学过mybatis的同学都知道,mapper接口和mapper.xml要在一个目录下面
本人由于在操作的过程很懒 复制了很多东西 所以就出现了下面这个错误。
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.javaee_3.mapper.CourseMapper.getAll
尝试了网上诸多办法 还是不行,于是我使用下面的办法:
①把resources下 com.javaee_3.mapper 目录先删除
②一步步重新创建目录文件,新建com,新建javaee_3,新建mapper,然后再把CourseMapper.xml加入子目录
③在maven插件那里clean 然后再重新运行。
④查看target 文件, 看两文件是否打包在一个文件夹。
到这步 ,应该就没什么大问题咯~
下面分享一下我在Springboot整合mybatis和Thymeleaf模板的maven文件
<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com</groupId>
<artifactId>JAVAEE_3</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>JAVAEE_3</name>
<description>JAVAEE_3</description>
<properties>
<java.version>1.8</java.version>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<spring-boot.version>2.3.7.RELEASE</spring-boot.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<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>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.0</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.16</version>
</dependency>
<!-- 允许使用非严格的 HTML 语法-->
<dependency>
<groupId>net.sourceforge.nekohtml</groupId>
<artifactId>nekohtml</artifactId>
<version>1.9.22</version>
</dependency>
</dependencies>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-dependencies</artifactId>
<version>${spring-boot.version}</version>
<type>pom</type>
<scope>import</scope>
</dependency>
</dependencies>
</dependencyManagement>
<build>
<!-- 如果不添加此节点mybatis的mapper.xml文件都会被漏掉 -->
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<!-- <filtering>false</filtering>-->
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*</include>
<include>**/*.properties</include>
<include>**/*.xml</include>
<include>**/*.yml</include>
<include>**/*.html</include>
<include>**/*.js</include>
<include>**/*.css</include>
<include>**/*.map</include>
<include>**/*.jpg</include>
<include>**/*.png</include>
<include>**/*.CAB</include>
<include>**/*.ico</include>
</includes>
<!-- <filtering>false</filtering>-->
</resource>
</resources>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.1</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
<encoding>UTF-8</encoding>
</configuration>
</plugin>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<version>2.3.7.RELEASE</version>
<configuration>
<mainClass>com.javaee_3.Javaee3Application</mainClass>
</configuration>
<executions>
<execution>
<id>repackage</id>
<goals>
<goal>repackage</goal>
</goals>
</execution>
</executions>
</plugin>
</plugins>
</build>
</project>
观众老爷,留个点赞吧~
更多推荐
已为社区贡献1条内容
所有评论(0)