xml中使用foreach遍历对象
如果是一个带数据的List对象
<select id="selectProductMSTList" resultType="java.util.Map" parameterType="map"> SELECT <foreach collection="fields" item="field" index="index" close="" separator=","> #{field.tablekoumokuNames,jdbcType=VARCHAR} </foreach> FROM ${temp}.m_product LEFT JOIN ${temp}.m_type_cd ON ${temp}.m_product.product_group_cd = ${temp}.m_type_cd.type_cd WHERE ${temp}.m_product.anken_id = #{ankenId,jdbcType=VARCHAR} AND ${temp}.m_product.subsidiary_cd = #{subsidiaryCd,jdbcType=VARCHAR} AND ${temp}.m_product.sub_anken_id = #{subAnkenId,jdbcType=VARCHAR} ORDER BY ${temp}.m_product.subsidiary_cd ASC, ${temp}.m_product.brand_cd ASC, ${temp}.m_product.product_cd ASC </select>
遍历一个map对象:
Map<String,Object> xx=new HashMap<String, Object>(); xx.put("22","ABC"); paramMap.put("maps",xx);
<foreach collection="maps" item="field" index="key" separator=","> ${field}={key} </foreach>
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步