A.<select id="queryUserById" resultType="hashmap" parameterType ="int">
<![CDATA[SELECT * FROM user u WHERE u.id=#{id}
]]>
</select>
B.<delete id="deleteUserById" parameterType ="int">
<![CDATA[DELETE FROM user WHERE id=#{id}
]]>
</delete>
C.<update id=" updateUser " parameterType="com.project.model.User">
<![CDATA[UPDATE user SET username=#{username},
passwd=#{passwd} WHERE id=#{id}
]]>
</update>