Id, Name, Sex, Age
selectfrom user
where Id = #{id,jdbcType=INTEGER}
delete from user
where Id = #{id,jdbcType=INTEGER}
insert into user (Id, Name, Sex,
Age)
values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{sex,jdbcType=VARCHAR},
#{age,jdbcType=TINYINT})
insert into user
Id,
Name,
Sex,
Age,
#{id,jdbcType=INTEGER},
#{name,jdbcType=VARCHAR},
#{sex,jdbcType=VARCHAR},
#{age,jdbcType=TINYINT},
update user
Name = #{name,jdbcType=VARCHAR},
Sex = #{sex,jdbcType=VARCHAR},
Age = #{age,jdbcType=TINYINT},
where Id = #{id,jdbcType=INTEGER}
update user
set Name = #{name,jdbcType=VARCHAR},
Sex = #{sex,jdbcType=VARCHAR},
Age = #{age,jdbcType=TINYINT}
where Id = #{id,jdbcType=INTEGER}