mybatis插入数据是参数map且map中values为对象的处理_JAVA_编程开发_程序员俱乐部

class="java">    <insert id="insertWinePrice" parameterType="java.util.Map">
        insert into wineprice (id,price,time) VALUES
        <foreach collection="params.keys" item="key" open="("  separator=",">
            ${key}
        </foreach>
        ,
        <foreach collection="params.values" item="v" close=")"  separator=",">
            #{v.m},#{v.p}
        </foreach>
    </insert>

public void insertWinePrice(@Param("params") Map<Integer,JdWinePo> map);

        Reader reader = Resources.getResourceAsReader("config/conf.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession sqlSession = factory.openSession();
        JdMapper jm = sqlSession.getMapper(JdMapper.class);
        Map<Integer,JdWinePo> map = new HashMap<Integer, JdWinePo>();
        JdWinePo j = new JdWinePo();
        j.setId("3232");
        j.setM("erwewr");
        j.setOp("fsaeet");
        j.setP("4343");
        map.put(212112,j);
        jm.insertWinePrice(map);
        sqlSession.commit();
        sqlSession.close();