MyBatis-Plus

        <!--mybatis-plus依赖-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.0.5</version>
        </dependency>

package com.xiaoye.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.time.LocalDateTime;

/**
 * @author 小也
 * @create 2021/4/22 13:53
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
public class SysUser {
    private Long id;
    private String username;
    private String password;
    private String nickname;
    private Long gender;
    private Long age;
    private Long clazzId;
    private Long isDelete;
    private Long version;
    private LocalDateTime bjtCreate;
    private LocalDateTime bjtModified;              

}

package com.xiaoye.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xiaoye.entity.SysUser;
import org.apache.ibatis.annotations.Mapper;

/**
 * @author 小也
 * @create 2021/4/22 13:56
 */
@Mapper
public interface SysUserMapper extends BaseMapper<SysUser> { 
                                //只要集成了BaseMapper这个父类就可以直接使用很多的单表操作了       
}

//
// Source code recreated from a .class file by IntelliJ IDEA
// (powered by FernFlower decompiler)
//

package com.baomidou.mybatisplus.core.mapper;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.io.Serializable;
import java.util.Collection;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.annotations.Param;

public interface BaseMapper<T> {
    int insert(T var1);

    int deleteById(Serializable var1);

    int deleteByMap(@Param("cm") Map<String, Object> var1);

    int delete(@Param("ew") Wrapper<T> var1);

    int deleteBatchIds(@Param("coll") Collection<? extends Serializable> var1);

    int updateById(@Param("et") T var1);

    int update(@Param("et") T var1, @Param("ew") Wrapper<T> var2);

    T selectById(Serializable var1);

    List<T> selectBatchIds(@Param("coll") Collection<? extends Serializable> var1);

    List<T> selectByMap(@Param("cm") Map<String, Object> var1);

    T selectOne(@Param("ew") Wrapper<T> var1);

    Integer selectCount(@Param("ew") Wrapper<T> var1);

    List<T> selectList(@Param("ew") Wrapper<T> var1);

    List<Map<String, Object>> selectMaps(@Param("ew") Wrapper<T> var1);

    List<Object> selectObjs(@Param("ew") Wrapper<T> var1);

    IPage<T> selectPage(IPage<T> var1, @Param("ew") Wrapper<T> var2);

    IPage<Map<String, Object>> selectMapsPage(IPage<T> var1, @Param("ew") Wrapper<T> var2);
}

package com.xiaoye;

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

/**
 * @author 22944
 */
@SpringBootApplication
@MapperScan("com.xiaoye.mapper")
public class Springboot04MybatisPlusApplication {

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

}

    @TableLogic
    private Integer isDelete;     

package com.xiaoye.config;

import com.baomidou.mybatisplus.core.injector.ISqlInjector;
import com.baomidou.mybatisplus.extension.injector.LogicSqlInjector;
import com.baomidou.mybatisplus.extension.plugins.OptimisticLockerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

/**
 * @author 小也
 * @create 2021/4/22 16:40
 */
@MapperScan("com.xiaoye.mapper")
@Configuration
public class MybatisPlusConfig {

    /**
     * 乐观锁
     * @return
     */
    @Bean
    public OptimisticLockerInterceptor optimisticLockerInterceptor(){
        return new OptimisticLockerInterceptor();
    }

    /**
     * 分页组件
     * @return
     */
    @Bean
    public PaginationInterceptor paginationInterceptor(){return new PaginationInterceptor();}

    /**
     * 逻辑删除
     * @return
     */
    @Bean
    public ISqlInjector iSqlInjector(){return new LogicSqlInjector();}

}

# 开启日志输出
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
#逻辑删除,未删除是0，已删除是1
mybatis-plus.global-config.db-config.logic-not-delete-value=0
mybatis-plus.global-config.db-config.logic-delete-value=1

    @Bean
    public PerformanceInterceptor performanceInterceptor(){
        PerformanceInterceptor performanceInterceptor = new PerformanceInterceptor();
        //这里是毫秒数，设置sql执行的最大时间，超时就停止
        performanceInterceptor.setMaxTime(100);
        //开启sql格式化
        performanceInterceptor.setFormat(true);
        return performanceInterceptor;
    }

package com.xiaoye.util;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.generator.AutoGenerator;
import com.baomidou.mybatisplus.generator.config.DataSourceConfig;
import com.baomidou.mybatisplus.generator.config.GlobalConfig;
import com.baomidou.mybatisplus.generator.config.PackageConfig;
import com.baomidou.mybatisplus.generator.config.StrategyConfig;
import com.baomidou.mybatisplus.generator.config.po.TableFill;
import com.baomidou.mybatisplus.generator.config.rules.DateType;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;

import java.util.ArrayList;

/**
 * @author 小也
 * @create 2021/4/22 19:37
 */
public class AutoCoding {
    private static final String DATA_SOURCE_DRIVER = "com.mysql.cj.jdbc.Driver";
    private static final String DATA_SOURCE_URL = "jdbc:mysql://localhost:3306/sbs?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC";
    private static final String DATA_SOURCE_USERNAME = "root";
    private static final String DATA_SOURCE_PASSWORD = "root";
    private static final String MODULE_NAME = "sys";
    private static final String MODULE_PARENT_NAME  = "com.xiaoye";
    private static final String TABLE_NAME = "sys_user";
    private static final String LOGIC_DELETE_NAME = "is_delete";
    private static final String GMT_CREATE = "bjt_create";
    private static final String GMT_MODIFIED = "bjt_modified";
    private static final String OPTIMISTIC_LOCK_NAME = "version";

    public static void main(String[] args) {
        //创建自动代码生成对象
        AutoGenerator autoGenerator = new AutoGenerator();

        //1、全局配置

        GlobalConfig globalConfig = new GlobalConfig();
        //设置作者
        globalConfig.setAuthor("xiaoye");
        //获取当前项目路径
        String properties = System.getProperty("user.dir");
        //设置输出路径
        globalConfig.setOutputDir(properties + "/src/main/java");
        //不要打开资源管理器
        globalConfig.setOpen(false);
        //不覆盖原文件
        globalConfig.setFileOverride(false);
        //service接口不带I前缀
        globalConfig.setServiceName("%sService");
        //设置id自增
        globalConfig.setIdType(IdType.AUTO);
        //设置时间格式
        globalConfig.setDateType(DateType.TIME_PACK);
        //配置swagger2文档
        globalConfig.setSwagger2(true);
        //设置mapper.xml生成一个RestMap
        globalConfig.setBaseResultMap(true);

        autoGenerator.setGlobalConfig(globalConfig);



        //2、数据源配置

        DataSourceConfig dataSourceConfig = new DataSourceConfig();
        dataSourceConfig.setDbType(DbType.MYSQL);
        dataSourceConfig.setDriverName(DATA_SOURCE_DRIVER);
        dataSourceConfig.setUrl(DATA_SOURCE_URL);
        dataSourceConfig.setUsername(DATA_SOURCE_USERNAME);
        dataSourceConfig.setPassword(DATA_SOURCE_PASSWORD);

        autoGenerator.setDataSource(dataSourceConfig);



        //3、生成包配置
        PackageConfig packageConfig = new PackageConfig();

        packageConfig.setModuleName(MODULE_NAME);
        packageConfig.setParent(MODULE_PARENT_NAME);
        packageConfig.setEntity("entity");
        packageConfig.setMapper("mapper");
        packageConfig.setService("service");
        packageConfig.setController("controller");

        autoGenerator.setPackageInfo(packageConfig);




        //4、策略配置
        StrategyConfig strategyConfig = new StrategyConfig();

        //要映射的表名
        strategyConfig.setInclude(TABLE_NAME);
        //下划线转驼峰命名
        strategyConfig.setNaming(NamingStrategy.underline_to_camel);
        //下划线转驼峰命名
        strategyConfig.setColumnNaming(NamingStrategy.underline_to_camel);
        //开启lombok
        strategyConfig.setEntityLombokModel(true);
        //开启逻辑删除名字
        strategyConfig.setLogicDeleteFieldName(LOGIC_DELETE_NAME);

        //自动填充设置
        TableFill bjtCreate = new TableFill(GMT_CREATE, FieldFill.INSERT);
        TableFill bjtModified = new TableFill(GMT_MODIFIED, FieldFill.INSERT_UPDATE);
        ArrayList<TableFill> tableFieldList = new ArrayList<>();
        tableFieldList.add(bjtCreate);
        tableFieldList.add(bjtModified);
        strategyConfig.setTableFillList(tableFieldList);

        //乐观锁配置
        strategyConfig.setVersionFieldName(OPTIMISTIC_LOCK_NAME);
        //restFul风格
        strategyConfig.setRestControllerStyle(true);
        //下划线url
        strategyConfig.setControllerMappingHyphenStyle(true);

        autoGenerator.setStrategy(strategyConfig);


        //开始执行代码生成
        autoGenerator.execute();
    }
}