1.項目結(jié)構(gòu)：

項目結(jié)構(gòu)

2.父pom.xml配置

<?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>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.3.9.RELEASE</version>
    </parent>

    <groupId>com.lance.demo</groupId>
    <artifactId>com-lance-demo</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>pom</packaging>

</project>

3.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">
    <parent>
        <artifactId>com-lance-demo</artifactId>
        <groupId>com.lance.demo</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>com-lance-mybatis-plus-demo</artifactId>
    <packaging>war</packaging>

    <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</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.0</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <!-- mybatis plus 代碼生成器 -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.3</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
            <version>3.4.1</version>
            <exclusions>
                <exclusion>
                    <artifactId>mybatis-plus-extension</artifactId>
                    <groupId>com.baomidou</groupId>
                </exclusion>
                <exclusion>
                    <artifactId>mybatis</artifactId>
                    <groupId>org.mybatis</groupId>
                </exclusion>
                <exclusion>
                    <artifactId>mybatis-spring</artifactId>
                    <groupId>org.mybatis</groupId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>org.freemarker</groupId>
            <artifactId>freemarker</artifactId>
            <version>2.3.28</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.47</version>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

4.主類：

package com.lance.mybatis.plus.demo;

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

@SpringBootApplication
@MapperScan("com.lance.mybatis.plus.demo.dal.mapper")
public class SpringBootMybatisPlusDemoMain {

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

5.User類：

package com.lance.mybatis.plus.demo.dal.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

@Data
@TableName("user")
public class UserEntity {
    @TableId(type = IdType.AUTO)
    private int id;

    @TableField
    private String name;
}

6.UserMapper類：

package com.lance.mybatis.plus.demo.dal.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lance.mybatis.plus.demo.dal.entity.UserEntity;
import org.springframework.stereotype.Repository;

@Repository
public interface UserMapper extends BaseMapper<UserEntity>{

   @Select("select * from user where name = #{name}")
    List<UserEntity> selectByName(@Param("name") String name);

  @Select("<script> select * from user where id in " +
            "<foreach item=\"userId\" index=\"index\" collection=\"userIds\"\n" +
            "        open=\"(\" separator=\",\" close=\")\" >\n" +
            "        #{userId} </foreach>\n" +

            "  </script>")
    List<UserEntity> selectByUserIds(@Param("userIds") Set<Integer> userIds);

}

7.Service類：

package com.lance.mybatis.plus.demo.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.lance.mybatis.plus.demo.dal.entity.UserEntity;

public interface UserService extends IService<UserEntity> {
}

8.Service實現(xiàn)類：

package com.lance.mybatis.plus.demo.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.lance.mybatis.plus.demo.dal.entity.UserEntity;
import com.lance.mybatis.plus.demo.dal.mapper.UserMapper;
import com.lance.mybatis.plus.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, UserEntity> implements UserService {
    @Autowired
    private UserMapper userMapper;
}

9.yml文件：

server:
  port: 8081
  servlet:
    context-path: /

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://ip:port/dbname?
    username: username
    password: password
    jackson:
      date-format: yyyy-MM-dd HH:mm:ss
      time-zone: GMT+8
      serialization:
        write-dates-as-timestamps: false

mybatis-plus:
  configuration:
    map-underscore-to-camel-case: true
    auto-mapping-behavior: full
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  mapper-locations: classpath*:mapper/**/*Mapper.xml
  global-config:
    # 邏輯刪除配置
    db-config:
      # 刪除前
      logic-not-delete-value: 1
      # 刪除后
      logic-delete-value: 0

10.Mapper單元測試：

package com.lance.mybatis.plus.demo.dal.mapper;

import com.alibaba.fastjson.JSON;
import com.lance.mybatis.plus.demo.SpringBootMybatisPlusDemoMain;
import com.lance.mybatis.plus.demo.dal.entity.UserEntity;
import lombok.extern.slf4j.Slf4j;
import org.assertj.core.util.Lists;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.test.context.web.WebAppConfiguration;

import java.util.List;

@Slf4j
@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest(classes = SpringBootMybatisPlusDemoMain.class)
@WebAppConfiguration
public class UserMapperTest {

    @Autowired
    private UserMapper userMapper;


    @Test
    public void insert() {

        UserEntity userEntity = new UserEntity();
        userEntity.setName("zhangsan");
        userMapper.insert(userEntity);
    }


    @Test
    public void delete() {
        userMapper.deleteById(45);
    }

    @Test
    public void deleteByIds() {
        userMapper.deleteBatchIds(Lists.newArrayList(46));
    }

    @Test
    public void updateById() {
        UserEntity userEntity = new UserEntity();
        userEntity.setId(47);
        userEntity.setName("zhangsan47");
        userMapper.updateById(userEntity);
    }

    @Test
    public void selectById() {
       UserEntity  userEntity = userMapper.selectById(50);
       log.info("userEntity:{}", JSON.toJSONString(userEntity));
    }

    @Test
    public void selectByIds() {
        List<UserEntity>  userEntities = userMapper.selectBatchIds(Lists.newArrayList(50));
        log.info("userEntities:{}", JSON.toJSONString(userEntities));
    }

    @Test
    public void selectPage() {

        QueryWrapper<UserEntity> wrapper=new QueryWrapper<>();
        wrapper.eq("name","zhangsan");

        Page<UserEntity> page = new Page<>(1, 10);

        IPage<UserEntity> pageList = userMapper.selectPage(page,wrapper);

        log.info("pageList:{}", JSON.toJSONString(pageList));
    }

    @Test
    public void selectByName() {
        List<UserEntity>  userEntities = userMapper.selectByName("zhangsan1");
        log.info("userEntities:{}", JSON.toJSONString(userEntities));

    }

}

11.Service的單元測試：

package com.lance.mybatis.plus.demo.service;

import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.lance.mybatis.plus.demo.SpringBootMybatisPlusDemoMain;
import com.lance.mybatis.plus.demo.dal.entity.UserEntity;
import lombok.extern.slf4j.Slf4j;
import org.assertj.core.util.Lists;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.test.context.web.WebAppConfiguration;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Slf4j
@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest(classes = SpringBootMybatisPlusDemoMain.class)
@WebAppConfiguration
public class UserServiceTest {

    @Autowired
    private UserService userService;


    @Test
    public void save() {

        UserEntity userEntity = new UserEntity();
        userEntity.setName("zhangsan-UserService");

        userService.save(userEntity);
    }

    @Test
    public void saveBatch() {

        List<UserEntity> userEntityList = new ArrayList<>();
        UserEntity userEntityEntity1 = new UserEntity();
        userEntityEntity1.setName("zhangsan1");
        userEntityList.add(userEntityEntity1);

        UserEntity userEntityEntity2 = new UserEntity();
        userEntityEntity2.setName("zhangsan2");
        userEntityList.add(userEntityEntity2);

        userService.saveBatch(userEntityList);

    }

    @Test
    public void removeById() {
        userService.removeById(45);
    }

    @Test
    public void removeByIds() {
        userService.removeByIds(Lists.newArrayList(45));
    }

    @Test
    public void batchUpdate() {
        List<UserEntity> userEntityList = new ArrayList<>();
        UserEntity userEntityEntity1 = new UserEntity();
        userEntityEntity1.setId(47);
        userEntityEntity1.setName("zhangsan1");
        userEntityList.add(userEntityEntity1);

        UserEntity userEntityEntity2 = new UserEntity();
        userEntityEntity2.setName("zhangsan2");
        userEntityEntity2.setId(48);
        userEntityList.add(userEntityEntity2);

        userService.updateBatchById(userEntityList);
    }

    @Test
    public void listByIds() {

        List<UserEntity>  userEntities = userService.listByIds(Lists.newArrayList(47,48));
        log.info("userEntities:{}", JSON.toJSONString(userEntities));
    }

    @Test
    public void page() {
        Page<UserEntity> page = new Page<>(1, 10);
        IPage<UserEntity> pageList = userService.page(page);
        log.info("pageList:{}", JSON.toJSONString(pageList));
    }

    @Test
    public void listByMap() {

        Map<String,Object> map = new HashMap<>();
        map.put("name","zhangsan");

        List<UserEntity>  userEntities = userService.listByMap(map);
        log.info("userEntities:{}", JSON.toJSONString(userEntities));
    }

    @Test
    public void pageMaps() {
        Page<Map<String,Object>> page = new Page<>(1,10);
        Map<String,Object> map = new HashMap<>();
        map.put("name","zhangsan");


        Page<Map<String,Object>> pageList = userService.pageMaps(page);
        log.info("pageList:{}", JSON.toJSONString(pageList));
    }

    @Test
    public void selectPage() {

        QueryWrapper<UserEntity> wrapper=new QueryWrapper<>();
        wrapper.eq("name","zhangsan");

        Page<UserEntity> page = new Page<>(1, 10);

        IPage<UserEntity> pageList = userService.page(page,wrapper);

        log.info("pageList:{}", JSON.toJSONString(pageList));
    }



}