SELECT id id, 缴费状态 pay_status, 会员号 member_num, 网站会员 web_member, 姓名 NAME, 姓名拼音 name_spelling, 性别 gender, 出生日期 birthday, 身份证号 id_num, 联系地址 contact_address, 邮政编码 post_code, 固定电话 telephone, 移动电话 mobile_phone, 传真电话 fax, Email Email, 会员登记编号 reg_member_num, 繁殖登记编号 reg_breeding_num, 登记日期 reg_data, 会员类别 member_type, 交费详情 pay_detail, 备注 remarks, 会员开始时间 member_begin_time, 会员截止时间 member_deadline_time, 登记人员 reg_by, 修改日期 modifi_date, del_tag del_tag, 操作人员 operator, qslz_tag qslz_tag, qslz_time qslz_time, 配送方式 delivery_way, 证书配送方式 certifi_delivery_way, 通知配送方式 notice_delivery_way, Province Province, City City, Street Street, QQ QQ, mrUserType mrUserType, mrUserTime mrUserTime, ckuUserPhoto ckuUserPhoto, 推荐人 recommender, 电话联络 tel_time, isNewUser isNewUser, SS_jstime SS_jstime, mrBeiZhu mrBeiZhu, qydUserType qydUserType, qydUserTime qydUserTime, cku_club cku_club, cku_cardtype cku_cardtype, payin payin, payout payout, yue1 yue1, yue2 yue2 FROM cku_user WHERE 会员号 = #{idNum} id, pay_status, member_num, web_member, name, name_spelling, gender, birthday, id_num, contact_address, post_code, telephone, mobile_phone, fax, Email, reg_member_num, reg_breeding_num, reg_data, member_type, pay_detail, member_begin_time, member_deadline_time, reg_by, modifi_date, del_tag, qslz_tag, qslz_time, delivery_way, certifi_delivery_way, notice_delivery_way, Province, City, Street, QQ, mrUserType, mrUserTime, ckuUserPhoto, recommender, tel_time, isNewUser, SS_jstime, qydUserType, qydUserTime, cku_club, cku_cardtype, payin, payout, yue1, yue2 remarks, operator, mrBeiZhu select , from cku_user where id = #{id,jdbcType=INTEGER} delete from cku_user where id = #{id,jdbcType=INTEGER} insert into cku_user (id, pay_status, member_num, web_member, name, name_spelling, gender, birthday, id_num, contact_address, post_code, telephone, mobile_phone, fax, Email, reg_member_num, reg_breeding_num, reg_data, member_type, pay_detail, member_begin_time, member_deadline_time, reg_by, modifi_date, del_tag, qslz_tag, qslz_time, delivery_way, certifi_delivery_way, notice_delivery_way, Province, City, Street, QQ, mrUserType, mrUserTime, ckuUserPhoto, recommender, tel_time, isNewUser, SS_jstime, qydUserType, qydUserTime, cku_club, cku_cardtype, payin, payout, yue1, yue2, remarks, operator, mrBeiZhu) values (#{id,jdbcType=INTEGER}, #{payStatus,jdbcType=VARCHAR}, #{memberNum,jdbcType=VARCHAR}, #{webMember,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, #{nameSpelling,jdbcType=VARCHAR}, #{gender,jdbcType=VARCHAR}, #{birthday,jdbcType=TIMESTAMP}, #{idNum,jdbcType=VARCHAR}, #{contactAddress,jdbcType=VARCHAR}, #{postCode,jdbcType=VARCHAR}, #{telephone,jdbcType=VARCHAR}, #{mobilePhone,jdbcType=VARCHAR}, #{fax,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, #{regMemberNum,jdbcType=VARCHAR}, #{regBreedingNum,jdbcType=VARCHAR}, #{regData,jdbcType=TIMESTAMP}, #{memberType,jdbcType=VARCHAR}, #{payDetail,jdbcType=VARCHAR}, #{memberBeginTime,jdbcType=TIMESTAMP}, #{memberDeadlineTime,jdbcType=TIMESTAMP}, #{regBy,jdbcType=VARCHAR}, #{modifiDate,jdbcType=TIMESTAMP}, #{delTag,jdbcType=CHAR}, #{qslzTag,jdbcType=CHAR}, #{qslzTime,jdbcType=TIMESTAMP}, #{deliveryWay,jdbcType=VARCHAR}, #{certifiDeliveryWay,jdbcType=VARCHAR}, #{noticeDeliveryWay,jdbcType=VARCHAR}, #{province,jdbcType=VARCHAR}, #{city,jdbcType=VARCHAR}, #{street,jdbcType=VARCHAR}, #{qq,jdbcType=VARCHAR}, #{mrusertype,jdbcType=CHAR}, #{mrusertime,jdbcType=TIMESTAMP}, #{ckuuserphoto,jdbcType=VARCHAR}, #{recommender,jdbcType=VARCHAR}, #{telTime,jdbcType=TIMESTAMP}, #{isnewuser,jdbcType=CHAR}, #{ssJstime,jdbcType=TIMESTAMP}, #{qydusertype,jdbcType=CHAR}, #{qydusertime,jdbcType=TIMESTAMP}, #{ckuClub,jdbcType=VARCHAR}, #{ckuCardtype,jdbcType=VARCHAR}, #{payin,jdbcType=DECIMAL}, #{payout,jdbcType=DECIMAL}, #{yue1,jdbcType=DECIMAL}, #{yue2,jdbcType=DECIMAL}, #{remarks,jdbcType=LONGVARCHAR}, #{operator,jdbcType=LONGVARCHAR}, #{mrbeizhu,jdbcType=LONGVARCHAR}) insert into cku_user id, pay_status, member_num, web_member, name, name_spelling, gender, birthday, id_num, contact_address, post_code, telephone, mobile_phone, fax, Email, reg_member_num, reg_breeding_num, reg_data, member_type, pay_detail, member_begin_time, member_deadline_time, reg_by, modifi_date, del_tag, qslz_tag, qslz_time, delivery_way, certifi_delivery_way, notice_delivery_way, Province, City, Street, QQ, mrUserType, mrUserTime, ckuUserPhoto, recommender, tel_time, isNewUser, SS_jstime, qydUserType, qydUserTime, cku_club, cku_cardtype, payin, payout, yue1, yue2, remarks, operator, mrBeiZhu, #{id,jdbcType=INTEGER}, #{payStatus,jdbcType=VARCHAR}, #{memberNum,jdbcType=VARCHAR}, #{webMember,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, #{nameSpelling,jdbcType=VARCHAR}, #{gender,jdbcType=VARCHAR}, #{birthday,jdbcType=TIMESTAMP}, #{idNum,jdbcType=VARCHAR}, #{contactAddress,jdbcType=VARCHAR}, #{postCode,jdbcType=VARCHAR}, #{telephone,jdbcType=VARCHAR}, #{mobilePhone,jdbcType=VARCHAR}, #{fax,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, #{regMemberNum,jdbcType=VARCHAR}, #{regBreedingNum,jdbcType=VARCHAR}, #{regData,jdbcType=TIMESTAMP}, #{memberType,jdbcType=VARCHAR}, #{payDetail,jdbcType=VARCHAR}, #{memberBeginTime,jdbcType=TIMESTAMP}, #{memberDeadlineTime,jdbcType=TIMESTAMP}, #{regBy,jdbcType=VARCHAR}, #{modifiDate,jdbcType=TIMESTAMP}, #{delTag,jdbcType=CHAR}, #{qslzTag,jdbcType=CHAR}, #{qslzTime,jdbcType=TIMESTAMP}, #{deliveryWay,jdbcType=VARCHAR}, #{certifiDeliveryWay,jdbcType=VARCHAR}, #{noticeDeliveryWay,jdbcType=VARCHAR}, #{province,jdbcType=VARCHAR}, #{city,jdbcType=VARCHAR}, #{street,jdbcType=VARCHAR}, #{qq,jdbcType=VARCHAR}, #{mrusertype,jdbcType=CHAR}, #{mrusertime,jdbcType=TIMESTAMP}, #{ckuuserphoto,jdbcType=VARCHAR}, #{recommender,jdbcType=VARCHAR}, #{telTime,jdbcType=TIMESTAMP}, #{isnewuser,jdbcType=CHAR}, #{ssJstime,jdbcType=TIMESTAMP}, #{qydusertype,jdbcType=CHAR}, #{qydusertime,jdbcType=TIMESTAMP}, #{ckuClub,jdbcType=VARCHAR}, #{ckuCardtype,jdbcType=VARCHAR}, #{payin,jdbcType=DECIMAL}, #{payout,jdbcType=DECIMAL}, #{yue1,jdbcType=DECIMAL}, #{yue2,jdbcType=DECIMAL}, #{remarks,jdbcType=LONGVARCHAR}, #{operator,jdbcType=LONGVARCHAR}, #{mrbeizhu,jdbcType=LONGVARCHAR}, update cku_user pay_status = #{payStatus,jdbcType=VARCHAR}, member_num = #{memberNum,jdbcType=VARCHAR}, web_member = #{webMember,jdbcType=VARCHAR}, name = #{name,jdbcType=VARCHAR}, name_spelling = #{nameSpelling,jdbcType=VARCHAR}, gender = #{gender,jdbcType=VARCHAR}, birthday = #{birthday,jdbcType=TIMESTAMP}, id_num = #{idNum,jdbcType=VARCHAR}, contact_address = #{contactAddress,jdbcType=VARCHAR}, post_code = #{postCode,jdbcType=VARCHAR}, telephone = #{telephone,jdbcType=VARCHAR}, mobile_phone = #{mobilePhone,jdbcType=VARCHAR}, fax = #{fax,jdbcType=VARCHAR}, Email = #{email,jdbcType=VARCHAR}, reg_member_num = #{regMemberNum,jdbcType=VARCHAR}, reg_breeding_num = #{regBreedingNum,jdbcType=VARCHAR}, reg_data = #{regData,jdbcType=TIMESTAMP}, member_type = #{memberType,jdbcType=VARCHAR}, pay_detail = #{payDetail,jdbcType=VARCHAR}, member_begin_time = #{memberBeginTime,jdbcType=TIMESTAMP}, member_deadline_time = #{memberDeadlineTime,jdbcType=TIMESTAMP}, reg_by = #{regBy,jdbcType=VARCHAR}, modifi_date = #{modifiDate,jdbcType=TIMESTAMP}, del_tag = #{delTag,jdbcType=CHAR}, qslz_tag = #{qslzTag,jdbcType=CHAR}, qslz_time = #{qslzTime,jdbcType=TIMESTAMP}, delivery_way = #{deliveryWay,jdbcType=VARCHAR}, certifi_delivery_way = #{certifiDeliveryWay,jdbcType=VARCHAR}, notice_delivery_way = #{noticeDeliveryWay,jdbcType=VARCHAR}, Province = #{province,jdbcType=VARCHAR}, City = #{city,jdbcType=VARCHAR}, Street = #{street,jdbcType=VARCHAR}, QQ = #{qq,jdbcType=VARCHAR}, mrUserType = #{mrusertype,jdbcType=CHAR}, mrUserTime = #{mrusertime,jdbcType=TIMESTAMP}, ckuUserPhoto = #{ckuuserphoto,jdbcType=VARCHAR}, recommender = #{recommender,jdbcType=VARCHAR}, tel_time = #{telTime,jdbcType=TIMESTAMP}, isNewUser = #{isnewuser,jdbcType=CHAR}, SS_jstime = #{ssJstime,jdbcType=TIMESTAMP}, qydUserType = #{qydusertype,jdbcType=CHAR}, qydUserTime = #{qydusertime,jdbcType=TIMESTAMP}, cku_club = #{ckuClub,jdbcType=VARCHAR}, cku_cardtype = #{ckuCardtype,jdbcType=VARCHAR}, payin = #{payin,jdbcType=DECIMAL}, payout = #{payout,jdbcType=DECIMAL}, yue1 = #{yue1,jdbcType=DECIMAL}, yue2 = #{yue2,jdbcType=DECIMAL}, remarks = #{remarks,jdbcType=LONGVARCHAR}, operator = #{operator,jdbcType=LONGVARCHAR}, mrBeiZhu = #{mrbeizhu,jdbcType=LONGVARCHAR}, where id = #{id,jdbcType=INTEGER} update cku_user set pay_status = #{payStatus,jdbcType=VARCHAR}, member_num = #{memberNum,jdbcType=VARCHAR}, web_member = #{webMember,jdbcType=VARCHAR}, name = #{name,jdbcType=VARCHAR}, name_spelling = #{nameSpelling,jdbcType=VARCHAR}, gender = #{gender,jdbcType=VARCHAR}, birthday = #{birthday,jdbcType=TIMESTAMP}, id_num = #{idNum,jdbcType=VARCHAR}, contact_address = #{contactAddress,jdbcType=VARCHAR}, post_code = #{postCode,jdbcType=VARCHAR}, telephone = #{telephone,jdbcType=VARCHAR}, mobile_phone = #{mobilePhone,jdbcType=VARCHAR}, fax = #{fax,jdbcType=VARCHAR}, Email = #{email,jdbcType=VARCHAR}, reg_member_num = #{regMemberNum,jdbcType=VARCHAR}, reg_breeding_num = #{regBreedingNum,jdbcType=VARCHAR}, reg_data = #{regData,jdbcType=TIMESTAMP}, member_type = #{memberType,jdbcType=VARCHAR}, pay_detail = #{payDetail,jdbcType=VARCHAR}, member_begin_time = #{memberBeginTime,jdbcType=TIMESTAMP}, member_deadline_time = #{memberDeadlineTime,jdbcType=TIMESTAMP}, reg_by = #{regBy,jdbcType=VARCHAR}, modifi_date = #{modifiDate,jdbcType=TIMESTAMP}, del_tag = #{delTag,jdbcType=CHAR}, qslz_tag = #{qslzTag,jdbcType=CHAR}, qslz_time = #{qslzTime,jdbcType=TIMESTAMP}, delivery_way = #{deliveryWay,jdbcType=VARCHAR}, certifi_delivery_way = #{certifiDeliveryWay,jdbcType=VARCHAR}, notice_delivery_way = #{noticeDeliveryWay,jdbcType=VARCHAR}, Province = #{province,jdbcType=VARCHAR}, City = #{city,jdbcType=VARCHAR}, Street = #{street,jdbcType=VARCHAR}, QQ = #{qq,jdbcType=VARCHAR}, mrUserType = #{mrusertype,jdbcType=CHAR}, mrUserTime = #{mrusertime,jdbcType=TIMESTAMP}, ckuUserPhoto = #{ckuuserphoto,jdbcType=VARCHAR}, recommender = #{recommender,jdbcType=VARCHAR}, tel_time = #{telTime,jdbcType=TIMESTAMP}, isNewUser = #{isnewuser,jdbcType=CHAR}, SS_jstime = #{ssJstime,jdbcType=TIMESTAMP}, qydUserType = #{qydusertype,jdbcType=CHAR}, qydUserTime = #{qydusertime,jdbcType=TIMESTAMP}, cku_club = #{ckuClub,jdbcType=VARCHAR}, cku_cardtype = #{ckuCardtype,jdbcType=VARCHAR}, payin = #{payin,jdbcType=DECIMAL}, payout = #{payout,jdbcType=DECIMAL}, yue1 = #{yue1,jdbcType=DECIMAL}, yue2 = #{yue2,jdbcType=DECIMAL}, remarks = #{remarks,jdbcType=LONGVARCHAR}, operator = #{operator,jdbcType=LONGVARCHAR}, mrBeiZhu = #{mrbeizhu,jdbcType=LONGVARCHAR} where id = #{id,jdbcType=INTEGER} update cku_user set pay_status = #{payStatus,jdbcType=VARCHAR}, member_num = #{memberNum,jdbcType=VARCHAR}, web_member = #{webMember,jdbcType=VARCHAR}, name = #{name,jdbcType=VARCHAR}, name_spelling = #{nameSpelling,jdbcType=VARCHAR}, gender = #{gender,jdbcType=VARCHAR}, birthday = #{birthday,jdbcType=TIMESTAMP}, id_num = #{idNum,jdbcType=VARCHAR}, contact_address = #{contactAddress,jdbcType=VARCHAR}, post_code = #{postCode,jdbcType=VARCHAR}, telephone = #{telephone,jdbcType=VARCHAR}, mobile_phone = #{mobilePhone,jdbcType=VARCHAR}, fax = #{fax,jdbcType=VARCHAR}, Email = #{email,jdbcType=VARCHAR}, reg_member_num = #{regMemberNum,jdbcType=VARCHAR}, reg_breeding_num = #{regBreedingNum,jdbcType=VARCHAR}, reg_data = #{regData,jdbcType=TIMESTAMP}, member_type = #{memberType,jdbcType=VARCHAR}, pay_detail = #{payDetail,jdbcType=VARCHAR}, member_begin_time = #{memberBeginTime,jdbcType=TIMESTAMP}, member_deadline_time = #{memberDeadlineTime,jdbcType=TIMESTAMP}, reg_by = #{regBy,jdbcType=VARCHAR}, modifi_date = #{modifiDate,jdbcType=TIMESTAMP}, del_tag = #{delTag,jdbcType=CHAR}, qslz_tag = #{qslzTag,jdbcType=CHAR}, qslz_time = #{qslzTime,jdbcType=TIMESTAMP}, delivery_way = #{deliveryWay,jdbcType=VARCHAR}, certifi_delivery_way = #{certifiDeliveryWay,jdbcType=VARCHAR}, notice_delivery_way = #{noticeDeliveryWay,jdbcType=VARCHAR}, Province = #{province,jdbcType=VARCHAR}, City = #{city,jdbcType=VARCHAR}, Street = #{street,jdbcType=VARCHAR}, QQ = #{qq,jdbcType=VARCHAR}, mrUserType = #{mrusertype,jdbcType=CHAR}, mrUserTime = #{mrusertime,jdbcType=TIMESTAMP}, ckuUserPhoto = #{ckuuserphoto,jdbcType=VARCHAR}, recommender = #{recommender,jdbcType=VARCHAR}, tel_time = #{telTime,jdbcType=TIMESTAMP}, isNewUser = #{isnewuser,jdbcType=CHAR}, SS_jstime = #{ssJstime,jdbcType=TIMESTAMP}, qydUserType = #{qydusertype,jdbcType=CHAR}, qydUserTime = #{qydusertime,jdbcType=TIMESTAMP}, cku_club = #{ckuClub,jdbcType=VARCHAR}, cku_cardtype = #{ckuCardtype,jdbcType=VARCHAR}, payin = #{payin,jdbcType=DECIMAL}, payout = #{payout,jdbcType=DECIMAL}, yue1 = #{yue1,jdbcType=DECIMAL}, yue2 = #{yue2,jdbcType=DECIMAL} where id = #{id,jdbcType=INTEGER}