java mybatis 利用 map 实现执行sql动态输入和动态返回

mapper.xml

<select id="getDemoData" parameterType="hashMap" resultType="java.util.Map">
        SELECT #{id} as id
</select>

mapper

List<Map<String, Object>> getDemoData(Map<String,Object> parameters);

service 接口：

List<Map<String, Object>> getDemoData(Map<String,Object> parameters);

service 实现：

@Override
    public List<Map<String, Object>> getDemoData(Map<String,Object> parameters) {
        return this.baseMapper.getDemoData(parameters);
    }

调用示例：

var parameters = new HashMap<String,Object>();
parameters.put("id",456);
var ret = xxxService.getDemoData(parameters);