id, dogvalid, dogtype, shows, logout, birth_certificate_reg_num, pedigree_num, dog_owner, member_num, dog_second_owenr, second_owenr_member_num, breeder, dog_eg_name, dog_cn_name, dog_gender, dog_type, dog_birthday, identifi_sign, coat_texture, color_mark, special_mark, hip_joint_identifi_result, elbow_joint_identifi_result, dna, breeding_qualifi, kin_breeding, show_level, show_result, test_level, test_score, file_num, f_pedigree_num, m_pedigree_num, f_m_pedigree_num, inbreeding_seal, old_studbook_num, overseas_reg_certifi, add_data, modifi_data, breeders_memb_num, del_tag, print_type, pay_dna, pay_fy, pay_hd, three_no, dog_genertions, fanyu_confirm dog_critique, remark, operator, running_num select 身份识别标志 identifi_sign FROM dog where 血统证书号=#{ckuZsid} SELECT dog.id , dog.dogValid dogvalid, dog.dogType dogtype, dog.show shows, dog.logout logout, dog.出生证明登记编号 birth_certificate_reg_num, dog.血统证书号 pedigree_num, dog.犬主人 dog_owner, dog.会员号 member_num, dog.第二犬主 dog_second_owenr, dog.第二犬主会员号 second_owenr_member_num, dog.繁殖人 breeder, dog.英文姓名 dog_eg_name, dog.中文姓名 dog_cn_name, dog.性别 dog_gender, dog.种类 dog_type, dog.出生日期 dog_birthday, dog.身份识别标志 identifi_sign, dog.毛质 coat_texture, dog.颜色及标志 color_mark, dog.特殊标记 special_mark, dog.髋关节鉴定结果 hip_joint_identifi_result, dog.肘关节鉴定结果 elbow_joint_identifi_result, dog.DNA dna, dog.繁殖资格 breeding_qualifi, dog.近亲繁殖 kin_breeding, dog.比赛级别 show_level, dog.比赛成绩 show_result, dog.考试级别 test_level, dog.考试成绩 test_score, dog.档号 file_num, dog.父犬血统证号 f_pedigree_num, dog.母犬血统证号 m_pedigree_num, dog.父母犬配犬证明号 f_m_pedigree_num, dog.近亲繁殖打印 inbreeding_seal, dog.旧血统证书号 old_studbook_num, dog.国外登记证书号 overseas_reg_certifi, dog.添加日期 add_data, dog.修改日期 modifi_data, dog.繁殖人会员号 breeders_memb_num, dog.del_tag, dog.print_type, dog.pay_DNA pay_dna, dog.pay_fy, dog.pay_hd, dog.three_no, dog.dogGenerations dog_genertions, dog.fanyu_Confirm fanyu_confirm, dog.裁判评价 dog_critique, cod.犬种类中文名称 cn_name, cod.组 typeGroup, cod.犬种类英文名称 type_eg_name FROM dog dog LEFT JOIN tab_dog_class_code cod ON dog.种类 = cod.犬种类代码 WHERE dog.血统证书号 = #{pedigreeNum} or dog.身份识别标志 = #{dogId} SELECT dog.id , dog.dogValid dogvalid, dog.dogType dogtype, dog.show shows, dog.logout logout, dog.出生证明登记编号 birth_certificate_reg_num, dog.血统证书号 pedigree_num, dog.犬主人 dog_owner, dog.会员号 member_num, dog.第二犬主 dog_second_owenr, dog.第二犬主会员号 second_owenr_member_num, dog.繁殖人 breeder, dog.英文姓名 dog_eg_name, dog.中文姓名 dog_cn_name, dog.性别 dog_gender, dog.种类 dog_type, dog.出生日期 dog_birthday, dog.身份识别标志 identifi_sign, dog.毛质 coat_texture, dog.颜色及标志 color_mark, dog.特殊标记 special_mark, dog.髋关节鉴定结果 hip_joint_identifi_result, dog.肘关节鉴定结果 elbow_joint_identifi_result, dog.DNA dna, dog.繁殖资格 breeding_qualifi, dog.近亲繁殖 kin_breeding, dog.比赛级别 show_level, dog.比赛成绩 show_result, dog.考试级别 test_level, dog.考试成绩 test_score, dog.档号 file_num, dog.父犬血统证号 f_pedigree_num, dog.母犬血统证号 m_pedigree_num, dog.父母犬配犬证明号 f_m_pedigree_num, dog.近亲繁殖打印 inbreeding_seal, dog.旧血统证书号 old_studbook_num, dog.国外登记证书号 overseas_reg_certifi, dog.添加日期 add_data, dog.修改日期 modifi_data, dog.繁殖人会员号 breeders_memb_num, dog.del_tag, dog.print_type, dog.pay_DNA pay_dna, dog.pay_fy, dog.pay_hd, dog.three_no, dog.dogGenerations dog_genertions, dog.fanyu_Confirm fanyu_confirm FROM ( SELECT * FROM dog WHERE 血统证书号 = #{pedigreeNum} ) dog WHERE dog.血统证书号 IN ( SELECT 血统证书号 FROM dog WHERE 会员号 = #{userNum} ) SELECT dog.id , dog.dogValid dogvalid, dog.dogType dogtype, dog.show shows, dog.logout logout, dog.出生证明登记编号 birth_certificate_reg_num, dog.血统证书号 pedigree_num, dog.犬主人 dog_owner, dog.会员号 member_num, dog.第二犬主 dog_second_owenr, dog.第二犬主会员号 second_owenr_member_num, dog.繁殖人 breeder, dog.英文姓名 dog_eg_name, dog.中文姓名 dog_cn_name, dog.性别 dog_gender, dog.种类 dog_type, dog.出生日期 dog_birthday, dog.身份识别标志 identifi_sign, dog.毛质 coat_texture, dog.颜色及标志 color_mark, dog.特殊标记 special_mark, dog.髋关节鉴定结果 hip_joint_identifi_result, dog.肘关节鉴定结果 elbow_joint_identifi_result, dog.DNA dna, dog.繁殖资格 breeding_qualifi, dog.近亲繁殖 kin_breeding, dog.比赛级别 show_level, dog.比赛成绩 show_result, dog.考试级别 test_level, dog.考试成绩 test_score, dog.档号 file_num, dog.父犬血统证号 f_pedigree_num, dog.母犬血统证号 m_pedigree_num, dog.父母犬配犬证明号 f_m_pedigree_num, dog.近亲繁殖打印 inbreeding_seal, dog.旧血统证书号 old_studbook_num, dog.国外登记证书号 overseas_reg_certifi, dog.添加日期 add_data, dog.修改日期 modifi_data, dog.繁殖人会员号 breeders_memb_num, dog.del_tag, dog.print_type, dog.pay_DNA pay_dna, dog.pay_fy, dog.pay_hd, dog.three_no, dog.dogGenerations dog_genertions, dog.fanyu_Confirm fanyu_confirm, cod.犬种类中文名称 cn_name FROM dog dog LEFT JOIN tab_dog_class_code cod ON dog.种类 = cod.犬种类代码 WHERE dog.会员号 = #{userNum} order by dog.id desc delete from cku_dog where id = #{id,jdbcType=INTEGER} insert into cku_dog (id, dogvalid, dogtype, shows, logout, birth_certificate_reg_num, pedigree_num, dog_owner, member_num, dog_second_owenr, second_owenr_member_num, breeder, dog_eg_name, dog_cn_name, dog_gender, dog_type, dog_birthday, identifi_sign, coat_texture, color_mark, special_mark, hip_joint_identifi_result, elbow_joint_identifi_result, dna, breeding_qualifi, kin_breeding, show_level, show_result, test_level, test_score, file_num, f_pedigree_num, m_pedigree_num, f_m_pedigree_num, inbreeding_seal, old_studbook_num, overseas_reg_certifi, add_data, modifi_data, breeders_memb_num, del_tag, print_type, pay_dna, pay_fy, pay_hd, three_no, dog_genertions, fanyu_confirm, dog_critique, remark, operator, running_num) values (#{id,jdbcType=INTEGER}, #{dogvalid,jdbcType=VARCHAR}, #{dogtype,jdbcType=VARCHAR}, #{shows,jdbcType=VARCHAR}, #{logout,jdbcType=VARCHAR}, #{birthCertificateRegNum,jdbcType=VARCHAR}, #{pedigreeNum,jdbcType=VARCHAR}, #{dogOwner,jdbcType=VARCHAR}, #{memberNum,jdbcType=VARCHAR}, #{dogSecondOwenr,jdbcType=VARCHAR}, #{secondOwenrMemberNum,jdbcType=VARCHAR}, #{breeder,jdbcType=VARCHAR}, #{dogEgName,jdbcType=VARCHAR}, #{dogCnName,jdbcType=VARCHAR}, #{dogGender,jdbcType=VARCHAR}, #{dogType,jdbcType=VARCHAR}, #{dogBirthday,jdbcType=TIMESTAMP}, #{identifiSign,jdbcType=VARCHAR}, #{coatTexture,jdbcType=VARCHAR}, #{colorMark,jdbcType=VARCHAR}, #{specialMark,jdbcType=VARCHAR}, #{hipJointIdentifiResult,jdbcType=VARCHAR}, #{elbowJointIdentifiResult,jdbcType=VARCHAR}, #{dna,jdbcType=VARCHAR}, #{breedingQualifi,jdbcType=VARCHAR}, #{kinBreeding,jdbcType=VARCHAR}, #{showLevel,jdbcType=VARCHAR}, #{showResult,jdbcType=VARCHAR}, #{testLevel,jdbcType=VARCHAR}, #{testScore,jdbcType=VARCHAR}, #{fileNum,jdbcType=VARCHAR}, #{fPedigreeNum,jdbcType=VARCHAR}, #{mPedigreeNum,jdbcType=VARCHAR}, #{fMPedigreeNum,jdbcType=VARCHAR}, #{inbreedingSeal,jdbcType=VARCHAR}, #{oldStudbookNum,jdbcType=VARCHAR}, #{overseasRegCertifi,jdbcType=VARCHAR}, #{addData,jdbcType=TIMESTAMP}, #{modifiData,jdbcType=TIMESTAMP}, #{breedersMembNum,jdbcType=VARCHAR}, #{delTag,jdbcType=VARCHAR}, #{printType,jdbcType=VARCHAR}, #{payDna,jdbcType=VARCHAR}, #{payFy,jdbcType=VARCHAR}, #{payHd,jdbcType=VARCHAR}, #{threeNo,jdbcType=INTEGER}, #{dogGenertions,jdbcType=INTEGER}, #{fanyuConfirm,jdbcType=VARCHAR}, #{dogCritique,jdbcType=LONGVARCHAR}, #{remark,jdbcType=LONGVARCHAR}, #{operator,jdbcType=LONGVARCHAR}, #{runningNum,jdbcType=LONGVARCHAR}) insert into cku_dog id, dogvalid, dogtype, shows, logout, birth_certificate_reg_num, pedigree_num, dog_owner, member_num, dog_second_owenr, second_owenr_member_num, breeder, dog_eg_name, dog_cn_name, dog_gender, dog_type, dog_birthday, identifi_sign, coat_texture, color_mark, special_mark, hip_joint_identifi_result, elbow_joint_identifi_result, dna, breeding_qualifi, kin_breeding, show_level, show_result, test_level, test_score, file_num, f_pedigree_num, m_pedigree_num, f_m_pedigree_num, inbreeding_seal, old_studbook_num, overseas_reg_certifi, add_data, modifi_data, breeders_memb_num, del_tag, print_type, pay_dna, pay_fy, pay_hd, three_no, dog_genertions, fanyu_confirm, dog_critique, remark, operator, running_num, #{id,jdbcType=INTEGER}, #{dogvalid,jdbcType=VARCHAR}, #{dogtype,jdbcType=VARCHAR}, #{shows,jdbcType=VARCHAR}, #{logout,jdbcType=VARCHAR}, #{birthCertificateRegNum,jdbcType=VARCHAR}, #{pedigreeNum,jdbcType=VARCHAR}, #{dogOwner,jdbcType=VARCHAR}, #{memberNum,jdbcType=VARCHAR}, #{dogSecondOwenr,jdbcType=VARCHAR}, #{secondOwenrMemberNum,jdbcType=VARCHAR}, #{breeder,jdbcType=VARCHAR}, #{dogEgName,jdbcType=VARCHAR}, #{dogCnName,jdbcType=VARCHAR}, #{dogGender,jdbcType=VARCHAR}, #{dogType,jdbcType=VARCHAR}, #{dogBirthday,jdbcType=TIMESTAMP}, #{identifiSign,jdbcType=VARCHAR}, #{coatTexture,jdbcType=VARCHAR}, #{colorMark,jdbcType=VARCHAR}, #{specialMark,jdbcType=VARCHAR}, #{hipJointIdentifiResult,jdbcType=VARCHAR}, #{elbowJointIdentifiResult,jdbcType=VARCHAR}, #{dna,jdbcType=VARCHAR}, #{breedingQualifi,jdbcType=VARCHAR}, #{kinBreeding,jdbcType=VARCHAR}, #{showLevel,jdbcType=VARCHAR}, #{showResult,jdbcType=VARCHAR}, #{testLevel,jdbcType=VARCHAR}, #{testScore,jdbcType=VARCHAR}, #{fileNum,jdbcType=VARCHAR}, #{fPedigreeNum,jdbcType=VARCHAR}, #{mPedigreeNum,jdbcType=VARCHAR}, #{fMPedigreeNum,jdbcType=VARCHAR}, #{inbreedingSeal,jdbcType=VARCHAR}, #{oldStudbookNum,jdbcType=VARCHAR}, #{overseasRegCertifi,jdbcType=VARCHAR}, #{addData,jdbcType=TIMESTAMP}, #{modifiData,jdbcType=TIMESTAMP}, #{breedersMembNum,jdbcType=VARCHAR}, #{delTag,jdbcType=VARCHAR}, #{printType,jdbcType=VARCHAR}, #{payDna,jdbcType=VARCHAR}, #{payFy,jdbcType=VARCHAR}, #{payHd,jdbcType=VARCHAR}, #{threeNo,jdbcType=INTEGER}, #{dogGenertions,jdbcType=INTEGER}, #{fanyuConfirm,jdbcType=VARCHAR}, #{dogCritique,jdbcType=LONGVARCHAR}, #{remark,jdbcType=LONGVARCHAR}, #{operator,jdbcType=LONGVARCHAR}, #{runningNum,jdbcType=LONGVARCHAR}, update cku_dog dogvalid = #{dogvalid,jdbcType=VARCHAR}, dogtype = #{dogtype,jdbcType=VARCHAR}, shows = #{shows,jdbcType=VARCHAR}, logout = #{logout,jdbcType=VARCHAR}, birth_certificate_reg_num = #{birthCertificateRegNum,jdbcType=VARCHAR}, pedigree_num = #{pedigreeNum,jdbcType=VARCHAR}, dog_owner = #{dogOwner,jdbcType=VARCHAR}, member_num = #{memberNum,jdbcType=VARCHAR}, dog_second_owenr = #{dogSecondOwenr,jdbcType=VARCHAR}, second_owenr_member_num = #{secondOwenrMemberNum,jdbcType=VARCHAR}, breeder = #{breeder,jdbcType=VARCHAR}, dog_eg_name = #{dogEgName,jdbcType=VARCHAR}, dog_cn_name = #{dogCnName,jdbcType=VARCHAR}, dog_gender = #{dogGender,jdbcType=VARCHAR}, dog_type = #{dogType,jdbcType=VARCHAR}, dog_birthday = #{dogBirthday,jdbcType=TIMESTAMP}, identifi_sign = #{identifiSign,jdbcType=VARCHAR}, coat_texture = #{coatTexture,jdbcType=VARCHAR}, color_mark = #{colorMark,jdbcType=VARCHAR}, special_mark = #{specialMark,jdbcType=VARCHAR}, hip_joint_identifi_result = #{hipJointIdentifiResult,jdbcType=VARCHAR}, elbow_joint_identifi_result = #{elbowJointIdentifiResult,jdbcType=VARCHAR}, dna = #{dna,jdbcType=VARCHAR}, breeding_qualifi = #{breedingQualifi,jdbcType=VARCHAR}, kin_breeding = #{kinBreeding,jdbcType=VARCHAR}, show_level = #{showLevel,jdbcType=VARCHAR}, show_result = #{showResult,jdbcType=VARCHAR}, test_level = #{testLevel,jdbcType=VARCHAR}, test_score = #{testScore,jdbcType=VARCHAR}, file_num = #{fileNum,jdbcType=VARCHAR}, f_pedigree_num = #{fPedigreeNum,jdbcType=VARCHAR}, m_pedigree_num = #{mPedigreeNum,jdbcType=VARCHAR}, f_m_pedigree_num = #{fMPedigreeNum,jdbcType=VARCHAR}, inbreeding_seal = #{inbreedingSeal,jdbcType=VARCHAR}, old_studbook_num = #{oldStudbookNum,jdbcType=VARCHAR}, overseas_reg_certifi = #{overseasRegCertifi,jdbcType=VARCHAR}, add_data = #{addData,jdbcType=TIMESTAMP}, modifi_data = #{modifiData,jdbcType=TIMESTAMP}, breeders_memb_num = #{breedersMembNum,jdbcType=VARCHAR}, del_tag = #{delTag,jdbcType=VARCHAR}, print_type = #{printType,jdbcType=VARCHAR}, pay_dna = #{payDna,jdbcType=VARCHAR}, pay_fy = #{payFy,jdbcType=VARCHAR}, pay_hd = #{payHd,jdbcType=VARCHAR}, three_no = #{threeNo,jdbcType=INTEGER}, dog_genertions = #{dogGenertions,jdbcType=INTEGER}, fanyu_confirm = #{fanyuConfirm,jdbcType=VARCHAR}, dog_critique = #{dogCritique,jdbcType=LONGVARCHAR}, remark = #{remark,jdbcType=LONGVARCHAR}, operator = #{operator,jdbcType=LONGVARCHAR}, running_num = #{runningNum,jdbcType=LONGVARCHAR}, where id = #{id,jdbcType=INTEGER} update cku_dog set dogvalid = #{dogvalid,jdbcType=VARCHAR}, dogtype = #{dogtype,jdbcType=VARCHAR}, shows = #{shows,jdbcType=VARCHAR}, logout = #{logout,jdbcType=VARCHAR}, birth_certificate_reg_num = #{birthCertificateRegNum,jdbcType=VARCHAR}, pedigree_num = #{pedigreeNum,jdbcType=VARCHAR}, dog_owner = #{dogOwner,jdbcType=VARCHAR}, member_num = #{memberNum,jdbcType=VARCHAR}, dog_second_owenr = #{dogSecondOwenr,jdbcType=VARCHAR}, second_owenr_member_num = #{secondOwenrMemberNum,jdbcType=VARCHAR}, breeder = #{breeder,jdbcType=VARCHAR}, dog_eg_name = #{dogEgName,jdbcType=VARCHAR}, dog_cn_name = #{dogCnName,jdbcType=VARCHAR}, dog_gender = #{dogGender,jdbcType=VARCHAR}, dog_type = #{dogType,jdbcType=VARCHAR}, dog_birthday = #{dogBirthday,jdbcType=TIMESTAMP}, identifi_sign = #{identifiSign,jdbcType=VARCHAR}, coat_texture = #{coatTexture,jdbcType=VARCHAR}, color_mark = #{colorMark,jdbcType=VARCHAR}, special_mark = #{specialMark,jdbcType=VARCHAR}, hip_joint_identifi_result = #{hipJointIdentifiResult,jdbcType=VARCHAR}, elbow_joint_identifi_result = #{elbowJointIdentifiResult,jdbcType=VARCHAR}, dna = #{dna,jdbcType=VARCHAR}, breeding_qualifi = #{breedingQualifi,jdbcType=VARCHAR}, kin_breeding = #{kinBreeding,jdbcType=VARCHAR}, show_level = #{showLevel,jdbcType=VARCHAR}, show_result = #{showResult,jdbcType=VARCHAR}, test_level = #{testLevel,jdbcType=VARCHAR}, test_score = #{testScore,jdbcType=VARCHAR}, file_num = #{fileNum,jdbcType=VARCHAR}, f_pedigree_num = #{fPedigreeNum,jdbcType=VARCHAR}, m_pedigree_num = #{mPedigreeNum,jdbcType=VARCHAR}, f_m_pedigree_num = #{fMPedigreeNum,jdbcType=VARCHAR}, inbreeding_seal = #{inbreedingSeal,jdbcType=VARCHAR}, old_studbook_num = #{oldStudbookNum,jdbcType=VARCHAR}, overseas_reg_certifi = #{overseasRegCertifi,jdbcType=VARCHAR}, add_data = #{addData,jdbcType=TIMESTAMP}, modifi_data = #{modifiData,jdbcType=TIMESTAMP}, breeders_memb_num = #{breedersMembNum,jdbcType=VARCHAR}, del_tag = #{delTag,jdbcType=VARCHAR}, print_type = #{printType,jdbcType=VARCHAR}, pay_dna = #{payDna,jdbcType=VARCHAR}, pay_fy = #{payFy,jdbcType=VARCHAR}, pay_hd = #{payHd,jdbcType=VARCHAR}, three_no = #{threeNo,jdbcType=INTEGER}, dog_genertions = #{dogGenertions,jdbcType=INTEGER}, fanyu_confirm = #{fanyuConfirm,jdbcType=VARCHAR}, dog_critique = #{dogCritique,jdbcType=LONGVARCHAR}, remark = #{remark,jdbcType=LONGVARCHAR}, operator = #{operator,jdbcType=LONGVARCHAR}, running_num = #{runningNum,jdbcType=LONGVARCHAR} where id = #{id,jdbcType=INTEGER} update cku_dog set dogvalid = #{dogvalid,jdbcType=VARCHAR}, dogtype = #{dogtype,jdbcType=VARCHAR}, shows = #{shows,jdbcType=VARCHAR}, logout = #{logout,jdbcType=VARCHAR}, birth_certificate_reg_num = #{birthCertificateRegNum,jdbcType=VARCHAR}, pedigree_num = #{pedigreeNum,jdbcType=VARCHAR}, dog_owner = #{dogOwner,jdbcType=VARCHAR}, member_num = #{memberNum,jdbcType=VARCHAR}, dog_second_owenr = #{dogSecondOwenr,jdbcType=VARCHAR}, second_owenr_member_num = #{secondOwenrMemberNum,jdbcType=VARCHAR}, breeder = #{breeder,jdbcType=VARCHAR}, dog_eg_name = #{dogEgName,jdbcType=VARCHAR}, dog_cn_name = #{dogCnName,jdbcType=VARCHAR}, dog_gender = #{dogGender,jdbcType=VARCHAR}, dog_type = #{dogType,jdbcType=VARCHAR}, dog_birthday = #{dogBirthday,jdbcType=TIMESTAMP}, identifi_sign = #{identifiSign,jdbcType=VARCHAR}, coat_texture = #{coatTexture,jdbcType=VARCHAR}, color_mark = #{colorMark,jdbcType=VARCHAR}, special_mark = #{specialMark,jdbcType=VARCHAR}, hip_joint_identifi_result = #{hipJointIdentifiResult,jdbcType=VARCHAR}, elbow_joint_identifi_result = #{elbowJointIdentifiResult,jdbcType=VARCHAR}, dna = #{dna,jdbcType=VARCHAR}, breeding_qualifi = #{breedingQualifi,jdbcType=VARCHAR}, kin_breeding = #{kinBreeding,jdbcType=VARCHAR}, show_level = #{showLevel,jdbcType=VARCHAR}, show_result = #{showResult,jdbcType=VARCHAR}, test_level = #{testLevel,jdbcType=VARCHAR}, test_score = #{testScore,jdbcType=VARCHAR}, file_num = #{fileNum,jdbcType=VARCHAR}, f_pedigree_num = #{fPedigreeNum,jdbcType=VARCHAR}, m_pedigree_num = #{mPedigreeNum,jdbcType=VARCHAR}, f_m_pedigree_num = #{fMPedigreeNum,jdbcType=VARCHAR}, inbreeding_seal = #{inbreedingSeal,jdbcType=VARCHAR}, old_studbook_num = #{oldStudbookNum,jdbcType=VARCHAR}, overseas_reg_certifi = #{overseasRegCertifi,jdbcType=VARCHAR}, add_data = #{addData,jdbcType=TIMESTAMP}, modifi_data = #{modifiData,jdbcType=TIMESTAMP}, breeders_memb_num = #{breedersMembNum,jdbcType=VARCHAR}, del_tag = #{delTag,jdbcType=VARCHAR}, print_type = #{printType,jdbcType=VARCHAR}, pay_dna = #{payDna,jdbcType=VARCHAR}, pay_fy = #{payFy,jdbcType=VARCHAR}, pay_hd = #{payHd,jdbcType=VARCHAR}, three_no = #{threeNo,jdbcType=INTEGER}, dog_genertions = #{dogGenertions,jdbcType=INTEGER}, fanyu_confirm = #{fanyuConfirm,jdbcType=VARCHAR} where id = #{id,jdbcType=INTEGER}