首页 > 技术文章 > mybatis 注解方式插入,主键由uuid函数生成

nongzihong 2019-07-08 17:51 原文

 

 

 @SelectKey(keyProperty = "record.id", resultType = String.class, before = true,
           statement = "select replace(uuid(), '-', '')")
   @Options(keyProperty = "record.id", useGeneratedKeys = true)
    @Insert("insert into T_USER(ID,OPEN_ID,NICKNANE,AVATARURL,SEX,COUNTRY,PROVINCE,CITY,CTIME,MOBILE) " +
            "values(#{record.id},#{record.openId},#{record.nicknane},#{record.avatarurl},#{record.sex},#{record.country},#{record.province},#{record.city},#{record.ctime},#{record.mobile})")

int insert(@Param("record")TUser record);

 

推荐阅读