Mybatis_获取自增主键的两种方式

    <insert id="createPayment" 
    parameterType="com.xiaozhi.Payment" 
    useGeneratedKeys="true" 
    keyProperty="id">
        insert into payment(serial) values (#{serial})
    </insert>

    <insert id="createPayment" parameterType="com.xiaozhi.Payment" >
        <!--返回值这里是long,是因为实体类中的数据类型是：private Long id-->
        <selectKey resultType="long" keyProperty="id" order="AFTER">
            select LAST_INSERT_ID()
        </selectKey>
        insert into payment(serial) values (#{serial})
    </insert>