springboot整合mybatis遇到的一个深坑 Invalid bound statement(not found)

最近一直想要做SSM项目，然后网上找了教程进行学习的时候遇到了一个很深的坑

便是将mybatis代码放置到resource目录下的时候测试即可成功，可是放置到dao包下的时候便出现了错误

Invalid bound statement(not found)，排查了许久终于找出了原因，原来是我pom配置中没有配置好~

代码链接：https://gitee.com/yangyouqi/springboot-mybatis.git

 

1. 使用环境：idea+springboot2.0.1+mybatis
2. pom配置：

   <?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
       <modelVersion>4.0.0</modelVersion>
   
       <groupId>com.yyq</groupId>
       <artifactId>springboot-mybatis</artifactId>
       <version>0.0.1-SNAPSHOT</version>
       <packaging>jar</packaging>
   
       <name>springboot-mybatis</name>
       <description>Demo project for Spring Boot</description>
   
       <parent>
           <groupId>org.springframework.boot</groupId>
           <artifactId>spring-boot-starter-parent</artifactId>
           <version>2.0.1.RELEASE</version>
           <relativePath/> <!-- lookup parent from repository -->
       </parent>
   
       <properties>
           <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
           <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
           <java.version>1.8</java.version>
       </properties>
   
       <dependencies>
           <dependency>
               <groupId>org.springframework.boot</groupId>
               <artifactId>spring-boot-starter-test</artifactId>
               <scope>test</scope>
           </dependency>
           <!--web-->
           <dependency>
               <groupId>org.springframework.boot</groupId>
               <artifactId>spring-boot-starter-web</artifactId>
           </dependency>
   
           <!--mysql db-->
           <dependency>
               <groupId>mysql</groupId>
               <artifactId>mysql-connector-java</artifactId>
               <scope>runtime</scope>
           </dependency>
           <dependency>
               <groupId>org.mybatis.spring.boot</groupId>
               <artifactId>mybatis-spring-boot-starter</artifactId>
               <version>1.3.2</version>
           </dependency>
   
           <!-- alibaba的druid数据库连接池 -->
           <dependency>
               <groupId>com.alibaba</groupId>
               <artifactId>druid-spring-boot-starter</artifactId>
               <version>1.1.9</version>
           </dependency>
   
           <!-- 分页插件 -->
           <dependency>
               <groupId>com.github.pagehelper</groupId>
               <artifactId>pagehelper-spring-boot-starter</artifactId>
               <version>1.2.5</version>
           </dependency>
       </dependencies>
   
       <build>
           <!--放置在dao下的话要在这里配置，让springboot启动时去扫描-->
           <resources>
               <resource>
                   <directory>${basedir}/src/main/java</directory>
                   <includes>
                       <include>**/*.xml</include>
                   </includes>
               </resource>
           </resources>
           <plugins>
               <plugin>
                   <groupId>org.springframework.boot</groupId>
                   <artifactId>spring-boot-maven-plugin</artifactId>
               </plugin>
           </plugins>
       </build>
   
   
   </project>

3. application.properties配置

   
   #mysql 基本属性
   spring.datasource.driver-class-name=com.mysql.jdbc.Driver
   spring.datasource.url=jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true
   spring.datasource.username=root
   spring.datasource.password=123456
   ## mybatis config
   #注意：一定要对应mapper映射xml文件的所在路径
   #mybatis.mapper-locations=classpath:mapper/*.xml
   mybatis.mapperLocations = classpath:com/yyq/springbootmybatis/dao/**/mapper/*.xml
   #对应实体类所在路径
   mybatis.typeAliasesPackage=com.yyq.springbootmybatis.model
   
   #pagehelper
   pagehelper.helper-dialect=mysql
   pagehelper.reasonable=true
   pagehelper.support-methods-arguments=true
   pagehelper.params=count=countSql
   pagehelper.returnPageInfo=check
   
   server.port=8081
   

4. model,dao,service,controller代码

   public class UserDomain {
       private Integer userId;
       private String userName;
       private String password;
       private String phone;
   
       public Integer getUserId() {
           return userId;
       }
   
       public void setUserId(Integer userId) {
           this.userId = userId;
       }
   
       public String getUserName() {
           return userName;
       }
   
       public void setUserName(String userName) {
           this.userName = userName;
       }
   
       public String getPassword() {
           return password;
       }
   
       public void setPassword(String password) {
           this.password = password;
       }
   
       public String getPhone() {
           return phone;
       }
   
       public void setPhone(String phone) {
           this.phone = phone;
       }
   }

   @Mapper
   public interface UserDao {
       int insert(UserDomain record);
   
   
   
       List<UserDomain> selectUsers();
   }
   

   public interface UserService {
       int addUser(UserDomain user);
   
       PageInfo<UserDomain> findAllUser(int pageNum, int pageSize);
   }
   

   @Service
   public class UserServiceImpl implements UserService {
       @Autowired
       private UserDao userDao;
       @Override
       public int addUser(UserDomain user) {
           return userDao.insert(user);
       }
   
       /*
        * 这个方法中用到了我们开头配置依赖的分页插件pagehelper
        * 很简单，只需要在service层传入参数，然后将参数传递给一个插件的一个静态方法即可；
        * pageNum 开始页数
        * pageSize 每页显示的数据条数
        * */
       @Override
       public PageInfo<UserDomain> findAllUser(int pageNum, int pageSize) {
           PageHelper.startPage(pageNum,pageSize);
           List<UserDomain> userDomains = userDao.selectUsers();
           PageInfo result = new PageInfo(userDomains);
           return result;
       }
   }
   

   @Controller
   @RequestMapping(value = "/user")
   public class UserController {
       @Autowired
       private UserService userService;
   
       @ResponseBody
       @PostMapping("/add")
       public int addUser(UserDomain user) {
           return userService.addUser(user);
       }
   
       @ResponseBody
       @GetMapping("/all")
       public Object findAllUser(@RequestParam(name = "pageNum", required = false, defaultValue = "1") int pageNum,
                                 @RequestParam(name = "pageSize", required = false, defaultValue = "10") int pageSize) {
           return userService.findAllUser(pageNum, pageSize);
       }
   
   }
   

    

5. UserMapper.xml代码

   <?xml version="1.0" encoding="UTF-8" ?>
   <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
   <mapper namespace="com.yyq.springbootmybatis.dao.UserDao">
       <insert id="insert" parameterType="com.yyq.springbootmybatis.model.UserDomain">
           INSERT INTO t_user (userName,password,phone) VALUES (#{userName},#{password},#{phone})
       </insert>
       <select id="selectUsers" resultType="com.yyq.springbootmybatis.model.UserDomain">
           SELECT * FROM t_user
       </select>
   </mapper>
   

6. 最终项目结构  
7. 运行结果 

    打开Postman，输入localhost:8081/user/add?userName=hello&password=123456789&phone=11111

打开数据库

OK已经有数据插入了，完美哈哈