id, timestr, payout, running_number, dog_peinum, dog_place, dog_head_gong, dog_gong_userid, dog_head_mu, dog_mu_userid, dog_name_gong, dog_gong_card, dog_name_mu, dog_mu_card, dog_pei_date, dog_birthday, dog_new_num, dog_dj_num, dog_check, dog_gong_xufei, dog_mu_xufei, dog_wo_fei, dog_inf_num, recorder, dog_ckudj_num, dog_class, dog_jinqin, order_price, dogBirthCertificate, dog_dy_type, dog_qu_dna, dog_wo_num, cku_jiaji, dog_wo_time dog_check_why, dog_remark, optioner select , from dog_new where id = #{id,jdbcType=INTEGER} select max(dog_peinum) dogPeinum from dog_new where dog_peinum like '%${breedCertifiedNum}%' delete from dog_new where id = #{id,jdbcType=INTEGER} insert into dog_new (id, timestr, payout, running_number, dog_peinum, dog_place, dog_head_gong, dog_gong_userid, dog_head_mu, dog_mu_userid, dog_name_gong, dog_gong_card, dog_name_mu, dog_mu_card, dog_pei_date, dog_birthday, dog_new_num, dog_dj_num, dog_check, dog_gong_xufei, dog_mu_xufei, dog_wo_fei, dog_inf_num, recorder, dog_ckudj_num, dog_class, dog_jinqin, order_price, dogBirthCertificate, dog_dy_type, dog_qu_dna, dog_wo_num, cku_jiaji, dog_wo_time, dog_check_why, dog_remark, optioner) values (#{id,jdbcType=INTEGER}, #{timestr,jdbcType=TIMESTAMP}, #{payout,jdbcType=CHAR}, #{runningNumber,jdbcType=VARCHAR}, #{dogPeinum,jdbcType=VARCHAR}, #{dogPlace,jdbcType=VARCHAR}, #{dogHeadGong,jdbcType=VARCHAR}, #{dogGongUserid,jdbcType=VARCHAR}, #{dogHeadMu,jdbcType=VARCHAR}, #{dogMuUserid,jdbcType=VARCHAR}, #{dogNameGong,jdbcType=VARCHAR}, #{dogGongCard,jdbcType=VARCHAR}, #{dogNameMu,jdbcType=VARCHAR}, #{dogMuCard,jdbcType=VARCHAR}, #{dogPeiDate,jdbcType=TIMESTAMP}, #{dogBirthday,jdbcType=TIMESTAMP}, #{dogNewNum,jdbcType=VARCHAR}, #{dogDjNum,jdbcType=VARCHAR}, #{dogCheck,jdbcType=VARCHAR}, #{dogGongXufei,jdbcType=VARCHAR}, #{dogMuXufei,jdbcType=VARCHAR}, #{dogWoFei,jdbcType=VARCHAR}, #{dogInfNum,jdbcType=VARCHAR}, #{recorder,jdbcType=VARCHAR}, #{dogCkudjNum,jdbcType=VARCHAR}, #{dogClass,jdbcType=VARCHAR}, #{dogJinqin,jdbcType=VARCHAR}, #{orderPrice,jdbcType=DECIMAL}, #{dogbirthcertificate,jdbcType=CHAR}, #{dogDyType,jdbcType=INTEGER}, #{dogQuDna,jdbcType=INTEGER}, #{dogWoNum,jdbcType=CHAR}, #{ckuJiaji,jdbcType=CHAR}, #{dogWoTime,jdbcType=TIMESTAMP}, #{dogCheckWhy,jdbcType=LONGVARCHAR}, #{dogRemark,jdbcType=LONGVARCHAR}, #{optioner,jdbcType=LONGVARCHAR}) insert into dog_new id, timestr, payout, running_number, dog_peinum, dog_place, dog_head_gong, dog_gong_userid, dog_head_mu, dog_mu_userid, dog_name_gong, dog_gong_card, dog_name_mu, dog_mu_card, dog_pei_date, dog_birthday, dog_new_num, dog_dj_num, dog_check, dog_gong_xufei, dog_mu_xufei, dog_wo_fei, dog_inf_num, recorder, dog_ckudj_num, dog_class, dog_jinqin, order_price, dogBirthCertificate, dog_dy_type, dog_qu_dna, dog_wo_num, cku_jiaji, dog_wo_time, dog_check_why, dog_remark, optioner, #{id,jdbcType=INTEGER}, #{timestr,jdbcType=TIMESTAMP}, #{payout,jdbcType=CHAR}, #{runningNumber,jdbcType=VARCHAR}, #{dogPeinum,jdbcType=VARCHAR}, #{dogPlace,jdbcType=VARCHAR}, #{dogHeadGong,jdbcType=VARCHAR}, #{dogGongUserid,jdbcType=VARCHAR}, #{dogHeadMu,jdbcType=VARCHAR}, #{dogMuUserid,jdbcType=VARCHAR}, #{dogNameGong,jdbcType=VARCHAR}, #{dogGongCard,jdbcType=VARCHAR}, #{dogNameMu,jdbcType=VARCHAR}, #{dogMuCard,jdbcType=VARCHAR}, #{dogPeiDate,jdbcType=TIMESTAMP}, #{dogBirthday,jdbcType=TIMESTAMP}, #{dogNewNum,jdbcType=VARCHAR}, #{dogDjNum,jdbcType=VARCHAR}, #{dogCheck,jdbcType=VARCHAR}, #{dogGongXufei,jdbcType=VARCHAR}, #{dogMuXufei,jdbcType=VARCHAR}, #{dogWoFei,jdbcType=VARCHAR}, #{dogInfNum,jdbcType=VARCHAR}, #{recorder,jdbcType=VARCHAR}, #{dogCkudjNum,jdbcType=VARCHAR}, #{dogClass,jdbcType=VARCHAR}, #{dogJinqin,jdbcType=VARCHAR}, #{orderPrice,jdbcType=DECIMAL}, #{dogbirthcertificate,jdbcType=CHAR}, #{dogDyType,jdbcType=INTEGER}, #{dogQuDna,jdbcType=INTEGER}, #{dogWoNum,jdbcType=CHAR}, #{ckuJiaji,jdbcType=CHAR}, #{dogWoTime,jdbcType=TIMESTAMP}, #{dogCheckWhy,jdbcType=LONGVARCHAR}, #{dogRemark,jdbcType=LONGVARCHAR}, #{optioner,jdbcType=LONGVARCHAR}, update dog_new timestr = #{timestr,jdbcType=TIMESTAMP}, payout = #{payout,jdbcType=CHAR}, running_number = #{runningNumber,jdbcType=VARCHAR}, dog_peinum = #{dogPeinum,jdbcType=VARCHAR}, dog_place = #{dogPlace,jdbcType=VARCHAR}, dog_head_gong = #{dogHeadGong,jdbcType=VARCHAR}, dog_gong_userid = #{dogGongUserid,jdbcType=VARCHAR}, dog_head_mu = #{dogHeadMu,jdbcType=VARCHAR}, dog_mu_userid = #{dogMuUserid,jdbcType=VARCHAR}, dog_name_gong = #{dogNameGong,jdbcType=VARCHAR}, dog_gong_card = #{dogGongCard,jdbcType=VARCHAR}, dog_name_mu = #{dogNameMu,jdbcType=VARCHAR}, dog_mu_card = #{dogMuCard,jdbcType=VARCHAR}, dog_pei_date = #{dogPeiDate,jdbcType=TIMESTAMP}, dog_birthday = #{dogBirthday,jdbcType=TIMESTAMP}, dog_new_num = #{dogNewNum,jdbcType=VARCHAR}, dog_dj_num = #{dogDjNum,jdbcType=VARCHAR}, dog_check = #{dogCheck,jdbcType=VARCHAR}, dog_gong_xufei = #{dogGongXufei,jdbcType=VARCHAR}, dog_mu_xufei = #{dogMuXufei,jdbcType=VARCHAR}, dog_wo_fei = #{dogWoFei,jdbcType=VARCHAR}, dog_inf_num = #{dogInfNum,jdbcType=VARCHAR}, recorder = #{recorder,jdbcType=VARCHAR}, dog_ckudj_num = #{dogCkudjNum,jdbcType=VARCHAR}, dog_class = #{dogClass,jdbcType=VARCHAR}, dog_jinqin = #{dogJinqin,jdbcType=VARCHAR}, order_price = #{orderPrice,jdbcType=DECIMAL}, dogBirthCertificate = #{dogbirthcertificate,jdbcType=CHAR}, dog_dy_type = #{dogDyType,jdbcType=INTEGER}, dog_qu_dna = #{dogQuDna,jdbcType=INTEGER}, dog_wo_num = #{dogWoNum,jdbcType=CHAR}, cku_jiaji = #{ckuJiaji,jdbcType=CHAR}, dog_wo_time = #{dogWoTime,jdbcType=TIMESTAMP}, dog_check_why = #{dogCheckWhy,jdbcType=LONGVARCHAR}, dog_remark = #{dogRemark,jdbcType=LONGVARCHAR}, optioner = #{optioner,jdbcType=LONGVARCHAR}, where id = #{id,jdbcType=INTEGER} update dog_new set timestr = #{timestr,jdbcType=TIMESTAMP}, payout = #{payout,jdbcType=CHAR}, running_number = #{runningNumber,jdbcType=VARCHAR}, dog_peinum = #{dogPeinum,jdbcType=VARCHAR}, dog_place = #{dogPlace,jdbcType=VARCHAR}, dog_head_gong = #{dogHeadGong,jdbcType=VARCHAR}, dog_gong_userid = #{dogGongUserid,jdbcType=VARCHAR}, dog_head_mu = #{dogHeadMu,jdbcType=VARCHAR}, dog_mu_userid = #{dogMuUserid,jdbcType=VARCHAR}, dog_name_gong = #{dogNameGong,jdbcType=VARCHAR}, dog_gong_card = #{dogGongCard,jdbcType=VARCHAR}, dog_name_mu = #{dogNameMu,jdbcType=VARCHAR}, dog_mu_card = #{dogMuCard,jdbcType=VARCHAR}, dog_pei_date = #{dogPeiDate,jdbcType=TIMESTAMP}, dog_birthday = #{dogBirthday,jdbcType=TIMESTAMP}, dog_new_num = #{dogNewNum,jdbcType=VARCHAR}, dog_dj_num = #{dogDjNum,jdbcType=VARCHAR}, dog_check = #{dogCheck,jdbcType=VARCHAR}, dog_gong_xufei = #{dogGongXufei,jdbcType=VARCHAR}, dog_mu_xufei = #{dogMuXufei,jdbcType=VARCHAR}, dog_wo_fei = #{dogWoFei,jdbcType=VARCHAR}, dog_inf_num = #{dogInfNum,jdbcType=VARCHAR}, recorder = #{recorder,jdbcType=VARCHAR}, dog_ckudj_num = #{dogCkudjNum,jdbcType=VARCHAR}, dog_class = #{dogClass,jdbcType=VARCHAR}, dog_jinqin = #{dogJinqin,jdbcType=VARCHAR}, order_price = #{orderPrice,jdbcType=DECIMAL}, dogBirthCertificate = #{dogbirthcertificate,jdbcType=CHAR}, dog_dy_type = #{dogDyType,jdbcType=INTEGER}, dog_qu_dna = #{dogQuDna,jdbcType=INTEGER}, dog_wo_num = #{dogWoNum,jdbcType=CHAR}, cku_jiaji = #{ckuJiaji,jdbcType=CHAR}, dog_wo_time = #{dogWoTime,jdbcType=TIMESTAMP}, dog_check_why = #{dogCheckWhy,jdbcType=LONGVARCHAR}, dog_remark = #{dogRemark,jdbcType=LONGVARCHAR}, optioner = #{optioner,jdbcType=LONGVARCHAR} where id = #{id,jdbcType=INTEGER} update dog_new set timestr = #{timestr,jdbcType=TIMESTAMP}, payout = #{payout,jdbcType=CHAR}, running_number = #{runningNumber,jdbcType=VARCHAR}, dog_peinum = #{dogPeinum,jdbcType=VARCHAR}, dog_place = #{dogPlace,jdbcType=VARCHAR}, dog_head_gong = #{dogHeadGong,jdbcType=VARCHAR}, dog_gong_userid = #{dogGongUserid,jdbcType=VARCHAR}, dog_head_mu = #{dogHeadMu,jdbcType=VARCHAR}, dog_mu_userid = #{dogMuUserid,jdbcType=VARCHAR}, dog_name_gong = #{dogNameGong,jdbcType=VARCHAR}, dog_gong_card = #{dogGongCard,jdbcType=VARCHAR}, dog_name_mu = #{dogNameMu,jdbcType=VARCHAR}, dog_mu_card = #{dogMuCard,jdbcType=VARCHAR}, dog_pei_date = #{dogPeiDate,jdbcType=TIMESTAMP}, dog_birthday = #{dogBirthday,jdbcType=TIMESTAMP}, dog_new_num = #{dogNewNum,jdbcType=VARCHAR}, dog_dj_num = #{dogDjNum,jdbcType=VARCHAR}, dog_check = #{dogCheck,jdbcType=VARCHAR}, dog_gong_xufei = #{dogGongXufei,jdbcType=VARCHAR}, dog_mu_xufei = #{dogMuXufei,jdbcType=VARCHAR}, dog_wo_fei = #{dogWoFei,jdbcType=VARCHAR}, dog_inf_num = #{dogInfNum,jdbcType=VARCHAR}, recorder = #{recorder,jdbcType=VARCHAR}, dog_ckudj_num = #{dogCkudjNum,jdbcType=VARCHAR}, dog_class = #{dogClass,jdbcType=VARCHAR}, dog_jinqin = #{dogJinqin,jdbcType=VARCHAR}, order_price = #{orderPrice,jdbcType=DECIMAL}, dogBirthCertificate = #{dogbirthcertificate,jdbcType=CHAR}, dog_dy_type = #{dogDyType,jdbcType=INTEGER}, dog_qu_dna = #{dogQuDna,jdbcType=INTEGER}, dog_wo_num = #{dogWoNum,jdbcType=CHAR}, cku_jiaji = #{ckuJiaji,jdbcType=CHAR}, dog_wo_time = #{dogWoTime,jdbcType=TIMESTAMP} where id = #{id,jdbcType=INTEGER}