Question

请问各位java高手，java（spring）如何解析oracle返回的list和map对象？

例如oracle的函数返回记录集：

FUNCTION FUNC_Wechat_queryClmList(i_NotifyPhoneNo in varchar2, i_Type in varchar2)
RETURN queryClmListList IS
resultlist queryClmListList;
BEGIN
--获取理赔赔案信息
SELECT a.insurantname,
a.licenseno,
a.CardNo,
a.policyno,
a.applytelephone,
a.claimno,
a.caseno,
a.notifyman,
a.NotifyPhoneNo,
a.notifydate,
a.damagedate,
a.damageplace,
a.unitname,
a.unitcode BULK COLLECT
INTO resultlist
FROM (SELECT c.insurantname,
c.licenseno,
p.sid CardNo,
c.policyno,
p.applytelephone,
c.claimno,
c.caseno,
c.notifyman,
c.telephone NotifyPhoneNo,
c.notifydate,
c.damagedate,
(select a.areaname from d_area a where a.areacode = c.province) ||
(select a.areaname from d_area a where a.areacode = c.city) ||
(select a.areaname from d_area a where a.areacode = c.area) ||
c.damageplace as damageplace,
(select du.UnitName from d_unit du where du.unitcode = c.unitcode) as UnitName,
c.unitcode
FROM c_claim c, p_public_policy p
WHERE c.applyno = p.applyno
AND c.applyendorseno = p.applyendorseno
AND (c.Telephone = trim(i_NotifyPhoneNo) OR c.Telephone = '0' || trim(i_NotifyPhoneNo))
AND c.ismain = '1'
AND ((i_Type = '1' and c.endstatus = '0') OR i_Type = '2')
ORDER BY c.notifydate desc) a
WHERE rownum < 10;

return resultlist;
end FUNC_Wechat_queryClmList;
那么在java端，spring的jdbc端如何解析resultlist对象，并将它封装为list呢？

Answer 1

public List<HlVO> getHlVoByZyid(String zyid) {
String sql = "select a.id,b.zyxsz,a.hbdw,a.hbzsl,a.hlrq,a.xgrq from mdt_hlb a, mdt_sjzd_dmb b where a.zyid=b.id and a.zyid = ? order by a.hlrq";
List<HlVO> hlVoList = getJdbcTemplate().query(sql, new Object[]{zyid}, new RowMapper(){
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
HlVO hlVo = new HlVO();
hlVo.setId(rs.getString(1));
hlVo.setZyxsz(rs.getString(2));
hlVo.setHbdw(rs.getInt(3));
hlVo.setHbzsl(rs.getDouble(4));
hlVo.setHlrq(rs.getDate(5));
hlVo.setXgrq(rs.getDate(6));
return hlVo;
}
});
return hlVoList;

}
这个是例子，你可以看到，从数据库获取来的数据，没条记录的每个列都可以获得，那么根据你的需求获取
建立一个类，把获取到的塞给这个类的对象就好了。

Answer 2

你是说 spring jdbctemplate 么？
跟普通 select 一样的 mapper 呀

追问

恩，我担心的是这里是由function返回的list，不是普通的select啊。
还有个问题，如果返回的记录集的字段里面还有记录集，又该如何解析呢？

追答

第一个没啥区别
第二个，貌似解不了