mybatis.java

// insert and return id
@Insert("INSERT INTO photo_category (uuid, album_uuid, name, status, addtime, modtime) VALUES (" +
        "REPLACE(UUID(), '-', ''), #{albumUuid}, #{name}, 0, UNIX_TIMESTAMP(), UNIX_TIMESTAMP())")
@SelectKey(before = false, keyProperty = "id", statement = "SELECT LAST_INSERT_ID()", resultType = Integer.class)
void insert(PhotoCategoryDO item);

// return HashMap
@ResultType(value = java.util.HashMap.class)
HashMap getSumDismissionRate(@Param("companyId") String companyId, @Param("yearmo") Integer yearmo);