【Mybatis】增(insert)删(delete)改(update)查(select)的返回值
select
<select id="getUserByUserName" resultType="User">
select * from User where username = #{userName}
</select>
select的返回值即为 resultType 或者 resultMap
update
<update id="resetPassword" parameterType="string">
update User
set password = #{password},salt = #{salt}
where username = #{userName}
</update>
update 的返回值为 int,1:成功;0:失败; 错误则报异常
返回值的含义:受影响的条数
insert
<insert id="addUser" parameterType="User">
insert into User(`userName`,`password`,`salt`,`name`,`phone`,`email`,`enabled`)
VALUES
(#{userName},#{password},#{salt},#{name},#{phone},#{email},#{enabled})
</insert>
insert 的返回值为 int,1:表示成功插入一条数据;0:表示插入失败
delete
<update id="editUserInfo" parameterType="User">
update user
set name = #{user.name},phone=#{user.phone},email=#{user.email},enabled=#{user.enabled}
where username = #{user.userName}
</update>
delete 的返回值为 int,1:成功;0:失败; 错误则报异常