（转）Mybatis insert后返回主键给实体对象（Mysql数据库）

<insert id="insert" parameterType="com.zqgame.game.website.models.Team">  
            <selectKey resultType="java.lang.Integer" keyProperty="teamId" order="AFTER">  
                SELECT LAST_INSERT_ID()  
            </selectKey>  
            INSERT INTO kz_team  
            <trim prefix="(" suffix=")" suffixOverrides=",">  
                <if test="teamId != null">  
                    `team_id`,  
                </if>  
                <if test="teamName != null">  
                    `team_name`,  
                </if>  
                <if test="regionId != null">  
                    `region_id`,  
                </if>  
                <if test="provinceId != null">  
                    `province_id`,  
                </if>  
                <if test="cityId != null">  
                    `city_id`,  
                </if>  
                <if test="address != null">  
                    `address`,  
                </if>  
                <if test="idImg != null">  
                    `id_img`,  
                </if>  
                <if test="teamLogo != null">  
                    `team_logo`,  
                </if>  
                <if test="introduce != null">  
                    `introduce`,  
                </if>  
                <if test="accountId != null">  
                    `account_id`,  
                </if>  
            </trim>  
            <trim prefix="values (" suffix=")" suffixOverrides=",">  
                <if test="teamId != null">  
                    #{teamId,jdbcType=INTEGER},  
                </if>  
                <if test="teamName != null">  
                    #{teamName,jdbcType=VARCHAR},  
                </if>  
                <if test="regionId != null">  
                    #{regionId,jdbcType=INTEGER},  
                </if>  
                <if test="provinceId != null">  
                    #{provinceId,jdbcType=INTEGER},  
                </if>  
                <if test="cityId != null">  
                    #{cityId,jdbcType=INTEGER},  
                </if>  
                <if test="address != null">  
                    #{address,jdbcType=VARCHAR},  
                </if>  
                <if test="idImg != null">  
                    #{idImg,jdbcType=VARCHAR},  
                </if>  
                <if test="teamLogo != null">  
                    #{teamLogo,jdbcType=VARCHAR},  
                </if>  
                <if test="introduce != null">  
                    #{introduce,jdbcType=VARCHAR},  
                </if>  
                <if test="accountId != null">  
                    #{accountId,jdbcType=INTEGER},  
                </if>  
            </trim>  
    </insert>

<selectKey resultType="Java.lang.Integer" keyProperty="teamId" order="AFTER"> //teamId实体类主键
SELECT LAST_INSERT_ID()
</selectKey>

或者

给<insert id="xx" useGeneratedKeys="true" keyProperty="teamId"> 加入2个属性就可以省略上面那句<selectKey>xxxxxx</selectKey>

在mybatis中标红的那句话能将插入的主键返回给实体对象

if (StringUtils.isEmpty(team.getTeamLogo())) {  
    team.setTeamLogo(defaultTeamLogo);  
}  
    team.setAccountId(accountId);  
    insert(team);  
   
    System.out.println(team.getTeamId());