【MySQL】selectKey获取insert后的自动主键

  <insert id="insert" parameterType="cc.mrbird.febs.energy.domain.ChatGroup">
  <selectKey keyProperty="id" order="AFTER" resultType="java.lang.Long">
      select LAST_INSERT_ID()
  </selectKey>
    insert into chat_group (id, group_index, group_name, 
      member_id)
    values (#{id,jdbcType=BIGINT}, #{groupIndex,jdbcType=VARCHAR}, #{groupName,jdbcType=VARCHAR}, 
      #{memberId,jdbcType=BIGINT})
  </insert>

public class ChatGroup implements Serializable {
    private Long id;

    private String groupIndex;

    private String groupName;

    private Long memberId;

    private static final long serialVersionUID = 1L;
}