controller
map.put("map1",map1);
Service.savaInfo(map);
mapper
void savaDevDownInfo(Map<Object, Object> map);
xml
<insert id="savaInfo" parameterType="map">
<foreach collection="map1.keys" item="key" index="key">
insert into xxx(devid,devCode,
downTitCode,downVal,createTime) VALUES(#{devid},#{devCode}, #{key},#{map1[${key}]},now());
</foreach>
遍历map携带的map值
key值做为数据库表的列,value作为值
2.mybatis返回主键
<insert id="insertDevInfo" parameterType="DevInfo" useGeneratedKeys="true" keyProperty="id">
主要:useGeneratedKeys="true" keyProperty="id,keyProperty数据库字段名称,useGeneratedKeys参数值为false,添加记录之后将不能返回注解ID,useGeneratedKeys允许jdbc自动生成主键
注意:返回主键id在数据库必须是自增长
Integer number = Service.insertInfo(devInfo);
System.out.println(Info.getId() )