mybatis: how to iterate a hashmap in a bean in mapper?

Question

mapper interface:

List<Map<String, String>> selectXXXList(BeanA a);

BeanA:

private Map<String, String> map;

I need iterate this map in xxxMapper.xml. I tried in this way, but it can not work.

<select id = "selectXXXList" resultType="hashMap">
   SELECT * FROM tableA
   WHERE
      1=1 
      <foreach collection="a.map.keys" item="item" index="index" open="" seperator="" close="">
      AND ${item} = #{a.map[${item}]}
      </foreach>
<select>

It is able to iterator the key in this way. But the value of hashMap #{a.map[${item}]} does not work. Any idea? I can not change the interface BTW.

@VinayHegde it is a dynamic query , I want to use key as column value as condition in WHERE — wl.GIG
– wl.GIG, Commented Sep 7, 2019 at 9:48
@VinayHegde it is like select * from tableA where HASHMAP_KEY_A = HASH_VALUE_A and HASHMAP_KEY_B = HASHMAP_VALUE_B — wl.GIG
– wl.GIG, Commented Sep 7, 2019 at 9:57

Vinay Hegde · Accepted Answer · 2019-09-08 07:34:23Z

1

Try this :

<select id="selectXXXList" parameterType="beanA" resultType="hashmap">    
    select * from TABL where 
    <foreach  collection="map"  index="key" item="value"  open=""  separator=" and "  close="">
        ${key}=#{value}
    </foreach>
</select>

edited Sep 8, 2019 at 7:34

answered Sep 7, 2019 at 9:56

Vinay Hegde

1,4481 gold badge14 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

wl.GIG Over a year ago

My parameterType has to be beanA, which is not a HASHMAP.

wl.GIG Over a year ago

Thanks , I would try it. But I don’t think it work.

wl.GIG Over a year ago

I think mybaits can not obtain the flied in a bean in this way. I am not sure,XD.

wl.GIG Over a year ago

Ah, I know this way work. But I have to use a bean as parameter.

ave Over a year ago

Replace #{key} with ${key} and this should work. Here is a portable demo.

|

Collectives™ on Stack Overflow

mybatis: how to iterate a hashmap in a bean in mapper?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related