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

基礎項目的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"表達式內(nèi)是否追加 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在入?yún)⑹荄ate類型時或出現(xiàn)異常的問題

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

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

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

執(zhí)行對應插入操作觀察控制臺

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

可以看到,首先執(zhí)行了查詢UUID的操作,然后將執(zhí)行結果作為插入的主鍵執(zhí)行插入操作.