Ibatis using list as parameter to generate in statement

There are times when you need to use list to make parameters, and the contents of the list are used to generate SQL statements with "in", Sqlmap as follows:

<select id= "Gethdriskbycodes" parameterclass= "java.util.ArrayList" resultmap= "Hdriskresult" > select * from Hd_ Risk hr where Hr.code in <iterate open= "(" close= ")" conjunction= "," > #codeList []# </iterate> ORDER by Hr.code </select>

Where Codelist is the name of the list instance named in the DAO implementation, the following "[]" must be added.