摘要：實現基礎項目的部分代碼如下依賴常用庫依賴驅動及插件依賴阿里依賴阿里依賴具體的配置如下配置通用，詳情請查閱官方文檔是否判斷字符串類型即表達式內是

基礎項目的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的操作,然后將執行結果作為插入的主鍵執行插入操作.