mybatis---遍历map做参数

    技术2022-07-10  140

    Map<String, Object> ret = new HashMap<String, Object>(); ret.put("jcContent", jcContent); ret.put("todadyTime", todadyTime); ret.put("nextTime", nextTime); <insert id="addJctx" parameterType="Map"> insert into examine <foreach item="item" index="key" collection="paramsMap.keySet()" separator="," open="(" close=")"> ${item} </foreach> values <foreach item="item" index="value" collection="paramsMap.entrySet()" separator="," open="(" close=")"> #{item} </foreach> </insert>

    二:

    Map<String, Object> maps = new HashMap<String, Object>(); maps.put("patid", patid); maps.put("txrq", time); maps.put("tqtz", weight); <insert id="yyy" parameterType="Map"> insert into xxx <foreach collection="maps.keys" item="key" open="(" close=")" separator="," > ${key} </foreach> values <foreach collection="maps.keys" item="key" open="(" close=")" separator=","> #{maps[${key}]} </foreach> </insert>
    Processed: 0.010, SQL: 9