mybatis的foreach插入List，Array，Map_mybatis foreach list嵌套list

list保存

1、xml文件

  <!-- 保存List-->
  <insert id="saveList" parameterType="java.util.List">
    INSERT INTO user_info(id,username,password) VALUES
    <foreach collection="list" item="userinfo" separator=",">
   (#{userinfo.id}, #{userinfo.username}, #{userinfo.password})
    </foreach>
  </insert>
1
2
3
4
5
6
7

2、mapper

void saveList(List<UserInfo> userInfos);
1

Array保存

1、xml文件

  <!-- 保存List-->
   <insert id="saveArray" parameterType="java.util.List">
    INSERT INTO user_info(id,username,password) VALUES
    <foreach collection="array" item="userinfo" separator=",">
    (#{userinfo.id}, #{userinfo.username}, #{userinfo.password})
    </foreach>
  </insert>
1
2
3
4
5
6
7

2、mapper

void saveArray(UserInfo[] userInfos);
1

Map保存

1、xml

<!-- 保存Map-->
  <insert id="saveMap" parameterType="java.util.Map">
    INSERT INTO user_info
    <foreach collection="userInfoMap.keys" item="key" separator="," open="(" close=")">
      ${key}
    </foreach>
    VALUES
    <foreach collection="userInfoMap.keys" item="userValue" separator="," open="(" close=")">
      #{userInfoMap[${key}]}
    </foreach>
  </insert>
1
2
3
4
5
6
7
8
9
10
11

2、map

void saveMap(@Param("userInfoMap")Map<String,Object> userInfoMap);
1

测试代码：

@RunWith(SpringJUnit4ClassRunner.class)
@WebAppConfiguration
@Transactional
@SpringBootTest(classes = Application.class)
public class UserTest {
    @Autowired
    private UserInfoMapper userInfoMapper;

    private List<UserInfo> initUserList(){
        List<UserInfo> userInfoList = new ArrayList<>();
        for (int i = 210; i < 211; i++){
            UserInfo userInfo = new UserInfo();
            userInfo.setId(i);
            userInfo.setUsername("zzr"+i);
            userInfo.setPassword("zzr"+i);
            userInfoList.add(userInfo);
        }
        return userInfoList;
    }

    private UserInfo[] initUserArray(){
        List<UserInfo> userInfoList = initUserList();
        UserInfo[] userInfos = new UserInfo[userInfoList.size()];
        int i = 0;
        for (UserInfo userInfo : userInfoList){
            userInfos[i++] = userInfo;
        }
        return userInfos;
    }

    /**
     * 保存List
     */
    @Test
    public void saveList(){
        userInfoMapper.saveList(initUserList());
    }
    /**
     * 保存数组
     */
    @Test
    public void saveArray(){
        userInfoMapper.saveArray(initUserArray());
    }

    /**
     * 保存map
     */
    @Test
    public void saveMap(){
        Map map = new HashMap();
        map.put("id",1000);
        map.put("username",1000);
        map.put("password",1000);
        userInfoMapper.saveMap(map);
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57