mybaits四-2:模糊查询

<?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.atchina.dao.IUserDao">
    
    <select id="findByName" parameterType="String" resultType="com.atchina.domain.User">
        select * from user where username like #{uname}
    </select>
</mapper>

 

import com.atchina.dao.IUserDao;
import com.atchina.domain.User;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.io.InputStream;
import java.util.Date;
import java.util.List;

public class MybatisTest {

    InputStream in = null;
    SqlSessionFactory sessionFactory = null;
    SqlSession sqlSession = null;
    IUserDao userDao = null;

    @Before
    public void init() throws Exception{
        in = Resources.getResourceAsStream("SqlMapperConfig.xml");
        sessionFactory = new SqlSessionFactoryBuilder().build(in);
        sqlSession = sessionFactory.openSession();
        userDao = sqlSession.getMapper(IUserDao.class);
    }

    @Test
    public void testFindByName(){
        List<User> users = userDao.findByName("%天%"); // 模糊查询,要加上%
        for (User u : users){
            System.out.println(u);
        }
    }

    @After
    public void destroy() throws Exception{
        // 提交
        sqlSession.commit();

        // 释放资源
        sqlSession.close();
        in.close();
    }
}