id, hotel_phone, hotel_longitude, hotel_latitude, hotel_address, hotel_name, hotel_info,
hotel_line, create_time
delete from cku_match_hotel
where id = #{id,jdbcType=INTEGER}
insert into cku_match_hotel (id, hotel_phone, hotel_longitude,
hotel_latitude, hotel_address, hotel_name,
hotel_info, hotel_line, create_time
)
values (#{id,jdbcType=INTEGER}, #{hotelPhone,jdbcType=VARCHAR}, #{hotelLongitude,jdbcType=VARCHAR},
#{hotelLatitude,jdbcType=VARCHAR}, #{hotelAddress,jdbcType=VARCHAR}, #{hotelName,jdbcType=VARCHAR},
#{hotelInfo,jdbcType=VARCHAR}, #{hotelLine,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}
)
insert into cku_match_hotel
id,
hotel_phone,
hotel_longitude,
hotel_latitude,
hotel_address,
hotel_name,
hotel_info,
hotel_line,
create_time,
#{id,jdbcType=INTEGER},
#{hotelPhone,jdbcType=VARCHAR},
#{hotelLongitude,jdbcType=VARCHAR},
#{hotelLatitude,jdbcType=VARCHAR},
#{hotelAddress,jdbcType=VARCHAR},
#{hotelName,jdbcType=VARCHAR},
#{hotelInfo,jdbcType=VARCHAR},
#{hotelLine,jdbcType=VARCHAR},
#{createTime,jdbcType=TIMESTAMP},
update cku_match_hotel
hotel_phone = #{hotelPhone,jdbcType=VARCHAR},
hotel_longitude = #{hotelLongitude,jdbcType=VARCHAR},
hotel_latitude = #{hotelLatitude,jdbcType=VARCHAR},
hotel_address = #{hotelAddress,jdbcType=VARCHAR},
hotel_name = #{hotelName,jdbcType=VARCHAR},
hotel_info = #{hotelInfo,jdbcType=VARCHAR},
hotel_line = #{hotelLine,jdbcType=VARCHAR},
create_time = #{createTime,jdbcType=TIMESTAMP},
where id = #{id,jdbcType=INTEGER}
update cku_match_hotel
set hotel_phone = #{hotelPhone,jdbcType=VARCHAR},
hotel_longitude = #{hotelLongitude,jdbcType=VARCHAR},
hotel_latitude = #{hotelLatitude,jdbcType=VARCHAR},
hotel_address = #{hotelAddress,jdbcType=VARCHAR},
hotel_name = #{hotelName,jdbcType=VARCHAR},
hotel_info = #{hotelInfo,jdbcType=VARCHAR},
hotel_line = #{hotelLine,jdbcType=VARCHAR},
create_time = #{createTime,jdbcType=TIMESTAMP}
where id = #{id,jdbcType=INTEGER}