MyBatis query result in a HashMap?

Question

For the below query,

 SELECT 
     MSGS.MSGTYPE,
     count(*) as NOOFRECORDS 
 FROM 
     SCHEMA.MESSAGES MSGS
 GROUP BY 
     MSGS.MSGTYPE

What would be the equivalent in MyBatis mapper so that I can get a Result as a HashMap with MSGS.MSGTYPE as the key and NOOFRECORDS as the value ?

I got a good reference here so i guess i have my answer http://stackoverflow.com/questions/11913013/return-hashmap-in-mybatis-and-use-it-as-modelattribute-in-spring-mvc — V R, Nov 13 '14 at 21:38

score 15 · Accepted Answer · edited May 23 '17 at 12:32

15

<select id="selectAllCategories" resultType="hashmap">
 select id, name from categories  
</select>

and More details here

edited May 23 '17 at 12:32

Community

answered Nov 17 '14 at 21:59

V R

1 Answers1