<insert id="insertUserFtpLog" parameterType="cn.black.common.model.UserFtpLog" keyProperty="id">
<selectKey resultType="Integer" keyProperty="id" order="AFTER" >
INSERT INTO user_ftp_log(ftp_name,sql_content,error_reason,status,ftp_url,user_id,create_time,create_user,update_time,update_user,total_consume_time)
VALUES(#{ftpName},#{sqlContent},#{errorReason},#{status},#{ftpUrl},#{userId},#{createTime},#{createUserId},#{updateTime},#{updateUserId},#{totalConsumeTime})
<insert id="insertUserFtpLog" parameterType="cn.black.common.model.UserFtpLog" keyProperty="id" useGeneratedKeys="true">
INSERT INTO user_ftp_log(ftp_name,sql_content,error_reason,status,ftp_url,user_id,create_time,create_user,update_time,update_user,total_consume_time)
VALUES(#{ftpName},#{sqlContent},#{errorReason},#{status},#{ftpUrl},#{userId},#{createTime},#{createUserId},#{updateTime},#{updateUserId},#{totalConsumeTime})