1.项目结构：
项目结构
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实现类：
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));
}
}
