MyBatis支持的jdbcType类型

BIT         FLOAT      CHAR           TIMESTAMP       OTHER       UNDEFINED

TINYINT     REAL       VARCHAR        BINARY          BLOB        NVARCHAR

SMALLINT    DOUBLE     LONGVARCHAR    VARBINARY       CLOB        NCHAR

INTEGER     NUMERIC    DATE           LONGVARBINARY   BOOLEAN     NCLOB

BIGINT      DECIMAL    TIME           NULL            CURSOR

 1     <resultMap type="java.util.HashMap" id="cursorMap">
 2     </resultMap>
 3     <select id="paging" parameterType="map" statementType="CALLABLE">
 4         {CALL EXTRA_WORK_APPLY_DB(
 5             #{USER_ID,mode=IN,jdbcType=VARCHAR},
 6             #{PROC_DEF_ID,mode=IN,jdbcType=VARCHAR},
 7             #{START_NUM,mode=IN,jdbcType=INTEGER},
 8             #{END_NUM,mode=IN,jdbcType=INTEGER},
 9             #{SUCESS_FLAG,mode=OUT,jdbcType=VARCHAR},
10             #{SUCESS_MSG,mode=OUT,jdbcType=VARCHAR},
11             #{V_CURSOR,mode=OUT,jdbcType=CURSOR,resultMap=cursorMap}
12         )}
13     </select>