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"/>

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

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.

View raw message