动态SQL文中where条件是IN,而导入的参数个数不确定,
比如根据不同情况,可能IN的参数是3个,也许是5个
那么就需要用到如下方法:
<selectid="selectProductList"parameterClass="list"resultClass="ProductBean">
SELECT * FROM product WHERE pname in <iterateopen="("close=")"conjunction=",">#[]#</iterate> </select>