user_id, name, password, create_date, create_time select from user where user_id = #{userId,jdbcType=BIGINT} delete from user where user_id = #{userId,jdbcType=BIGINT} insert into user (user_id, name, password, create_date, create_time) values (#{userId,jdbcType=BIGINT}, #{name,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, #{createDate,jdbcType=VARCHAR}, #{createTime,jdbcType=VARCHAR}) insert into user user_id, name, password, create_date, create_time, #{userId,jdbcType=BIGINT}, #{name,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, #{createDate,jdbcType=VARCHAR}, #{createTime,jdbcType=VARCHAR}, update user name = #{name,jdbcType=VARCHAR}, password = #{password,jdbcType=VARCHAR}, create_date = #{createDate,jdbcType=VARCHAR}, create_time = #{createTime,jdbcType=VARCHAR}, where user_id = #{userId,jdbcType=BIGINT} update user set name = #{name,jdbcType=VARCHAR}, password = #{password,jdbcType=VARCHAR}, create_date = #{createDate,jdbcType=VARCHAR}, create_time = #{createTime,jdbcType=VARCHAR} where user_id = #{userId,jdbcType=BIGINT} SELECT * FROM user WHERE user_id IN #{temp} ORDER BY USER_ID