基础的mapper.xml的配置（mapper xml配置详解）

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- 写Sql语句   -->
<mapper namespace="test">
	<!-- 通过ID查询一个用户 -->
	<select id="findUserById" parameterType="Integer" resultType="com.huanfeng.bean.User">
		select * from user where id = #{value}
	</select>
	
	<select id="findUserByUsername" parameterType="String" resultType="com.huanfeng.bean.User">
		select * from user where username like "%"#{value}"%"
	</select>
	
	<!-- 添加用户 -->
	<insert id="insertUser" parameterType="com.huanfeng.bean.User">
		<selectKey keyProperty="id" resultType="Integer" order="AFTER">
			select LAST_INSERT_ID()
		</selectKey>
		insert into user (username,birthday,address,sex) 
		values (#{username},#{birthday},#{address},#{sex})
	</insert>
	
	<!-- 更新 -->
	<update id="updateUserById" parameterType="com.huanfeng.bean.User">
		update user 
		set username = #{username},sex = #{sex},birthday = #{birthday},address = #{address}
		where id = #{id}
	</update>
	
	<!-- 删除 -->
	<delete id="deleteUserById" parameterType="Integer">
		delete from user 
		where id = #{value}
	</delete>
</mapper>