list mybatis 接收 类型_mybatis 传map中有list类型获取值

json:

{"cuserid": "000178100000000UC4DN",

"pk_trade": "0001561000000030U9IR",

"fundsetList": [

{"fundtypeCode":"0101","fundsetCode":"010102"},

{"fundtypeCode":"0105","fundsetCode":"010501"}

]}

mybatis:

pstp.pk_trade as "pk_trade",

pbfs.vname AS "fundsetName",

pbfs.vcode as "funtsetCode",

pstp.nrealmny as "nrealmny",

pstp.noffsetmny as "noffsetmny",

pstp.ncansetmny as "ncansetmny",

case to_char(pstp.fcollectstate)

when '1' then '收齐'

when '2' then '欠收'

when '3' then '超收'

else ''

end as "fcollectstate"

select distinct

from ps_sm_trade_pro pstp

left join ps_bd_fundset pbfs on pbfs.pk_fundset = pstp.pk_fundset

left join ps_bd_fundtype pbft on pbft.pk_fundtype = pbfs.pk_fundtype

where pstp.pk_trade = #{pk_trade}

and

(pbft.vcode = #{item.fundtypeCode} and pbfs.vcode = #{item.fundsetCode} )

Colynlin

发布了80 篇原创文章 · 获赞 0 · 访问量 673

私信

关注

标签：map,pstp,fundtype,pbfs,list,trade,fundset,mybatis,pk

来源： https://blog.csdn.net/weixin_42699486/article/details/94577603