How to use Java Fluent Mybatis to verify operations on the database-javaTutorial-php.cn

How to use Java Fluent Mybatis to verify operations on the database

PHPz

Release： 2023-04-22 18:43:17

forward

1416 people have browsed it

Dependency supplement

It is not enough to follow the official code dependencies. The maven pom file needs to be supplemented here.

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

Copy after login

Database file configuration

Here we still use mysql as the test database. FM (short for fluent mybatis) can support many kinds of databases. We will not consider other databases for the time being.

Add the mysql database configuration in the application.properties file. The use of the druid connection pool will be discussed in later chapters. You can also use application.yml, this is optional.

spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://192.168.0.108:3306/test?useSSL=false&useUnicode=true&characterEncoding=utf-8
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

Copy after login

Test code

Add test code to the test package, mainly to do a simple data insertion test.

The code is as follows:

package com.hy.fmp.test;
 
import com.hy.fmp.Application;
import com.hy.fmp.fluent.entity.TestFluentMybatisEntity;
import com.hy.fmp.fluent.mapper.TestFluentMybatisMapper;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
 
import java.util.Date;
 
@SpringBootTest(classes = Application.class)
public class InsertTest {
  @Autowired TestFluentMybatisMapper testFluentMybatisMapper;
 
  @Test
  public void testInsertDefaultValue() {
    // 插入数据
    testFluentMybatisMapper.insert(
        new TestFluentMybatisEntity()
            .setAge(18)
            .setName("法外狂徒张三")
            .setCreateTime(new Date())
            .setDelFlag(0));
  }
}

Copy after login

Instructions:

1. Note that TestFluentMybatisMapper is the mapper class in the target package.

2. The table entity TestFluentMybatisEntity can be written in chain code.

@Accessors(
    chain = true
)

Copy after login