技术问答mybatis鎬庝箞閬嶅巻map闆嗗悎 - 扬州沐宇科技

鍦∕yBatis涓紝鍙互閫氳繃浣跨敤foreach鏍囩鏉ラ亶鍘哅ap闆嗗悎銆備互涓嬫槸涓€涓ず渚嬶細

<select id="selectByMap" parameterType="map" resultType="com.example.User">
    SELECT * FROM user
    WHERE id IN
    <foreach collection="ids" item="id" open="(" separator="," close=")">
        #{id}
    </foreach>
</select>

鍦ㄨ繖涓ず渚嬩腑锛屾垜浠€氳繃selectByMap鏂规硶鏌ヨuser琛ㄤ腑鐨勬暟鎹紝骞朵笖浣跨敤foreach鏍囩閬嶅巻Map涓殑ids闆嗗悎锛屽皢鍏朵腑鐨刬d鍊间綔涓烘煡璇㈡潯浠躲€傚湪foreach鏍囩涓紝collection灞炴€ф寚瀹氫簡瑕侀亶鍘嗙殑Map闆嗗悎锛宨tem灞炴€ф寚瀹氫簡鍦ㄩ亶鍘嗚繃绋嬩腑浣跨敤鐨勯敭鍚嶏紝open灞炴€ф寚瀹氫簡閬嶅巻寮€濮嬫椂鐨勫瓧绗︼紝separator灞炴€ф寚瀹氫簡鍦ㄦ瘡娆￠亶鍘嗕箣闂寸殑鍒嗛殧绗︼紝close灞炴€ф寚瀹氫簡閬嶅巻缁撴潫鏃剁殑瀛楃銆?/p>

浣跨敤foreach鏍囩鍙互鏂逛究鍦伴亶鍘哅ap闆嗗悎涓殑鏁版嵁锛屽苟灏嗗叾鐢ㄤ簬鍔ㄦ€佺敓鎴怱QL璇彞銆?/p>