mybatis-like模糊查询

在MySQL中
SELECT * FROM books WHERE bookName LIKE CONCAT(‘%‘,‘入门‘,‘%‘)

<select id="fuzzyQuery" resultType="books" parameterType="string">
        SELECT * FROM books WHERE bookName LIKE CONCAT(‘%‘,#{bookName},‘%‘)
    </select>

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class test {
    @Autowired
    private BookMapper bookMapper;

    @Test
    public void test(){
        List<Books> booksList = bookMapper.fuzzyQuery("入门");
        for (Books books : booksList) {
            System.out.println(books);
        }
    }
}