mybatis 注解方式插入，主键生成

@Mapper
public interface UserMapper
{
    @Insert("insert into tbl_user (name, age) values (#{name}, #{age})")
    @Options(useGeneratedKeys=true, keyProperty="userId", keyColumn="id")
    void insertUser(User user);
} 
 

 

    /**
     * keyProperty: 表示将select返回值设置到该属性中
     * resultType: 返回类型
     * before: 是否在insert之前执行
     * statement: 自定义子查询
     * @param userBase
     */
    @SelectKey(keyProperty = "userBase.id",resultType = String.class, before = true,
            statement = "select replace(uuid(), '-', '')")
    @Options(keyProperty = "userBase.id", useGeneratedKeys = true)
    @Insert("insert into user_base(id, " +
            "name, " +
            "passwd, " +
            "phone " +
            ") values (#{userBase.id}, " +
            "#{userBase.name}, " +
            "#{userBase.password}, " +
            "#{userBase.phone}" +
            ") "
    )
    public void insertForReg(@Param("userBase")UserBase userBase);