mysql+mybatis插入一条数据后返回主键ID

mapper.xml

<insert id="insertImageInfo" parameterType="ImageEntity" useGeneratedKeys="true" keyProperty="id">
        INSERT INTO M_HOMEPAGE
        (
            SEQ,
            IMAGEID,
            DESCRIPTION,
            ISVALID
        )
        VALUES
        (
            #{seq},
            #{imageId},
            #{description},
            #{isValid}
        )
    </insert>

keyProperty属性指定的是DB表的主键

useGenerateKeys属性为true表示DB表的主键时自动增长的（AI）

ImageEntity.java

public class HomePageImageEntity extends BaseEntity {

    private long id;

    private String seq;

    private String imageId;

    private String imageName;

    private String description;

    private String isValid;

    // getter and setter
}

Mapper.java

public interface Mapper{
    public long insertImageInfo(ImageEntity param);
}

java 调用代码

ImageEntity param = new ImageEntity();
// 给param赋值...
mapper.insertImageInfo(param);
long returnId = param.getId();

此时param里的id为刚插入的数据返回的主键ID