a.pedigree_certified AS "pedigreeCertified", a.identify_site AS "identifySite", a.identifier1 AS "identifier1", a.identifier2 AS "identifier2", a.identifier3 AS "identifier3", a.identify_time AS "identifyTime", a.create_time AS "createTime", a.update_time AS "updateTime", a.del_flag AS "delFlag" SELECT FROM dog_appraisal_appraiser a WHERE a.id = #{id} SELECT FROM dog_appraisal_appraiser a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} SELECT FROM dog_appraisal_appraiser a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} INSERT INTO dog_appraisal_appraiser( pedigree_certified, identify_site, identifier1, identifier2, identifier3, identify_time, create_time, update_time, del_flag ) VALUES ( #{pedigreeCertified}, #{identifySite}, #{identifier1}, #{identifier2}, #{identifier3}, #{identifyTime}, #{createTime}, #{updateTime}, #{delFlag} ) UPDATE dog_appraisal_appraiser SET pedigree_certified = #{pedigreeCertified}, identify_site = #{identifySite}, identifier1 = #{identifier1}, identifier2 = #{identifier2}, identifier3 = #{identifier3}, identify_time = #{identifyTime}, create_time = #{createTime}, update_time = #{updateTime} WHERE id = #{id} UPDATE dog_appraisal_appraiser SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} select FROM dog_appraisal_appraiser a where a.pedigree_certified = #{pedigreeCertified}