资源映射文件实现CRUD示例IUserDaoMapper.xml

创建位置：必须和持久层接口在相同的包中。
名称：必须以持久层接口名称命名文件名，扩展名是.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">
<mapper namespace="cn.qut.dao.IUserDao">
    <!-- 配置查询所有操作 -->
    <select id="findAll" resultType="cn.qut.enities.User">
       select * from user;
    </select>

    <select id="findById" resultType="cn.qut.enities.User" parameterType="java.lang.Integer">
        select  * from user where id = #{id};
    </select>

   <insert id="saveUser" parameterType="cn.qut.enities.User" >
       <!-- 配置插入操作后，获取插入数据的id -->
       <selectKey keyProperty="id" keyColumn="id" resultType="int" order="AFTER">
           select last_insert_id();
       </selectKey>
       insert into user(username,birthday,sex,address)values(#{username},#{birthday},#{sex},#{address});
   </insert>

    <update id="update" parameterType="cn.qut.enities.User">
        update user set username = #{username}, birthday = #{birthday}, sex = #{sex}, address = #{address} where id = #{id}
    </update>

    <delete id="delete" parameterType="int" >
        delete from user where id=#{id};
    </delete>

    <!-- 获取用户的总记录条数 -->
    <select id="findTotal" resultType="int">
        select count(id) from user;
    </select>
</mapper>