MyBatis入门操作

MyBatis入门操作，其实是我只想验证一下instanceof是否能在xml中使用
根据官网，下面我创建一个普通Maven项目，引入依赖：

        
            org.mybatis
            mybatis
            3.5.7
        
        
            mysql
            mysql-connector-java
            5.1.49
        
        
            junit
            junit
            4.13.2
        

resources/mybatis-config.xml

resources/dao/test.xml

    
        select * from user where
        
             `password` in
            
                #{item}
            
        
        
             `password`=#{password}
        

    

测试代码

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.Test;

import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class ListTest01 {

    @Test
    public void Test01() throws Exception {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        Map map=new HashMap<>();
        List list=new ArrayList<>(2);
        list.add("2");
        list.add("123");
        map.put("password",list);
        // map.put("password","2");
        List