mybatis嵌套map或者map嵌套的parameterType

深碍√TFBOYSˉ_ 2021-11-29 15:26 372阅读 0赞

# Spring的重要注解 #

# https://www.cnblogs.com/rolandlee/p/11014923.html #

# 一：首先是map嵌套： #

例1：

![1593395-20190617090103911-961823744.png][]

例2：

![1593395-20190617090455171-719433814.png][]

## **总结：** ##

## **paramterType无论是MAP或者是map嵌套的类型都可以，只是在取得参数时的层次不同而已：** ##

# 二：list嵌套MAP #

sevice:

List<Map<String, Object>> device = new ArrayList<>();  
for (int i = 0; i < 2 ; i++) \{  
Map<String, Object> map = new HashMap<>();  
map.put("deviceName", "摄像头");  
map.put("logicId", 1 + i);  
device.add(map);  
\}  
List<DeviceDetail> list = deviceDetailMapper.selectByNameLogicId(device);

dao:

List<DeviceDetail> selectByNameLogicId(List<Map<String, Object>> device);

#### 对应的mapper.xml: ####

<select id="selectByNameLogicId" parameterType="java.util.ArrayList" resultType="DeviceDetail">
        select * from device_detail
        <where>
            (device_name,logic_id) in
            <foreach collection="list" item="item" open="(" close=")" separator=",">
                (#{item.deviceName},#{item.logicId})
            </foreach>
        </where>
    </select>

https://blog.csdn.net/sjmuvx/article/details/79495900

# [mybatis的parameterType使用map实现真正的sql随意写][mybatis_parameterType_map_sql] #

https://www.cnblogs.com/YingYue/p/4126231.html

转载于:https://www.cnblogs.com/leeego-123/p/11024058.html

[1593395-20190617090103911-961823744.png]: /images/20211129/bf924d80af8a4a6a9b47609c97fb0b77.png
[1593395-20190617090455171-719433814.png]: /images/20211129/7e31e116a2194d7e853c6abad07a0a3d.png
[mybatis_parameterType_map_sql]: https://www.cnblogs.com/YingYue/p/4126231.html