how to write foreach loop for update query in mapper interface in mybatis

Question

I have a update query in mapper interface using mybatis

 final String UPDATE ="update table_addresses "
                            + "set postCode= #{postCode}"
                            + "where id in"
                            + "<foreach item='item' index='index' 
                               collection='addressId' "
                            + "open='(' separator=',' close=')'>  #{item} 
                 </foreach>";
@Update(UPDATE)
public int updateInformation(@Param("postCode") String postCode , 
@Param("addressId") List<AddressID> addressId);

My AddressId class contains int type addressId:

AddressId {
private int addressId;
}

Now the method where I am calling mapper Interface..I am sending a String postCode and object List addresses.

I am getting below error Caused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'item' not found. Available parameters are [param1, param2, postCode, addressId]..What Ia m doing wrong here.What is the correct syntax of foreach loop where I can pass addressId which conatins List.

Dean Xu · Accepted Answer · 2018-02-05 03:41:17Z

0

For the complex sql statments. I prefer to use SelectBuilder/UpdateBuilder.

See the last part of this page mybatis-java-api

answered Feb 5, 2018 at 3:41

Dean Xu

4,7411 gold badge19 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mr Lister · Accepted Answer · 2018-03-05 17:40:58Z

0

Try to wrap your whole SQL code in <script> tag like String SQL = "<script>(SQL goes here)</script>" if you use XML tags inside annotation defined query. Probably MyBatis doesn't see your #{item}, because it doesn't know about it (it treats all as SQL).

But, as Dean Xu sais, sql builder is better for more complicated queries.

edited Mar 5, 2018 at 17:40

Mr Lister

46.8k15 gold badges118 silver badges156 bronze badges

answered Mar 2, 2018 at 14:17

Elas

2824 silver badges16 bronze badges

Collectives™ on Stack Overflow

how to write foreach loop for update query in mapper interface in mybatis

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related