MyBatis+MySQL 返回插入的主键ID

需求：使用MyBatis往MySQL数据库中插入一条记录后，需要返回该条记录的自增主键值。

方法：在mapper中指定keyProperty属性，示例如下：
JurisdictionMapper.xml

<!-- 添加一条权限 -->    <insert id="addJurisdiction" useGeneratedKeys="true" keyProperty="jurisdiction.id">        INSERT INTO tb_jurisdiction(uuid,organizationSet,userManage,intervieweeManage,facilityManage,interceptManage,dataMaintaining,informationManage,logManage)         VALUES (#{jurisdiction.uuid},#{jurisdiction.organizationSet},#{jurisdiction.userManage},#{jurisdiction.intervieweeManage},#{jurisdiction.facilityManage},         #{jurisdiction.interceptManage},#{jurisdiction.dataMaintaining},#{jurisdiction.informationManage},#{jurisdiction.logManage})    </insert>

java bean

private static final long serialVersionUID = 751672254971015482L;    private int id;    private String uuid;    private int organizationSet;    private int userManage;    private int intervieweeManage;    private int facilityManage;    private int interceptManage;    private int dataMaintaining;    private int informationManage;    private int logManage;    public Jurisdiction(){        this.uuid = UUIDUtil.createUUID();        this.organizationSet = 0;        this.userManage = 0;        this.intervieweeManage = 0;        this.facilityManage = 0;        this.interceptManage = 0;        this.dataMaintaining = 0;        this.informationManage = 0;        this.logManage = 0;    }

java JurisdictionMapper

    /**     * 添加一条权限信息     * @param jurisdiction     */    public int addJurisdiction(@Param("jurisdiction")Jurisdiction jurisdiction);

测试：

public class Test {    @Autowired    private JurisdictionMapper jurisdictionMapper;    @org.junit.Test    public void test(){        Jurisdiction jurisdiction = new Jurisdiction();        int row = jurisdictionMapper.addJurisdiction(jurisdiction);        System.out.println(row);                    //插入的数目        System.out.println(jurisdiction.getId());   //返回的主键    }}