You will need a result map (as you do, but just mentioning it because it is
required) and queryForMap as Larry said:
Map<String, String> result = (Map<String, String>)
queryForMap("getProperties", null, "propName", "propValue");
<resultMap id="getPasswordsMap" class="java.util.HashMap">
<result property="propName" column="PropName"/>
<result property="propName" column="PropName"/>
</resultMap>
<select id="getProperties" resultMap="getPropertiesMap" >
SELECT PropName, PropValue FROM Properties
</select>
-----Original Message-----
From: Collin Peters [mailto:[EMAIL PROTECTED]
Sent: 10 May 2007 06:18 PM
To: [email protected]
Subject: Store results directly into a single HashMap
Hello All,
I'm wondering if iBatis can take a simple query that returns
name/value pairs (i.e. two columns of many records) and store it into
a *single* hashmap
So the results of the query look something like:
name | value
name1 | value 1
name2 | value 2
name3 | value 3
etc....
And at the end I want a single HashMap object with those name/value
pairs. My current code looks like this and returns a list of
HashMaps, and each HashMap has two name/value pairs(name=name1,
value=value 1, etc...)
<resultMap id="configResult" class="java.util.HashMap">
<result property="name" column="name"/>
<result property="value" column="value"/>
</resultMap>
<select id="loadConfig" parameterClass="java.util.Map"
resultMap="configResult">
SELECT name, value
FROM ....
</select
Collin
