ID, USER_ID, ROLE_ID select from user_role where ID = #{id,jdbcType=INTEGER} delete from user_role where ID = #{id,jdbcType=INTEGER} insert into user_role (ID, USER_ID, ROLE_ID ) values (#{id,jdbcType=INTEGER}, #{userId,jdbcType=INTEGER}, #{roleId,jdbcType=INTEGER} ) insert into user_role ID, USER_ID, ROLE_ID, #{id,jdbcType=INTEGER}, #{userId,jdbcType=INTEGER}, #{roleId,jdbcType=INTEGER}, update user_role USER_ID = #{userId,jdbcType=INTEGER}, ROLE_ID = #{roleId,jdbcType=INTEGER}, where ID = #{id,jdbcType=INTEGER} update user_role set USER_ID = #{userId,jdbcType=INTEGER}, ROLE_ID = #{roleId,jdbcType=INTEGER} where ID = #{id,jdbcType=INTEGER}