// 根據(jù)名字內(nèi)容模糊查詢
    List<User> findByNameLike(String username);

<!-- 使用#定義參數(shù) -->
    <select id="findByNameLike" parameterType="string"             
    resultType="com.mybatisstudy.pojo.User">
        select * from user where username like #{name}
    </select>

// 測(cè)試根據(jù)名字模糊查詢
    @Test
    public void testFindByNameLike(){
        String like = "%l%";
        List<User> list = userMapper.findByNameLike(like);
 
        list.forEach(System.out::println);
    }

<!-- 使用$定義參數(shù) -->
    <select id="findByNameLike" resultType="com.mybatisstudy.pojo.User" parameterType="string">
        select * from user where username like '%${value}%'
    </select>

// 測(cè)試根據(jù)名字模糊查詢
    @Test
    public void testFindByNameLike(){
        String like = "l";
        List<User> list = userMapper.findByNameLike(like);
 
        list.forEach(System.out::println);
    }

<!-- 使用<bind>標(biāo)簽定義參數(shù) -->
    <select id="findByNameLike" parameterType="String" resultType="com.mybatisstudy.pojo.User">
        <bind name="likeName" value="'%' + username + '%'"/>
        select * from user where username like #{likeName}
    </select>

// 查詢用戶總數(shù)
    int findCount();

<!-- 聚合查詢 -->
    <select id="findCount" resultType="int">
        select count(id) from user
    </select>

// 測(cè)試聚合查詢方法
    @Test
    public void testFindCount(){
        System.out.println(userMapper.findCount());
    }

// 主鍵回填-新增用戶
    void add2(User user);

<!-- 主鍵回填 -->
    <insert id="add2" parameterType="com.mybatisstudy.pojo.User">
        <!-- keyProperty:主鍵屬性名，keyColumn:主鍵列名，resultType:主鍵類型，order:執(zhí)行時(shí)機(jī) -->
        <selectKey keyProperty="id" keyColumn="id" resultType="int" order="AFTER">
            select last_insert_id();
        </selectKey>
        insert into user(username,sex,address)
        values (#{username},#{sex},#{address})
    </insert>

// 測(cè)試主鍵回填功能
    @Test
    public void testAdd2(){
        User user = new User("Lions","man","Beijing");
        userMapper.add2(user);
 
        session.commit();
        System.out.println(user.getId());
    }