invalid bound statement (not found) - 接手一个老项目时报的几个错误处理方案

1、invalid bound statement (not found)

在pom.xml的<build>中配置了resource

<!-- 如果不添加此节点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>**/*.properties</include>
					<include>**/*.xml</include>
				</includes>
				<filtering>false</filtering>
			</resource>
		</resources>

 

2、org.springframework.web.SpringServletContainerInitializer cannot be cast to javax.servlet.ServletCon

<!-- 导入java ee jar 包（重点在下方依赖红色处，不加上运行范围，编译时会冲突） -->

<dependency>

    <groupId>javax</groupId>

    <artifactId>javaee-api</artifactId>

    <scope>provided</scope>

    <version>7.0</version>

</dependency>

3、maven集成tomcat7

<plugin>
             <groupId>org.apache.tomcat.maven</groupId>
             <!-- tomcat7的插件， 不同tomcat版本这个也不一样 -->
             <artifactId>tomcat7-maven-plugin</artifactId>
             <version>2.1</version>
             <configuration>
                 <!-- 通过maven tomcat7:run运行项目时，访问项目的端口号 -->
                 <port>9090</port>
                 <!-- 项目访问路径  本例：localhost:9090,  如果配置的aa， 则访问路径为localhost:9090/aa-->
                 <path>/</path>
                 <uriEncoding>UTF-8</uriEncoding>
             </configuration>
 </plugin>