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

来到golang学习网的大家，相信都是编程学习爱好者，希望在这里学习数据库相关编程知识。下面本篇文章就来带大家聊聊《springboot整合mybatis使用Mysql实现主键UUID》，介绍一下MySQL、Java、uuid、springboot、mybatis，希望对大家的知识积累有所帮助，助力实战开发！

实现

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

    <properties><java.version>1.8</java.version></properties><!-- Inherit defaults from Spring Boot --><parent><groupid>org.springframework.boot</groupid><artifactid>spring-boot-starter-parent</artifactid><version>1.5.9.RELEASE</version></parent><dependencies><!--Spring Boot依赖--><dependency><groupid>org.springframework.boot</groupid><artifactid>spring-boot-starter-web</artifactid></dependency><dependency><groupid>org.springframework.boot</groupid><artifactid>spring-boot-starter-jdbc</artifactid></dependency><dependency><groupid>org.springframework.boot</groupid><artifactid>spring-boot-starter-test</artifactid><scope>test</scope></dependency><!--常用库依赖--><dependency><groupid>commons-codec</groupid><artifactid>commons-codec</artifactid></dependency><dependency><groupid>org.apache.commons</groupid><artifactid>commons-lang3</artifactid><version>3.6</version></dependency><dependency><groupid>com.google.guava</groupid><artifactid>guava</artifactid><version>23.0</version></dependency><!--MySQL JDBC驱动--><dependency><groupid>mysql</groupid><artifactid>mysql-connector-java</artifactid><scope>runtime</scope></dependency><!--MyBatis 及 插件依赖--><dependency><groupid>org.mybatis</groupid><artifactid>mybatis-spring</artifactid><version>1.3.1</version></dependency><dependency><groupid>org.mybatis</groupid><artifactid>mybatis</artifactid><version>3.4.5</version></dependency><dependency><groupid>tk.mybatis</groupid><artifactid>mapper</artifactid><version>3.4.2</version></dependency><dependency><groupid>com.github.pagehelper</groupid><artifactid>pagehelper</artifactid><version>4.2.1</version></dependency><!--阿里 FastJson依赖--><dependency><groupid>com.alibaba</groupid><artifactid>fastjson</artifactid><version>1.2.44</version></dependency><!--阿里 Druid Spring Boot Starter依赖--><dependency><groupid>com.alibaba</groupid><artifactid>druid-spring-boot-starter</artifactid><version>1.1.6</version></dependency></dependencies>

具体的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:   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: 

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

今天带大家了解了MySQL、Java、uuid、springboot、mybatis的相关知识，希望对你有所帮助；关于数据库的技术知识我们会一点点深入介绍，欢迎大家关注golang学习网公众号，一起学习编程~