a.*
INSERT INTO gen_template(
id,
name,
category,
file_path,
file_name,
content,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{name},
#{category},
#{filePath},
#{fileName},
#{content},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE gen_template SET
name = #{name},
category = #{category},
file_path = #{filePath},
file_name = #{fileName},
content = #{content},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE gen_template SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}