springmvc+spring+mybatis+mysql配置过程
id, username, password, age, role
select
from user
where id = #{id,jdbcType=VARCHAR}
delete from user
where id = #{id,jdbcType=VARCHAR}
insert into user (id, username, password,
age, role)
values (#{id,jdbcType=VARCHAR}, #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR},
#{age,jdbcType=VARCHAR}, #{role,jdbcType=VARCHAR})
insert into user
id,
username,
password,
age,
role,
#{id,jdbcType=VARCHAR},
#{username,jdbcType=VARCHAR},
#{password,jdbcType=VARCHAR},
#{age,jdbcType=VARCHAR},
#{role,jdbcType=VARCHAR},
update user
username = #{username,jdbcType=VARCHAR},
password = #{password,jdbcType=VARCHAR},
age = #{age,jdbcType=VARCHAR},
role = #{role,jdbcType=VARCHAR},
where id = #{id,jdbcType=VARCHAR}
update user
set username = #{username,jdbcType=VARCHAR},
password = #{password,jdbcType=VARCHAR},
age = #{age,jdbcType=VARCHAR},
role = #{role,jdbcType=VARCHAR}
where id = #{id,jdbcType=VARCHAR}
页:
[1]