入参有List

1、xml

<parameterMap   id= "newFailMap"   class= "java.util.HashMap">
    <parameter property= "returnUserId"  jdbcType= "VARCHAR"  javaType= "java.lang.String"   mode= "IN"></parameter>
    <parameter property= "businessRetrunDesc"  jdbcType= "VARCHAR"  javaType= "java.lang.String"   mode= "IN"></parameter>
    <parameter property= "detailList"  jdbcType= "ARRAY"  javaType= "java.util.List"   mode= "IN"
               typeHandler= "com.sinolife.claim.basic.dto.ImageFailedDetailVinArrayTypeHandler"/>
    <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= "newFail"  parameterMap= "newFailMap">
  { call l_claim_public_pkg.add_image_failed_info(?,?,?,?,?) }
</procedure>

2、java

public   void  newFail(HashMap pMap) {
    getSqlMapClientTemplate().queryForList(FailDao. class.getName() + ".newFail", pMap);
}

import  java.sql.CallableStatement;
import  java.sql.Connection;
import  java.sql.PreparedStatement;
import  java.sql.ResultSet;
import  java.sql.SQLException;
import  java.util.ArrayList;
import  java.util.List;
import  oracle.sql.ARRAY;
import  oracle.sql.ArrayDescriptor;
import  oracle.sql.STRUCT;
import  oracle.sql.StructDescriptor;
import  com.ibatis.sqlmap.engine.type.BaseTypeHandler;
import  com.ibatis.sqlmap.engine.type.TypeHandler;
import  com.sinolife.claim.basic.util.CommonFunctions;
import  com.sinolife.sf.framework.comm.ConnectionUtil;
 
public   class  ImageFailedDetailVinArrayTypeHandler   extends  BaseTypeHandler   implements  TypeHandler {
 
    @Override
      public  Object getResult(ResultSet arg0, String arg1)   throws  SQLException {
          return  null;
    }
 
    @Override
      public  Object getResult(ResultSet arg0,   int  arg1)   throws  SQLException {
          return  null;
    }
 
    @Override
      public  Object getResult(CallableStatement arg0,   int  arg1)   throws  SQLException {
          return  null;
    }
 
      /**
     * 构造Oracle能识别的Array
     */
    @Override
      public   void  setParameter(PreparedStatement ps,   int  i, Object parameter, String jdbcType)   throws  SQLException {
          // 本连接池连接
        Connection con   =  ps.getConnection();
          // 获取原生Oracle 连接
        con   =  ConnectionUtil.getNativeConnection(con);
        ArrayList <ImageFailedDetailDto >  list   =  (ArrayList <ImageFailedDetailDto >) parameter;
        ARRAY array;
          try  {
            array   =  getArray(con,   "IMAGCDE.IMAGE_FAILED_DETAILE_OBJ",   "IMAGCDE.IMAGE_FAILED_DETAILE_LIST",list);
            ps.setArray(i, array);
        }   catch  (Exception e) {
            e.printStackTrace();
        }
    }
 
      /**
     * 创建oracle中的Array
     * @param con
     * @param OracleObj
     * @param Oraclelist
     * @param listData
     * @return
     * @throws Exception
     */
      private  ARRAY getArray(Connection con, String OracleObj, String Oraclelist, List <ImageFailedDetailDto >  listData)   throws  Exception {
        ARRAY array   =  null;
        ArrayDescriptor desc   =  ArrayDescriptor.createDescriptor(Oraclelist, con);
        StructDescriptor structdesc   =   new  StructDescriptor(OracleObj, con);
          if  (listData   !=  null   &&  listData.size()   >   0) {
 
            STRUCT[] structs   =   new  STRUCT[listData.size()];
              for  ( int  i   =   0; i   <  listData.size(); i ++) {
                Object[] result   =  { (listData.get(i)).getDocumentId(),
                                    CommonFunctions.isEmpty((listData.get(i)).getReturnUserId()) ? "" :(listData.get(i)).getReturnUserId(),
                                    (listData.get(i)).getReturnTime(),
                                      "",
                                      "",
                                    CommonFunctions.isEmpty((listData.get(i)).getReturnReason()) ? "" :(listData.get(i)).getReturnReason(),
                                    CommonFunctions.isEmpty((listData.get(i)).getBusinessRetrunDesc()) ? "" :(listData.get(i)).getBusinessRetrunDesc(),
                                    CommonFunctions.isEmpty((listData.get(i)).getFileId()) ? "" :(listData.get(i)).getFileId(),
                                    CommonFunctions.isEmpty((listData.get(i)).getImage()) ? "" :(listData.get(i)).getImage()
                                  };
                structs[i]   =   new  STRUCT(structdesc, con, result);
            }
            array   =   new  ARRAY(desc, con, structs);
        }
          return  array;
    }
 
    @Override
      public  Object valueOf(String arg0) {
          return  null;
    }
}

3、pkg

PROCEDURE  add_image_failed_info(p_return_user_id           IN     VARCHAR2,
                                p_business_retrun_desc     IN     VARCHAR2,
                                p_image_faild_detail_lst   IN   IMAGCDE.IMAGE_FAILED_DETAILE_lIST,
                                p_flag                     OUT    VARCHAR2,
                                p_message                  OUT    VARCHAR2)
IS
  v_image_failed_obj    IMAGCDE.IMAGE_FAILED_OBJ;
BEGIN
  p_flag : =   'Y';
  v_image_failed_obj : =  IMAGCDE.IMAGE_FAILED_OBJ(p_return_user_id,
                                                   'N',
                                                 p_business_retrun_desc,
                                                 p_image_faild_detail_lst);
  l_image_claim_interface.add_image_failed_info(v_image_failed_obj,p_flag,p_message);
EXCEPTION
  WHEN OTHERS   THEN
      DECLARE
       v_error_code        VARCHAR2  ( 4000);
       v_comments          VARCHAR2  ( 4000);
       v_program_id        VARCHAR2  ( 50) : =   'add_image_failed_info';
       v_error_message     VARCHAR2  ( 4000);
      BEGIN
       v_error_code : =   NULL;
       v_comments : =   NULL;
       pub_error_handle.exception_no_raise(v_program_id,
                                           v_error_code,
                                           v_comments,
                                           v_error_message);
       p_flag : =   'N';
       p_message : =   'add_image_failed_info发生后台异常，具体原因请查看后台异常处理日志。';
      END;
END  add_image_failed_info;