dao接口映射配置文件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">
<!--namespace 指的是要配置的全限定类名-->
<mapper namespace="com.feilong.dao.IUserDao">
    <!--结果集进行封装映射resultMap-->
    <resultMap id="userMap" type="user">
        <id property="userId" column="id"></id>
        <result property="userName" column="username"></result>
        <result property="userBirthday" column="birthday"></result>
        <result property="userSex" column="sex"></result>
        <result property="userAddress" column="address"></result>
    </resultMap>
    <!--
      column是数据库中对应的列名
      property是实体类的属性名
    -->
 
    <!--id对应的是类里面的方法-->
    <!--resultType里面指的是返回的映射的结果类型-->
    <!--查询所有-->
    <!--<select id="findAll" resultType="com.feilong.entity.User">-->
    <!--select * from user-->
    <!--</select>-->
    <select id="findAll" resultMap="userMap">
        select * from user
    </select>
    <!--根据id查询单个用户-->
    <!--parameterType是参数类型-->
    <select id="findUserById" parameterType="int" resultType="com.feilong.entity.User">
        select * from user
        where id=#{id}
    </select>
    <!--根据姓名模糊查询-->
    <select id="findUserByName" parameterType="String" resultType="com.feilong.entity.User">
        select * from user where username LIKE #{username}
        <!--    select * from user where username LIKE '%${value}%'-->
    </select>
    <!--插入数据-->
    <insert id="insertUser" parameterType="com.feilong.entity.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>
    <!--删除数据-->
    <delete id="deleteUserById" parameterType="int">
        delete from user where id=#{id}
    </delete>
    <!--更新数据-->
    <update id="updateUserById" parameterType="com.feilong.entity.User">
        update user set username=#{username},birthday=#{birthday},sex=#{sex},address=#{address}
        where id=#{id}
    </update>
    <!--查询总记录数-->
    <select id="count" resultType="int">
        select count(id) from user
    </select>
    <!--根据QueryVo查询-->
    <select id="findUserByQuery" parameterType="com.feilong.entity.QueryVO" resultType="com.feilong.entity.User">
        select * from user where username LIKE #{user.username}
    </select>
</mapper>