ID, ROLE select from role where ID = #{id,jdbcType=INTEGER} delete from role where ID = #{id,jdbcType=INTEGER} insert into role (ID, ROLE) values (#{id,jdbcType=INTEGER}, #{role,jdbcType=VARCHAR}) insert into role ID, ROLE, #{id,jdbcType=INTEGER}, #{role,jdbcType=VARCHAR}, update role ROLE = #{role,jdbcType=VARCHAR}, where ID = #{id,jdbcType=INTEGER} update role set ROLE = #{role,jdbcType=VARCHAR} where ID = #{id,jdbcType=INTEGER}