ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jesid <javav...@gmail.com>
Subject Re: mutiple parameters in query
Date Fri, 22 Aug 2008 15:12:29 GMT

I found the answer and it is this :clap:

List result = sqlMap.queryForList("twoTables", params);


and the xml

<resultMap id="paramTable" class="hashmap">
	<result property="cod" column="COD"/>
	<result property="default" column="DEF"/>
	<result property="codeCar" column="COD_CAR"/>
	<result property="name" column="NAME"/>
</resultMap>

<select id="twoTables" resultClass="hashmap" resultMap="paramTable">
	SELECT 
	        *
	FROM 
	        IPS_CARA car,
	        IPS_PERSON per
	WHERE
	        car.COD_CAR = per.COD_CAR and
	        car.COD = #codeCar#
</select>


thus returns a list filled with hasMap containing all objects.

Good luck
-- 
View this message in context: http://www.nabble.com/mutiple-parameters-in-query-tp19098786p19108786.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message