需要 spring jdbc 结果集返回对象列表而不是 LinkedHashMap [英] Need spring jdbc resultset to return list of objects instead of LinkedHashMap

问题描述

我正在使用行映射器，期望它返回我的对象​​列表，但它返回的是 LinkedHasMap.我希望结果集是我的映射对象列表.

I am using with a row mapper expecting it wuold return me the list of my objects but instead it is returning me LinkedHasMap. I want resultset to be List of my mapped objects.

知道我怎样才能做到这一点吗?

Any idea how can i achieve this ?

配置

<int-jdbc:stored-proc-inbound-channel-adapter
                        channel="eventObj" 
                        stored-procedure-name="p_get_completed_data"
                        data-source="dataSource"
                        auto-startup="true"
                        id="completedEventAdpt"
                        ignore-column-meta-data="true"
                        is-function="false"                     
                        return-value-required="false">
        <int:poller max-messages-per-poll="1" fixed-rate="180000"/>     
        <int-jdbc:returning-resultset  name="mapper" row-mapper="mapper" />
    </int-jdbc:stored-proc-inbound-channel-adapter>

<bean id="mapper" class="com.db.mapper.MyMapper"/>

推荐答案

存储过程可以返回多个结果集，以参数名称为键.

Stored procedures can return multiple result sets, keyed by the parameter name.

在您的情况下，您只有一个结果集，但它仍然在地图中返回.

In your case, you only have one result set, but it's still returned in a map.

只需在入站适配器后面添加一个 ...

Simply add a <transformer/> after the inbound adapter...

<transformer ... expression="payload['mapper']" />

这篇关于需要 spring jdbc 结果集返回对象列表而不是 LinkedHashMap的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！