Fluent MyBatis新建记录

Fluent MyBatis新建记录

文章目录

• • 1、代码生成
  • 2、错误分析

1、代码生成

官网文档：https://gitee.com/fluent-mybatis/fluent-mybatis/wikis/

数据库结构表举例

-- 用户表可以添加一个点赞数字段，可选
drop table if exists social_user;
CREATE TABLE social_user (
user_id int(11) NOT NULL comment '用户id',
star_num int(11) NOT NULL default 0 COMMENT '点赞数量',
focus_num int(11) NOT NULL default 0 COMMENT '关注数量',
fan_num int(11) NOT NULL default 0 COMMENT '粉丝数量',
create_time timestamp not null default CURRENT_TIMESTAMP comment '创建时间',
update_time timestamp not null default CURRENT_TIMESTAMP comment '修改时间',
primary key(user_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户点赞表';

在pom.xml中引入相关依赖

        1.8
        1.8.7
    
    

        
            org.springframework.boot
            spring-boot-starter-web
        

        
            org.springframework.boot
            spring-boot-devtools
            runtime
            true
        
        
            mysql
            mysql-connector-java
            runtime
        
        
            org.projectlombok
            lombok
            true
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
        
        
            io.projectreactor
            reactor-test
            test
        
        
        
            com.github.atool
            fluent-mybatis
            ${fluent-mybatis.version}
        
        
        
            com.github.atool
            fluent-mybatis-processor
            provided
            ${fluent-mybatis.version}
        
        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.2.0
        

        
            org.springframework.boot
            spring-boot-starter-test
            RELEASE
            compile
        
    

设置代码生成文件，配置还是比较简单的

package com.zstu.social.utils;

import cn.org.atool.generator.FileGenerator;
import cn.org.atool.generator.annotation.Table;
import cn.org.atool.generator.annotation.Tables;
import org.junit.jupiter.api.Test;

public class EntityGenerator {
    // 数据源 url
    static final String url = "jdbc:mysql://localhost:3306/lamp_social?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8";
    // 数据库用户名
    static final String username = "root";
    // 数据库密码
    static final String password = "root";


    @Test
    public void generate() throws Exception {
        // 引用配置类，build方法允许有多个配置类
        FileGenerator.build(Empty.class);
    }

    @Tables(
            // 设置数据库连接信息
            url = url, username = username, password = password,
            // 设置entity类生成src目录, 相对于 user.dir
            srcDir = "src/main/java",
            // 设置entity类的package值
            basePack = "com.zstu.social.entity",
            // 设置dao接口和实现的src目录, 相对于 user.dir
            daoDir = "src/main/java",
            // 设置哪些表要生成Entity文件
            // tables = {@Table(value = {"social_comment","social_user","social_user_collect_video",
            // "social_user_focus","social_user_like_video","social_video"})},
            tables = {@Table(value = {"social_user"})},
            tablePrefix = "social_",
            logicDeleted = "deleted",
            gmtCreated = "create_time",
            gmtModified = "update_time"
    )
    static class Empty { //类名随便取, 只是配置定义的一个载体
    }
}

点击运行后，此时会生成相应的entity和dao包，此时dao包可能会出现找不到类的错误信息

需要对项目进行编译，完成后在target目录下会自动生成相应包

之后在application.yml配置相关数据

spring:
  # 应用名称
  application:
    name: social
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: root
    url: jdbc:mysql://localhost:3306/lamp_social?useSSL=false&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&rewriteBatchedStatements=true

较为关键一点，需要设置数据源。我之前忘记配置就出错了，这里先配置默认数据源

package com.zstu.social.config;

import cn.org.atool.fluent.mybatis.spring.MapperFactory;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
public class ApplicationConfig {

    //  @Bean("dataSource")
    //  public DruidDataSource newDataSource() {
    //    return DataSourceCreator.create("datasource");
    //  }
    //
    //  @Bean
    //  public SqlSessionFactoryBean sqlSessionFactoryBean() throws Exception {
    //    SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
    //    bean.setDataSource(newDataSource());
    //    ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
    //    // 以下部分根据自己的实际情况配置
    //    // 如果有mybatis原生文件, 请在这里加载
    //    bean.setMapperLocations(resolver.getResources("classpath*:mapper
    //    org.apache.ibatis.session.Configuration configuration =
    //        new org.apache.ibatis.session.Configuration();
    //    configuration.setLazyLoadingEnabled(true);
    //    configuration.setMapUnderscoreToCamelCase(true);
    //    bean.setConfiguration(configuration);
    //    return bean;
    //  }

    // 定义fluent mybatis的MapperFactory
    @Bean
    public MapperFactory mapperFactory() {
        return new MapperFactory();
    }
}

最后在主函数上添加@MapperScan注解

@SpringBootApplication
@MapperScan({"com.zstu.social.entity.mapper"})
public class SocialApplication {

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

测试代码，成功

package com.zstu.social;

import com.zstu.social.entity.entity.UserEntity;
import com.zstu.social.entity.mapper.UserMapper;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
class SocialApplicationTests {

    @Autowired
    UserMapper userMapper;

    @Test
    void contextLoads() {
    }

    @Test
    public void testInsert() {
        UserEntity userEntity = new UserEntity()
                .setUserId(1)
                .setFanNum(2)
                .setFocusNum(3)
                .setStarNum(4);
        userMapper.insertWithPk(userEntity);
    }
}

2、错误分析

1、出现以下错误，需要引入mybatis的maven依赖

 Invalid default: public abstract java.lang.Class org.mybatis.spring.annotation.MapperScan.factoryBean()

    org.mybatis.spring.boot
    mybatis-spring-boot-starter
    2.2.0

2、出现以下错误，代表没配置好数据源

Error invoking SqlProvider method 'public static java.lang.String cn.org.atool.fluent.mybatis.base.provider.SqlProvider.insertWithPk(java.util.Map,org.apache.ibatis.builder.annotation.ProviderContext)' with specify parameter 'class org.apache.ibatis.binding.MapperMethod$ParamMap'.  Cause: cn.org.atool.fluent.mybatis.exception.FluentMybatisException: Please add MapperFactory to spring container management: