[ACCEPTED]-Passing multiple arguments into a SELECT without using a complex object-mybatis
You can use the built in parameterType 'map' eg
Map<String, Object> parms = new HashMap<String, Object>();
parms.put("name", "abc");
parms.put("phone", "123");
parms.put("email", "123@email.com");
List<Contact> list = myBatis.selectList("getContacts",parms);
<!-- in xml mapper -->
<select id="getContacts" parameterType="map" resultMap="Contact">
SELECT * FROM CONTACT
WHERE CONTACT_NAME = ${name}
AND CONTACT_PHONE = ${phone}
AND CONTACT_MAIl = ${email}
</select>
0
@Chin I'll post what I had typed anyway 3 with a simple example though you found what 2 your looking for. My example using iBatis 1 2.3.4
<select id="retrieveTestXXX" parameterClass="java.util.Map" resultClass="java.lang.Integer">
SELECT
example_table.id
FROM example_table
WHERE example_table.xx_id = #testId# AND example_table.xx_id = #test2Id#
</select>
Hope this helps.
In MyBatis 3, you can use @Param annotation in 3 your mapper class(interface) method:
public getSequenceIdByOrderNumber(@Param("seqId") int sequenceId,@Param("orderId") int orderNo);
Then 2 you can use #{seqId}, #{orderId} in the SQL without using 1 parameterType attribute.
cant comment,
Found the answer, thanks.
http://code.google.com/p/mybatis/wiki/HowToSelectMultipleParams
this 9 link is broken, currently correct one is 8 https://github.com/mybatis/mybatis-3/wiki/FAQ#how-do-i-use-multiple-parameters-in-a-mapper
copy + paste from this wiki
Java reflection does not provide a way to 7 know the name of a method parameter so MyBatis 6 names them by default like: param1, param2... If 5 you want to give them a name use the @param 4 annotation this way:
import org.apache.ibatis.annotations.Param;
public interface UserMapper {
User selectUser(@Param("username") String username, @Param("hashedPassword") String hashedPassword);
}
Now you can use them 3 in your xml like follows:
<select id=”selectUser” resultType=”User”>
select id, username, hashedPassword
from some_table
where username = #{username}
and hashedPassword = #{hashedPassword}
</select>
tl;dr
when you declare 2 method in your interface instead of standard 1 java structure
Type methodName (
ParamType1 paramName1,
ParamType2 paramName2,
… ); (this is interface so no method body)
use (add @Param)
Type methodName (
@Param("name1 available in xml") ParamType1 paramName1,
@Param("name2 available in xml") ParamType2 paramName2,
…); (this is still interface so no method body)
More Related questions
We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.