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;
}