Mybatis的mapper样例

<!--放在resource/com/czy-->
<?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="com.czy.dao.UserDao">
    <!--查询所有-->
    <select id="findAll" resultType="user">
        select * from user;
    </select>

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

    <!--更新用户-->
    <update id="updateUser" parameterType="com.czy.domain.User">
        update user set username = #{username},address = #{address},sex = #{sex}, birthday = #{birthday} where id = #{id}
    </update>

    <!--删除用户-->
    <delete id="deleteUser" parameterType="INT">
        delete from user where id = #{id}
    </delete>

    <!--根据id查询单个用户-->
    <select id="findById" resultType="com.czy.domain.User" parameterType="INT">
        select * from user where id = #{id};
    </select>

    <!--根据名称模糊查询用户-->
    <select id="findByName" resultType="com.czy.domain.User" parameterType="string">
        <!--select * from user where username like #{name};-->
        select * from user where username like '%${value}%'
    </select>

    <select id="findTotal" resultType="INT">
        select count(*) from user
    </select>
</mapper>