id, image_url, banner_name, type, detail_url, is_show, create_by, create_date, update_by, update_date, remarks, del_flag select from cku_banner where id = #{id,jdbcType=INTEGER} delete from cku_banner where id = #{id,jdbcType=INTEGER} insert into cku_banner (id, image_url, banner_name, type, detail_url, is_show, create_by, create_date, update_by, update_date, remarks, del_flag ) values (#{id,jdbcType=INTEGER}, #{imageUrl,jdbcType=VARCHAR}, #{bannerName,jdbcType=VARCHAR}, #{type,jdbcType=INTEGER}, #{detailUrl,jdbcType=VARCHAR}, #{isShow,jdbcType=INTEGER}, #{createBy,jdbcType=VARCHAR}, #{createDate,jdbcType=TIMESTAMP}, #{updateBy,jdbcType=VARCHAR}, #{updateDate,jdbcType=TIMESTAMP}, #{remarks,jdbcType=VARCHAR}, #{delFlag,jdbcType=CHAR} ) insert into cku_banner id, image_url, banner_name, type, detail_url, is_show, create_by, create_date, update_by, update_date, remarks, del_flag, #{id,jdbcType=INTEGER}, #{imageUrl,jdbcType=VARCHAR}, #{bannerName,jdbcType=VARCHAR}, #{type,jdbcType=INTEGER}, #{detailUrl,jdbcType=VARCHAR}, #{isShow,jdbcType=INTEGER}, #{createBy,jdbcType=VARCHAR}, #{createDate,jdbcType=TIMESTAMP}, #{updateBy,jdbcType=VARCHAR}, #{updateDate,jdbcType=TIMESTAMP}, #{remarks,jdbcType=VARCHAR}, #{delFlag,jdbcType=CHAR}, update cku_banner image_url = #{imageUrl,jdbcType=VARCHAR}, banner_name = #{bannerName,jdbcType=VARCHAR}, type = #{type,jdbcType=INTEGER}, detail_url = #{detailUrl,jdbcType=VARCHAR}, is_show = #{isShow,jdbcType=INTEGER}, create_by = #{createBy,jdbcType=VARCHAR}, create_date = #{createDate,jdbcType=TIMESTAMP}, update_by = #{updateBy,jdbcType=VARCHAR}, update_date = #{updateDate,jdbcType=TIMESTAMP}, remarks = #{remarks,jdbcType=VARCHAR}, del_flag = #{delFlag,jdbcType=CHAR}, where id = #{id,jdbcType=INTEGER} update cku_banner set image_url = #{imageUrl,jdbcType=VARCHAR}, banner_name = #{bannerName,jdbcType=VARCHAR}, type = #{type,jdbcType=INTEGER}, detail_url = #{detailUrl,jdbcType=VARCHAR}, is_show = #{isShow,jdbcType=INTEGER}, create_by = #{createBy,jdbcType=VARCHAR}, create_date = #{createDate,jdbcType=TIMESTAMP}, update_by = #{updateBy,jdbcType=VARCHAR}, update_date = #{updateDate,jdbcType=TIMESTAMP}, remarks = #{remarks,jdbcType=VARCHAR}, del_flag = #{delFlag,jdbcType=CHAR} where id = #{id,jdbcType=INTEGER}