mybatis遍历map里的map值(格式)

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() )