spring boot 整合mybatis

环境:

eclipse:

Version: 2019-06 (4.12.0)

jdk:

java version "1.8.0_144"

maven:

Apache Maven 3.6.1

步骤:

1.
https://spring.io/projects/spring-boot
到该网页的最下面
找到

Quick start
Bootstrap your application with Spring Initializr.

生成一个spring boot 项目导入到eclipse
目前最新版本2.2.1官方说明文档地址
https://docs.spring.io/spring-boot/docs/2.2.1.RELEASE/reference/html/index.html

2.
导入后启动报错:
No active profile set, falling back to default profiles: default
pom.xml中是因为没有starter
添加依赖
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>
重启
正常启动后的日志
2019-11-18 14:05:37.865  INFO 43628 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  :
 Tomcat started on port(s): 8080 (http) with context path ''
2019-11-18 14:05:37.869  INFO 43628 --- [           main] c.s.s.SecretkeymanagementApplication     :
Started SecretkeymanagementApplication in 2.644 seconds (JVM running for 4.396)

3.
配置这个spring boot 项目
application.yml
添加
server:
  port: 8888
  servlet:
    context-path: /sec
    
注意port: 后面有个空格然后8888后面不允许有空格

正常启动后会有
2019-11-18 14:15:40.212  INFO 44172 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  :
Tomcat started on port(s): 8888 (http) with context path '/sec'
2019-11-18 14:15:40.215  INFO 44172 --- [           main] c.s.s.SecretkeymanagementApplication     :
Started SecretkeymanagementApplication in 2.531 seconds (JVM running for 4.397)

4.
浏览器访问
http://localhost:8888/sec/

页面出现
Whitelabel Error Page

This application has no explicit mapping for /error, so you are seeing this as a fallback.
Mon Nov 18 14:16:21 CST 2019
There was an unexpected error (type=Not Found, status=404).
No message available
暂时先不处理

5.
spring整合mybatis
参考https://blog.csdn.net/iku5200/article/details/82856621

添加 mysql-connector-java <version>5.1.48</version>和 org.mybatis.spring.boot <version>2.1.1</version>的依赖包

6.
在项目中配置多套环境的配置方法
(1)修改application.yml文件,
清空然后添加
spring:
  profiles:
    active: dev

(2)在application.yml同级目录添加application-dev.yml文件
然后添加
server:
  port: 8888
  servlet:
    context-path: /sec
 
spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    driver-class-name: com.mysql.jdbc.Driver
 
mybatis:
  mapper-locations: classpath:mapping/*Mapper.xml
  #type-aliases-package: com.snc.secretkeymanagement.entity
 
#showSql
logging:
  level:
    com:
      snc:
        secretkeymanagement:
          mapper : debug
注释：在Spring Boot中多环境配置文件名需要满足application-{profile}.yml的格式，其中{profile}对应你的环境标识，比如：

application-dev.yml：开发环境
application-test.yml：测试环境
application-prod.yml：生产环境
至于哪个具体的配置文件会被加载，需要在application.yml文件中通过spring.profiles.active属性来设置，其值对应{profile}值.
另外logging:元素是指定com.snc.secretkeymanagement.mapper路径即mapper接口所在路径本例中SecMaskruleMapper.java所在package
在调试模式启动打印mybatis执行的sql

2019-11-22 14:26:48.902 DEBUG 18300 --- [nio-8888-exec-1] c.s.s.m.S.selectByPrimaryKey             : ==>  Preparing: select maskrule_id, name, descript, data_type, mask_type, create_user, create_datetime, last_modified_user, last_modified_time, create_type, id, mode, start_point from sec_maskrule where maskrule_id = ?
2019-11-22 14:26:48.922 DEBUG 18300 --- [nio-8888-exec-1] c.s.s.m.S.selectByPrimaryKey             : ==> Parameters: 1(Long)
2019-11-22 14:26:48.938 DEBUG 18300 --- [nio-8888-exec-1] c.s.s.m.S.selectByPrimaryKey             : <==      Total: 1

7.
创建包及文件夹

(1)在main方法所在类的同级目录创建4个package分别用于controller,service,mapper,entity.
(2)resources下创建 mapping 文件夹，用于写sql语句，也可以用注解的方式直接写在mapper文件里.

8.
使用mybatis-generator-core  生成entity,mapper接口,mapper.xml
自动生成对应文件名称为SecMaskrule.java,SecMaskruleMapper.java,SecMaskruleMapper.xml
生成文件名称的规律
使用mybatis-generator-core 的配置文件generatorConfig.xml中指定表对应生成的domainObjectName,
其他两个文件直接在后面加上Mapper.java与Mapper.xml

<table tableName="sec_maskrule"
       domainObjectName="SecMaskrule"    
       enableCountByExample="false"
       enableUpdateByExample="false"
       enableDeleteByExample="false"    
       enableSelectByExample="false"
       selectByExampleQueryId="false" >    
            <property name="useActualColumnNames" value="false"/>    
</table>  

9.
添加service接口与实现类和controller实现类

启动springboot项目报错

Description:

Field secMaskruleService in com.snc.secretkeymanagement.controller.SecMaskruleController required a bean of type 'com.snc.secretkeymanagement.service.SecMaskruleService' that could not be found.

The injection point has the following annotations:
    - @org.springframework.beans.factory.annotation.Autowired(required=true)

Action:

Consider defining a bean of type 'com.snc.secretkeymanagement.service.SecMaskruleService' in your configuration.

解决办法
在serviceImpl的实现类加上 注解 org.springframework.stereotype.Service;   
添加方式在类上添加@Service

重启报错

Description:

Field secMaskruleMapper in com.snc.secretkeymanagement.service.impl.SecMaskruleServiceImpl required a bean of type 'com.snc.secretkeymanagement.mapper.SecMaskruleMapper' that could not be found.

The injection point has the following annotations:
    - @org.springframework.beans.factory.annotation.Autowired(required=true)

Action:

Consider defining a bean of type 'com.snc.secretkeymanagement.mapper.SecMaskruleMapper' in your configuration.

尝试解决1  
在 自动生成的SecMaskruleMapper.java接口中添加
注解 import org.springframework.stereotype.Repository
@Repository

重启报错

Description:

Field secMaskruleMapper in com.snc.secretkeymanagement.service.impl.SecMaskruleServiceImpl required a bean of type 'com.snc.secretkeymanagement.mapper.SecMaskruleMapper' that could not be found.

The injection point has the following annotations:
    - @org.springframework.beans.factory.annotation.Autowired(required=true)

Action:

Consider defining a bean of type 'com.snc.secretkeymanagement.mapper.SecMaskruleMapper' in your configuration.

依旧报出与尝试解决之前的错误

去掉SecMaskruleMapper.java 上的@Repository注解

尝试解决2
释放
application-dev.yml 配置文件
mybatis:
  mapper-locations: classpath:mapping/*Mapper.xml
  type-aliases-package: com.snc.secretkeymanagement.entity

重启报错
 
  Description:

Field secMaskruleMapper in com.snc.secretkeymanagement.service.impl.SecMaskruleServiceImpl required a bean of type 'com.snc.secretkeymanagement.mapper.SecMaskruleMapper' that could not be found.

The injection point has the following annotations:
    - @org.springframework.beans.factory.annotation.Autowired(required=true)

Action:

Consider defining a bean of type 'com.snc.secretkeymanagement.mapper.SecMaskruleMapper' in your configuration.

 
依旧报出与尝试解决之前的错误
注释掉application-dev.yml 配置文件
#type-aliases-package: com.snc.secretkeymanagement.entity

尝试解决3
在springboot 项目的启动类上加
@MapperScan("com.snc.secretkeymanagement.mapper")
重启启动不在报错

10.
页面访问
http://localhost:8888/sec/SecMaskrule/selectByPrimaryKey?maskruleId=1
页面报错浏览器发请求后台接收不到
Whitelabel Error Page

This application has no explicit mapping for /error, so you are seeing this as a fallback.
Fri Nov 22 11:52:54 CST 2019
There was an unexpected error (type=Not Found, status=404).
No message available

尝试解决1
修改controller 类里的
//@RequestMapping("selectByPrimaryKey/{maskruleId}")
    @RequestMapping("selectByPrimaryKey")
重启访问依旧报错
Whitelabel Error Page

This application has no explicit mapping for /error, so you are seeing this as a fallback.
Fri Nov 22 11:57:10 CST 2019
There was an unexpected error (type=Internal Server Error, status=500).
Missing URI template variable 'maskruleId' for method parameter of type Long

尝试解决2
去掉请求方法(@PathVariable
//SecMaskrule selectByPrimaryKey(@PathVariable Long maskruleId) {
    SecMaskrule selectByPrimaryKey( Long maskruleId) {
重新访问可以得到后台相应的数据

最终发现是URL写法导致
http://localhost:8888/sec/SecMaskrule/selectByPrimaryKey/1
也就是说
http://localhost:8888/sec/SecMaskrule/selectByPrimaryKey?maskruleId=1
对应controller
@RequestMapping("selectByPrimaryKey")
SecMaskrule selectByPrimaryKey( Long maskruleId) {

接收请求路径中占位符的值@PathVariable("maskruleId")
http://localhost:8888/sec/SecMaskrule/selectByPrimaryKey/1
对应controller
@RequestMapping("selectByPrimaryKey/{maskruleId}")
SecMaskrule selectByPrimaryKey(@PathVariable("maskruleId") Long maskruleId) {

简单的spring 整合mybatis便实现了
同步github
https://github.com/zhangxiaoshan123/secretkeymanagement/