使用mybatis的模糊查找

使用mybatis的模糊查找

写入方法getUserLike：

package com.zsp.dao;

import com.zsp.pojo.User;

import java.util.List;

public interface UserMapper {
    List<User> getUserList();
    List<User> getUserLike(String like);
}

绑定方法：

<?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=第定·个对应mDao/Mapper接-->
<mapper namespace="com.zsp.dao.UserMapper">
<!--    type里面写泛型的东西        -->
    <select id="getUserList" resultType="com.zsp.pojo.User">
        select *from mybaties.user;
    </select>
    <select id="getUserLike" parameterType="String" resultType="com.zsp.pojo.User">
        select *from mybaties.user where name like #{like} ;
    </select>
</mapper>

在test里面使用这个方法完成模糊查找：

package com.zsp.dao;


import com.zsp.pojo.User;
import com.zsp.utils.MybatiesUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class UserMapperTest {
    @Test
    public void testgetUserList(){
        SqlSession session = MybatiesUtils.getSession();
//        1方式: getMapper
        UserMapper mapper = session.getMapper(UserMapper.class);
        List<User> userList = mapper.getUserList();
        for (User user: userList){
            System.out.println(user);
        }
//        关闭jSqlSession
        session.close();
    }
    @Test
    public void testgetUserLike(){
        SqlSession session = MybatiesUtils.getSession();
        UserMapper mapper = session.getMapper(UserMapper.class);
        List<User> users = mapper.getUserLike("%朱%");
        for (User user : users) {
            System.out.println(user);
        }
    }

}