<insert id="insertFailStrategy" parameterType="com.hellobike.flash.maserati.entity.FailStrategy">
<selectKey keyProperty="id" resultType="java.lang.Long" order="AFTER">
SELECT LAST_INSERT_ID()
</selectKey>
INSERT INTO t_fail_strategy
(
`strategy`,
`retrycnt`,
`retryinterval`,
`dingtalk`,
`mobilephone`,
`mail`,
`createtime`,
`updatetime`
)
VALUES
(
#{strategy},
#{retryCnt},
#{retryInterval},
#{dingTalk},
#{mobilePhone},
#{mail},
NOW(),
NOW()
)
</insert>
但是insert语句的获取ID永远为1, 后来经过查资料得知,不是这样获取自增ID, 这个语句获取的ID是影响的行数,正确的获取ID方法是
xxx.insert(对象A);
对象A.getId();
就可以了