记录一次springboot+mybatis的整合过程

新建一个Spring boot项目

File–>NEW–>project

创建项目的文件结构以及jdk的版本

以jdk1.8

选择项目所需要的依赖，如：SQL

选择项目中所需要依赖的一些，看自己的情况选择

修改项目名，点击finish完成

输入自己想创建的项目名称

首先看下整体的目录结构

看下配置文件，因为我们有很多环境，一般会有多个配置文件

application.yml：

spring:
  profiles:
    active: dev

application-dev.yml：

server:
  port: 8080
  compression:
    enabled: true
    mime-types:
      - application/json
      - application/xml
      - application/javascript
      - text/html
      - text/xml
      - text/plain
      - text/css
    min-response-size: 2048

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/springboot_mybatis?autoReconnect=true&useUnicode=true&characterEncoding=UTF8&serverTimezone=GMT%2B8
    username: root
    password: 123456
    initialSize: 1
    minIdle: 2
    maxActive: 10
    maxWait: 3000
    timeBetweenEvictionRunsMillis: 7200000
    minEvictableIdleTimeMillis: 7200000
    testWhileIdle: true

mybatis:
  mapperLocations: classpath*:/mybatis/mapper/*.xml
  configLocation: classpath:/mybatis/mybatis-config.xml

启动类需要的注解

package com.example.demo;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@MapperScan("com.example.demo.java.mapper")
@SpringBootApplication
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }

}

UserController层

package com.example.demo.java.controller;

import com.example.demo.java.entity.User;
import com.example.demo.java.service.UserService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.servlet.http.HttpServletRequest;
import java.util.List;

/**
 * @Description: $ 类（或接口）是
 * @Author: fxm
 * @Date: $
 */
@RestController
public class UserController {
    private static Logger LOGGER = LoggerFactory.getLogger(UserController.class);

    @Autowired
    UserService userService;

    @GetMapping("/userok")
    public Object ok(HttpServletRequest httpRequest) {
//        List<User> list= userService.queryUserList(1);

        List<User> list= userService.findAll();

        LOGGER.info("list===>"+list);
        //   System.out.println("wwwww===>"+ UserFactoryManager.getCurrentUser());
        //   System.out.println("wwwwwdddddd===>"+UserFactoryManager.getUserId());
        return "ok";
    }
}

UserService层

    package com.example.demo.java.service;
    
    import com.example.demo.java.entity.User;
    import com.example.demo.java.mapper.UserMapper;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import javax.annotation.Resource;
    import java.util.List;
    
    /**
     * @Description: $ 类（或接口）是
     * @Author: fxm
     * @Date: $
     */
    @Service
    public class UserService implements UserIService{
        @Resource
        private UserMapper userMapper;
    
        @Override
        public List<User> queryUserList(int id) {
            return userMapper.queryUserList(id);
        }
    
        @Override
        public List<User> findAll() {
            return userMapper.findAll();
        }
    
    }

mapper层

package com.example.demo.java.mapper;

import com.example.demo.java.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.boot.autoconfigure.security.SecurityProperties;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;

import javax.annotation.Resources;
import java.util.List;

/**
 * @Description: $ 类（或接口）是
 * @Author: yuhua
 * @Date: $
 */
@Repository
public interface UserMapper  extends BaseDAO<User>{

    List<User> queryUserList(@Param("id")int id);
}

持久层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.example.demo.java.mapper.UserMapper">

    <resultMap id="BaseResultMap" type="com.example.demo.java.entity.User">
        <result column="id" jdbcType="INTEGER" property="id" />
        <result column="name" jdbcType="VARCHAR" property="name" />
        <result column="age" jdbcType="INTEGER" property="age" />
        <result column="sex" jdbcType="CHAR" property="sex" />
    </resultMap>

    <select id="queryUserList" resultType="com.example.demo.java.entity.User" parameterType="java.lang.Integer">
        select * from user where id=#{id}
    </select>

    <select id="findAll" resultType="com.example.demo.java.entity.User">
         select * from user
    </select>

</mapper>

mybatis-config.xml配置

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
    <settings>
        <!-- 驼峰的自动映射 -->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
        <setting name="cacheEnabled" value="true" />
        <setting name="useGeneratedKeys" value="true" />
        <setting name="defaultExecutorType" value="REUSE" />
        <setting name="logImpl" value="STDOUT_LOGGING" />
    </settings>
</configuration>

pom文件需要加上mybatis的包

  <!-- mysql -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <!-- mybatis -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-log4j12 -->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>1.7.30</version>
        </dependency>

• 这样上面一个最基础的项目就起来，没有贴出的类都是不需要任何注解的，实体类、basedao等。
• 需要在启动类里加上注解用于给出需要扫描的mapper文件路径@MapperScan(“com.example.demo.java.mapper”)，否则启动不了
• 项目生产的配置文件不是yml文件，直接改成yml文件就可以了
• 配置文件需要根据环境配置，正式项目有多个环境，用于切换：多环境配置文件名需要满足application-{profile}.yml的格式，其中{profile}对应你的环境标识，比如：
  application-dev.yml：开发环境
  application-test.yml：测试环境
  application-prod.yml：生产环境
  等等，至于哪个具体的配置文件会被加载，需要在application.yml文件中通过spring.profiles.active属性来设置，其值对应{profile}值就可以了。
  适合于初学者参考。我也是之前一直只知道使用，没有实际动手搭过，今天记录一下。