Question

MyBatis的insert之后怎么返回自动生成的主键值

Answer 1

<insert id="insert" parameterType="com.qunar.fax.model.qunar.entry.FaxSendNotify" useGeneratedKeys="true" keyProperty="id">
<selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="id">
SELECT LAST_INSERT_ID() AS ID
</selectKey>
INSERT INTO fax_send_notify(
header_action,
taskId,
tel_number,
send_datetime,
duration,
fax_status,
remote_id,
error_msg,
connect_speed,
file_size,
pages,
status,
send_pages,
create_time,
callback_time,
retry_count,
source,
version
)
VALUE(
#{headerAction},
#{taskId},
#{telNumber},
#{sendDatetime},
#{duration},
#{faxStatus},
#{remoteId},
#{errorMsg},
#{connectSpeed},
#{fileSize},
#{pages},
#{status},
#{sendPages},
#{createTime},
#{callBackTime},
#{retryCount},
#{source},
#{version}
)

</insert>

Answer 2

<insert id="insert" parameterType="com.qunar.fax.model.qunar.entry.FaxSendNotify" useGeneratedKeys="true" keyProperty="id">
<selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="id">
SELECT LAST_INSERT_ID() AS ID
</selectKey>
INSERT INTO fax_send_notify(
header_action,
taskId,
tel_number,
send_datetime,
duration,
fax_status,
remote_id,
error_msg,
connect_speed,
file_size,
pages,
status,
send_pages,
create_time,
callback_time,
retry_count,
source,
version
)
VALUE(
#{headerAction},
#{taskId},
#{telNumber},
#{sendDatetime},
#{duration},
#{faxStatus},
#{remoteId},
#{errorMsg},
#{connectSpeed},
#{fileSize},
#{pages},
#{status},
#{sendPages},
#{createTime},
#{callBackTime},
#{retryCount},
#{source},
#{version}
)

</insert>