SpringBoot整合Mybatis和MySql注意事项

悠悠 2022-02-15 07:53 336阅读 0赞

### SpringBoot整合Mybatis和MySql注意事项 ###

*   *  1、所需依赖
     *  2、添加 application.properties 全局配置文件
     *  3、service层识别不到mapper的解决方案!
     *  4、mybatis报错：org.apache.ibatis.binding.BindingException:Invalid bound statement (not found)的解决方案
     *  5、springboot启动器中加上注解:@MapperScan("mapper所在包路径")

## 1、所需依赖 ##

<dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            
            
            
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.17</version>
            </dependency>
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-api</artifactId>
                <version>1.7.25</version>
            </dependency>
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-log4j12</artifactId>
                <version>1.7.25</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-simple</artifactId>
                <version>1.7.25</version>
                <scope>test</scope>
            </dependency>
            
            
            <dependency>
                <groupId>javax.mail</groupId>
                <artifactId>mail</artifactId>
                <version>1.5.0-b01</version>
            </dependency>
            
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
            </dependency>
    
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-freemarker</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>jstl</artifactId>
            </dependency>
            
            <dependency>
                <groupId>org.apache.tomcat.embed</groupId>
                <artifactId>tomcat-embed-jasper</artifactId>
                <scope>provided</scope>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                
                <version>1.1.1</version>
            </dependency>
    
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.38</version>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.0.9</version>
            </dependency>

## 2、添加 application.properties 全局配置文件 ##

## 设置单个上传文件的大小
    ## spring.http.multipart.maxFileSize=200MB
    ## 设置一次请求上传文件的总容量
    ## spring.http.multipart.maxRequestSize=200MB
    ## 配置jsp访问的前缀
    ## spring.mvc.view.prefix=/WEB-INF/jsp/
    ## 配置jsp访问的后缀
    ## spring.mvc.view.suffix=.jsp
    ## 注意JSP好像不能和thymelea进行兼容!
    ## thymelea模板配置
    ## spring.thymeleaf.prefix=classpath:/templates/
    ## spring.thymeleaf.suffix=.html
    ## spring.thymeleaf.mode=HTML5
    ## spring.thymeleaf.encoding=UTF-8
    #热部署文件，页面不产生缓存，及时更新
    ## spring.thymeleaf.cache=false
    ## spring.resources.chain.strategy.content.enabled=true
    ## spring.resources.chain.strategy.content.paths=/**
    #添加 application.properties 全局配置文件
    # 数据连接池
    spring.datasource.driverClassName=com.mysql.jdbc.Driver
    # 数据库
    spring.datasource.url=jdbc:mysql://localhost:3306/ssm
    # 账号
    spring.datasource.username=root
    # 密码
    spring.datasource.password=root
    # 数据库类型
    spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
    # 给包起别名
    mybatis.type-aliases-package=com.springboot.common.pojo

## 3、service层识别不到mapper的解决方案! ##

在对应的mapper文件中,添加这个注释:**@Repository**  
@Repository将生成的mapper交给spring管理,如果不交给spring管理,会报错,或者直接在mybatis里直接配置bean即可!  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpaHVhaXlhbg_size_16_color_FFFFFF_t_70]

## 4、mybatis报错：org.apache.ibatis.binding.BindingException:Invalid bound statement (not found)的解决方案 ##

因为识别不到对应的sql语句,扫描不到并且没有吧mapper.xml给与spring管理,所以会报错!

<build>
    		<resources>
               <resource>
                   <directory>src/main/java</directory>
                   <excludes>
                       <exclude>**/*.java</exclude>
                   </excludes>
               </resource>
               <resource>
                   <directory>src/main/resources</directory>
                   <includes>
                       <include>**/*.*</include>
                   </includes>
               </resource>
    		  </resources>
        </build>

## 5、springboot启动器中加上注解:@MapperScan(“mapper所在包路径”) ##

package com;
    
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    /**
     * @author huaiyan
     * @create 2019-04-12 11:13
     * @description springboot的启动类 //@MapperScan 用户扫描MyBatis的Mapper接口
     * *@Copyright 该版权归属
    @SpringBootApplication
    @MapperScan("com.springboot.common.dao")
    public class SpringBootDemoApplication {
    
        public static void main(String[] args) {
            SpringApplication.run(SpringBootDemoApplication.class, args);
        }
    
    }

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpaHVhaXlhbg_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpaHVhaXlhbg_size_16_color_FFFFFF_t_70]: /images/20220215/a3e95f111ed64d48862259c36f176867.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpaHVhaXlhbg_size_16_color_FFFFFF_t_70 1]: /images/20220215/caa1b2406fff453ab553f62b7cf12569.png