springboot整合mybatis使用Mysql实现主键UUID

摘要：实现基础项目的部分代码如下依赖常用库依赖驱动及插件依赖阿里依赖阿里依赖具体的配置如下配置通用，详情请查阅官方文档是否判断字符串类型即表达式内是

基础项目的pom.xml部分代码如下

    
        1.8
    
    
    
        org.springframework.boot
        spring-boot-starter-parent
        1.5.9.RELEASE
    
    
        
        
            org.springframework.boot
            spring-boot-starter-web
        
        
            org.springframework.boot
            spring-boot-starter-jdbc
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
        
        
        
            commons-codec
            commons-codec
        
        
            org.apache.commons
            commons-lang3
            3.6
        
        
            com.google.guava
            guava
            23.0
        
        
        
            mysql
            mysql-connector-java
            runtime
        
        
        
            org.mybatis
            mybatis-spring
            1.3.1
        
        
            org.mybatis
            mybatis
            3.4.5
        
        
            tk.mybatis
            mapper
            3.4.2
        
        
            com.github.pagehelper
            pagehelper
            4.2.1
        
        
        
            com.alibaba
            fastjson
            1.2.44
        
        
        
            com.alibaba
            druid-spring-boot-starter
            1.1.6
        
    

具体的mybatis配置如下

@Bean
    public MapperScannerConfigurer mapperScannerConfigurer() {
        MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
        mapperScannerConfigurer.setSqlSessionFactoryBeanName("sqlSessionFactoryBean");
        mapperScannerConfigurer.setBasePackage(MAPPER_PACKAGE);

        //配置通用Mapper，详情请查阅官方文档
        Properties properties = new Properties();
        properties.setProperty("mappers", MAPPER_INTERFACE_REFERENCE);
        properties.setProperty("notEmpty", "true");//insert、update是否判断字符串类型!="" 即 test="str != null"表达式内是否追加 and str != ""

        properties.setProperty("IDENTITY", "SELECT UUID()");//使用UUID作為主鍵
        properties.setProperty("ORDER","BEFORE");//将查询主键作为前置操作

        mapperScannerConfigurer.setProperties(properties);

        return mapperScannerConfigurer;
    }

实体如下

public class User {
    @Id
    @Column(name = "ID")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private String id;

    @Column(name = "CREATED_BY")
    private String createdBy;

    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Column(name = "CREATED_DATE")
    private Date createdDate;

    @Column(name = "LAST_MODIFIED_BY")
    private String lastModifiedBy;

    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Column(name = "LAST_MODIFIED_DATE")
    private Date lastModifiedDate;

下面这一行代码是为了解决spring MVC在入参是Date类型时或出现异常的问题

@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")

配置文件配置输出mybatis的sql日志

logging.level.com.你的dao或mapper包=debug

执行对应插入操作观察控制台

2018-03-06 17:59:22.612 DEBUG 6208 --- [nio-8686-exec-1] XXXXX: ==>  Executing: SELECT UUID() 
2018-03-06 17:59:22.629 DEBUG 6208 --- [nio-8686-exec-1] XXXXX: <==      Total: 1
2018-03-06 17:59:22.651 DEBUG 6208 --- [nio-8686-exec-1] XXXXX: ==>  Preparing: INSERT INTO user ( ID,USER_NAME,NICK_NAME,PWD_SALT,PWD_LOGIN,CREATED_BY,CREATED_DATE,LAST_MODIFIED_BY,LAST_MODIFIED_DATE,ACCOUNT_TYPE,ACCOUNT_LOCKED,ONLINE_STATUS,GROUP_ID,GROUP_NAME ) VALUES( ?,?,?,?,? ) 
2018-03-06 17:59:22.665 DEBUG 6208 --- [nio-8686-exec-1] XXXXX: ==> Parameters: 0b97ad1b-2125-11e8-9b42-704d7b7036d3(String), 2(String), 2018-01-01 01:07:05.0(Timestamp), 2(String), 2018-01-01 01:07:05.0(Timestamp)
2018-03-06 17:59:22.670 DEBUG 6208 --- [nio-8686-exec-1] XXXXX: <==    Updates: 1

可以看到,首先执行了查询UUID的操作,然后将执行结果作为插入的主键执行插入操作.