开发过程中经常遇到需要插入一条数据，并且返回这条数据自增的主键，在MyBatis中只需要在mapper中添加keyProperty属性即可
在mapper中添加keyProperty属性
<insert id="insertAndGetId" parameterType="com.lili.log.dto.LogPay" useGeneratedKeys="true" keyProperty="payId" >
insert into t_log_pay (payId, orderId, waterNum,
studentId, coachId, payWay,
payMoney, couponMoney, couponId,
payTime)
values (#{payid,jdbcType=INTEGER}, #{orderid,jdbcType=VARCHAR}, #{waternum,jdbcType=VARCHAR},
#{studentid,jdbcType=BIGINT}, #{coachid,jdbcType=BIGINT}, #{payway,jdbcType=VARCHAR},
#{paymoney,jdbcType=DOUBLE}, #{couponmoney,jdbcType=DOUBLE}, #{couponid,jdbcType=INTEGER},
#{paytime,jdbcType=TIMESTAMP})
</insert>