jdbc servlet ssm 实现简单的增删改查
UserMapper
<mapper namespace="com.wu.dao.UserDao" >
<select id="findUserByUserName" parameterType="String" resultType="user">
select * from tb_user where username=#{
username}
</select>
<select id="findAll" parameterType="String" resultType="user">
select * from tb_user
</select>
<select id="deleteById" parameterType="int">
delete from tb_user where id =#{
id}
</select>
<select id="addUser" parameterType="String" resultType="user">
insert into tb_user(username,password) value (#{
username},#{
password})
</select>
<select id="selectById" parameterType="int" resultType="user">
select * from tb_user where id=#{
id}
</select>
<select id="update" parameterType="user" resultType="user">
update tb_user set username=#{
username},password=#{
password