<!-- 删除--><deleteid="deleteUserById"parameterType="int">
delete from t_user where id=#{id}
</delete>
UPDATE
<!-- 更新--><updateid="updateUserById"parameterType="edu.ccit.cn.domain.User">
update t_user set username=#{username},password=#{password} where id=#{id}
</update>
SELECT
<selectid="findUserById"parameterType="int"resultType="edu.ccit.cn.domain.User">
SELECT * FROM t_user WHERE id = #{id}
</select><!-- 模糊查询--><selectid="findUserByName"parameterType="String"resultType="edu.ccit.cn.domain.User">
select * from t_user where username like '%${value}%'
</select>