1、xml
<!-- 查询二核历程 -->
<parameterMap id="queryUndwrtTraceMap" class="java.util.HashMap">
<parameter property="claimNo" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"></parameter>
<parameter property="voutObject" jdbcType="ARRAY" mode="OUT" typeName="NBUCDE.REC_TAB_UNDWRT_TRACE"/>
<parameter property="flag" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"></parameter>
<parameter property="message" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"></parameter>
</parameterMap>
<!-- 查询二核历程 -->
<procedure id="queryUndwrtTrace" parameterMap="queryUndwrtTraceMap">
<![CDATA[
{call l_claim_public_pkg.query_undwrt_trace(?,?,?,?)}
]]>
</procedure>
<parameterMap id="queryUndwrtTraceMap" class="java.util.HashMap">
<parameter property="claimNo" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"></parameter>
<parameter property="voutObject" jdbcType="ARRAY" mode="OUT" typeName="NBUCDE.REC_TAB_UNDWRT_TRACE"/>
<parameter property="flag" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"></parameter>
<parameter property="message" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"></parameter>
</parameterMap>
<!-- 查询二核历程 -->
<procedure id="queryUndwrtTrace" parameterMap="queryUndwrtTraceMap">
<![CDATA[
{call l_claim_public_pkg.query_undwrt_trace(?,?,?,?)}
]]>
</procedure>
2、java
public Map<String ,Object> queryUndwrtTrace(String claimNo)
{
Map<String ,Object> result=new HashMap<String ,Object>();
List<UndwrtTraceDto> list=new ArrayList<UndwrtTraceDto>();
Map map=new HashMap();
map.put("claimNo", claimNo);
getSqlMapClientTemplate().queryForObject(UnderwritingInfoDao.class.getName()+".queryUndwrtTrace", map);
if(CommonFunctions.NO.equals((String)map.get(CommonFunctions.FLAG)))
{
result.putAll(map);
return result;
}
try {
ARRAY array = (ARRAY)map.get("voutObject");
if(array!=null)
{
Object[] obj = (Object[])array.getArray();
STRUCT struct = null;
if(obj!=null)
{
for(int i=0;i<obj.length;i++){
UndwrtTraceDto undwrtTraceDto=new UndwrtTraceDto();
struct = (STRUCT)obj[i];
Object[] obj1 = (Object[])struct.getAttributes();
//任务编号
undwrtTraceDto.setTaskCode((String)obj1[0]);
//核保员代码
undwrtTraceDto.setUndwrterNo((String)obj1[1]);
//核保历程描述
undwrtTraceDto.setTrackDesc((String)obj1[2]);
//创建时间
undwrtTraceDto.setCreatedDate((java.util.Date)obj1[3]);
list.add(undwrtTraceDto);
}
}
}
} catch (SQLException e) {
e.printStackTrace();
}
result.put("list", list);
return result;
}
{
Map<String ,Object> result=new HashMap<String ,Object>();
List<UndwrtTraceDto> list=new ArrayList<UndwrtTraceDto>();
Map map=new HashMap();
map.put("claimNo", claimNo);
getSqlMapClientTemplate().queryForObject(UnderwritingInfoDao.class.getName()+".queryUndwrtTrace", map);
if(CommonFunctions.NO.equals((String)map.get(CommonFunctions.FLAG)))
{
result.putAll(map);
return result;
}
try {
ARRAY array = (ARRAY)map.get("voutObject");
if(array!=null)
{
Object[] obj = (Object[])array.getArray();
STRUCT struct = null;
if(obj!=null)
{
for(int i=0;i<obj.length;i++){
UndwrtTraceDto undwrtTraceDto=new UndwrtTraceDto();
struct = (STRUCT)obj[i];
Object[] obj1 = (Object[])struct.getAttributes();
//任务编号
undwrtTraceDto.setTaskCode((String)obj1[0]);
//核保员代码
undwrtTraceDto.setUndwrterNo((String)obj1[1]);
//核保历程描述
undwrtTraceDto.setTrackDesc((String)obj1[2]);
//创建时间
undwrtTraceDto.setCreatedDate((java.util.Date)obj1[3]);
list.add(undwrtTraceDto);
}
}
}
} catch (SQLException e) {
e.printStackTrace();
}
result.put("list", list);
return result;
}