SELECT
FROM user_ftp_log
WHERE id=#{id}
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})
UPDATE user_ftp_log
ftp_name=#{ftpName},
sql_content=#{sqlContent},
error_reason=#{errorReason},
status=#{status},
ftp_url=#{ftpUrl},
user_id=#{userId},
total_consume_time=#{totalConsumeTime},
update_time=#{updateTime},
update_user=#{updateUserId},
DELETE FROM user_ftp_log WHERE id=#{id}
SELECT
FROM user_ftp_log
WHERE 1=1
ORDER BY ${params.orderBy}
LIMIT #{params.page},#{params.pageSize}
SELECT count(1) FROM user_ftp_log WHERE 1=1
Id,ftp_name,sql_content,error_reason,status,ftp_url,user_id,create_time,create_user,update_time,update_user,total_consume_time
and ftp_name like CONCAT('${params.ftpName}','%' )
and status=#{params.status}
#{params.startTime}]]>
