select caipan.id id, caipan.judge_name cku_title, caipan.judge_picture cku_picture, caipan.introduce cku_content, caipan.judge_title cku_position, caipan.citizenship cku_country, caipan.judge_sex cku_sex, caipan.judge_title_short cab_jobtitle_short ,caipan.judge_picture image_min_url,caipan.judge_picture image_max_url from show_judge caipan where caipan.id in (${ids}) cku_content, cku_position insert into show_judge (id, cku_title, cku_picture, cku_zhijiao, cku_country, cku_sex, cku_ssbh, cku_sczz, cku_content, cku_position) values (#{id,jdbcType=VARCHAR}, #{ckuTitle,jdbcType=VARCHAR}, #{ckuPicture,jdbcType=VARCHAR}, #{ckuZhijiao,jdbcType=VARCHAR}, #{ckuCountry,jdbcType=VARCHAR}, #{ckuSex,jdbcType=VARCHAR}, #{ckuSsbh,jdbcType=VARCHAR}, #{ckuSczz,jdbcType=VARCHAR}, #{ckuContent,jdbcType=LONGVARCHAR}, #{ckuPosition,jdbcType=LONGVARCHAR}) insert into show_judge id, cku_title, cku_picture, cku_zhijiao, cku_country, cku_sex, cku_ssbh, cku_sczz, cku_content, cku_position, #{id,jdbcType=VARCHAR}, #{ckuTitle,jdbcType=VARCHAR}, #{ckuPicture,jdbcType=VARCHAR}, #{ckuZhijiao,jdbcType=VARCHAR}, #{ckuCountry,jdbcType=VARCHAR}, #{ckuSex,jdbcType=VARCHAR}, #{ckuSsbh,jdbcType=VARCHAR}, #{ckuSczz,jdbcType=VARCHAR}, #{ckuContent,jdbcType=LONGVARCHAR}, #{ckuPosition,jdbcType=LONGVARCHAR}, SELECT TOP ${limit} * FROM show_judge WHERE ID NOT IN( SELECT TOP ${count} ID FROM show_judge where 1=1 and cku_title like '%${name}%' and cku_position like '%${position}%' ORDER BY ID DESC ) and cku_title like '%${name}%' and cku_position like '%${position}%' ORDER BY ID DESC SELECT * FROM show_judge SELECT count(*) FROM show_judge WHERE 1=1 and cku_title like '%${name}%' and cku_position like '%${position}%' update show_judge cku_title = #{ckuTitle,jdbcType=VARCHAR}, cku_picture = #{ckuPicture,jdbcType=VARCHAR}, cku_zhijiao = #{ckuZhijiao,jdbcType=VARCHAR}, cku_country = #{ckuCountry,jdbcType=VARCHAR}, cku_sex = #{ckuSex,jdbcType=VARCHAR}, cku_ssbh = #{ckuSsbh,jdbcType=VARCHAR}, cku_sczz = #{ckuSczz,jdbcType=VARCHAR}, cku_content = #{ckuContent,jdbcType=LONGVARCHAR}, cku_position = #{ckuPosition,jdbcType=LONGVARCHAR}, where id=#{id,jdbcType=VARCHAR} delete from show_judge where id=#{id,jdbcType=VARCHAR} select * from show_judge where id=#{id,jdbcType=VARCHAR}