select * from kennel_image where del_flag = '0' and kennel_id = #{kennelId} order by image_type,sort insert into kennel_image ( id, kennel_id, image_type, image_url, sort, remarks, create_by, create_date, update_by, update_date, del_flag ) values ( #{data.id}, #{data.kennelId}, #{data.imageType}, #{data.imageUrl}, #{data.sort}, #{data.remarks}, #{data.createBy.id}, #{data.createDate}, #{data.updateBy.id}, #{data.updateDate}, #{data.delFlag} ) delete from kennel_image where kennel_id = #{kennelId}