MyBatis多属性查询的三种方式

接口方法定义

   List<Player> findPlayer1(Map<String, Object> queryMap);
   List<Player> findPlayer3(PlayerQueryBean playerQueryBean);
   List<Player> findPlayer2(@Param("team") String team, @Param("height") Float height);

一、注解的方式

   // 第二种方式直接使用参数
   String team = "Laker";
   Float height = 1.98F;
   List<Player> list2 = mapper.findPlayer2(team, height);
   System.out.println(list2);
   
    Mapper文件：
    <select id="findPlayer2" resultType="Player">
            select  *
            from tb_player a
            where a.team = #{team} and
            a.height = #{height}
        </select>

二、Map的方式

    // 第一种方式使用map
    String team = "Laker";
    Float height = 1.98F;
    Map<String, Object> params = new HashMap<String, Object>();
    params.put("team", team);
    params.put("height", height);
    List<Player> list1 = mapper.findPlayer1(params);
    System.out.println(list1);
    
    
    Mapper文件：
    <select id="findPlayer1" resultType="Player"
                parameterType="map">
            select *
            from tb_player a
            where a.team = #{team} and
            a.height = #{height}
        </select>

三、Bean的方式

     // 第三种方式用对象
     String team = "Laker";
    Float height = 1.98F;
    PlayerQueryBean playerQueryBean = new PlayerQueryBean();
    playerQueryBean.setTeam(team);
    playerQueryBean.setHeight(height);
    List<Player> list3 = mapper.findPlayer3(playerQueryBean);
    System.out.println(list3);
    
    Mapper文件：
    <select id="findPlayer3" resultType="Player"
          parameterType="com.intellif.mozping.querybean.PlayerQueryBean">
        select  *
        from tb_player a
        where a.team = #{team} and
        a.height = #{height}
    </select>