Mybatis的ParameterType传递参数

不写parameterType，用index传参

public List<User> findUserList(String username,String sex);

<!--parameterType不传参，在下面的#{}中用index传递参数-->
    <select id="findUserList" resultType="user" >
          select * from USER where username =#{0} and sex=#{1}
    </select>

使用Map封装

public List<User> findUserListByMap(Map<String,Object> map);

<select id="findUserListByMap" parameterType="hashmap" resultType="user">
        select * from user where sex=#{sex} and username=#{username}
    </select>

测试类

 Map<String,Object> map=new HashMap<String, Object>();
        map.put("sex","女");
        map.put("username","zjn");
        List<User> list=mapper.findUserListByMap(map);
        System.out.println(list);