mybatis执行原生sql,动态传参

mapper和xml

    int add(@Param("sql") String sql, @Param("param") Map<String, Object> p);

  <insert id="add" parameterType="hashmap">
        ${sql}
    </insert>

使用：

 @Test
    public void testAdd(){
        IdentifierGenerator identifierGenerator = new DefaultIdentifierGenerator();
        Number id = identifierGenerator.nextId(new Object());

        String sql="insert into gz_test_c2(id,wp_name) values(#{p.id},#{p.wp_name})";
        Map<String,Object> map = new HashMap<>();
        map.put("id",id);
        map.put("wp_name","test");

        formMapTableMapper.add(sql,map);
    }