ibatis方面的大神求帮忙,该怎么解决
ibatis方面的大神求帮忙
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="ReportProcedureEntity">
<resultMap id="rsltEntityMap1" class="com.dicc.domain.ReportProcedureEntity">
<result column="GRP_CD" property="grpCd" jdbcType="VARCHAR" />
<result column="KPI_CD" property="kpiCd" jdbcType="VARCHAR" />
<result column="KPI_NM" property="kpiNm" jdbcType="VARCHAR" />
<result column="ORG_LEVEL" property="orgLevel" jdbcType="VARCHAR" />
<result column="ORG_CD" property="orgCd" jdbcType="VARCHAR" />
<result column="ORG_NM" property="orgNm" jdbcType="VARCHAR" />
<result column="SVC_TYPE_CD" property="svcTypeCd" jdbcType="VARCHAR" />
<result column="SVC_TYPE_NM" property="svcTypeNm" jdbcType="VARCHAR" />
<result column="D1_NM" property="d1Nm" jdbcType="VARCHAR" />
<result column="D1_VAL" property="d1Val" jdbcType="VARCHAR" />
<result column="D1_UNIT" property="d1Unit" jdbcType="VARCHAR" />
<result column="D2_NM" property="d2Nm" jdbcType="VARCHAR" />
<result column="D2_VAL" property="d2Val" jdbcType="VARCHAR" />
<result column="D2_UNIT" property="d2Unit" jdbcType="VARCHAR" />
<result column="D3_NM" property="d3Nm" jdbcType="VARCHAR" />
<result column="D3_VAL" property="d3Val" jdbcType="VARCHAR" />
<result column="D3_UNIT" property="d3Unit" jdbcType="VARCHAR" />
<result column="D4_NM" property="d4Nm" jdbcType="VARCHAR" />
<result column="D4_VAL" property="d4Val" jdbcType="VARCHAR" />
<result column="D4_UNIT" property="d4Unit" jdbcType="VARCHAR" />
<result column="D5_NM" property="d5Nm" jdbcType="VARCHAR" />
<result column="D5_VAL" property="d5Val" jdbcType="VARCHAR" />
<result column="D5_UNIT" property="d5Unit" jdbcType="VARCHAR" />
<result column="D6_NM" property="d6Nm" jdbcType="VARCHAR" />
<result column="D6_VAL" property="d6Val" jdbcType="VARCHAR" />
<result column="D6_UNIT" property="d6Unit" jdbcType="VARCHAR" />
<result column="D7_NM" property="d7Nm" jdbcType="VARCHAR" />
<result column="D7_VAL" property="d7Val" jdbcType="VARCHAR" />
<result column="D7_UNIT" property="d7Unit" jdbcType="VARCHAR" />
<result column="D8_NM" property="d8Nm" jdbcType="VARCHAR" />
<result column="D8_VAL" property="d8Val" jdbcType="VARCHAR" />
<result column="D8_UNIT" property="d8Unit" jdbcType="VARCHAR" />
<result column="D9_NM" property="d9Nm" jdbcType="VARCHAR" />
<result column="D9_VAL" property="d9Val" jdbcType="VARCHAR" />
<result column="D9_UNIT" property="d9Unit" jdbcType="VARCHAR" />
<result column="D10_NM" property="d10Nm" jdbcType="VARCHAR" />
<result column="D10_VAL" property="d10Val" jdbcType="VARCHAR" />
<result column="D10_UNIT" property="d10Unit" jdbcType="VARCHAR" />
<result column="CREATE_TIME" property="createTime" jdbcType="DATE"/>
</resultMap>
<parameterMap id="manualDispLayMap" class="java.util.Map" >
<parameter property="P_GRP_CD" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_KPI_CD" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_ORG_GRP_CD" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_ORG_DLR_CD" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_ORG_BSC_CD" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_USER_SEQ" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_SVC_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_YYYY_MM_FROM" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_YYYY_MM_TO" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="R_RESULT1" jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT" resultMap="rsltEntityMap1" />
<parameter property="R_RESULT2" jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT" resultMap="rsltEntityMap1" />
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="ReportProcedureEntity">
<resultMap id="rsltEntityMap1" class="com.dicc.domain.ReportProcedureEntity">
<result column="GRP_CD" property="grpCd" jdbcType="VARCHAR" />
<result column="KPI_CD" property="kpiCd" jdbcType="VARCHAR" />
<result column="KPI_NM" property="kpiNm" jdbcType="VARCHAR" />
<result column="ORG_LEVEL" property="orgLevel" jdbcType="VARCHAR" />
<result column="ORG_CD" property="orgCd" jdbcType="VARCHAR" />
<result column="ORG_NM" property="orgNm" jdbcType="VARCHAR" />
<result column="SVC_TYPE_CD" property="svcTypeCd" jdbcType="VARCHAR" />
<result column="SVC_TYPE_NM" property="svcTypeNm" jdbcType="VARCHAR" />
<result column="D1_NM" property="d1Nm" jdbcType="VARCHAR" />
<result column="D1_VAL" property="d1Val" jdbcType="VARCHAR" />
<result column="D1_UNIT" property="d1Unit" jdbcType="VARCHAR" />
<result column="D2_NM" property="d2Nm" jdbcType="VARCHAR" />
<result column="D2_VAL" property="d2Val" jdbcType="VARCHAR" />
<result column="D2_UNIT" property="d2Unit" jdbcType="VARCHAR" />
<result column="D3_NM" property="d3Nm" jdbcType="VARCHAR" />
<result column="D3_VAL" property="d3Val" jdbcType="VARCHAR" />
<result column="D3_UNIT" property="d3Unit" jdbcType="VARCHAR" />
<result column="D4_NM" property="d4Nm" jdbcType="VARCHAR" />
<result column="D4_VAL" property="d4Val" jdbcType="VARCHAR" />
<result column="D4_UNIT" property="d4Unit" jdbcType="VARCHAR" />
<result column="D5_NM" property="d5Nm" jdbcType="VARCHAR" />
<result column="D5_VAL" property="d5Val" jdbcType="VARCHAR" />
<result column="D5_UNIT" property="d5Unit" jdbcType="VARCHAR" />
<result column="D6_NM" property="d6Nm" jdbcType="VARCHAR" />
<result column="D6_VAL" property="d6Val" jdbcType="VARCHAR" />
<result column="D6_UNIT" property="d6Unit" jdbcType="VARCHAR" />
<result column="D7_NM" property="d7Nm" jdbcType="VARCHAR" />
<result column="D7_VAL" property="d7Val" jdbcType="VARCHAR" />
<result column="D7_UNIT" property="d7Unit" jdbcType="VARCHAR" />
<result column="D8_NM" property="d8Nm" jdbcType="VARCHAR" />
<result column="D8_VAL" property="d8Val" jdbcType="VARCHAR" />
<result column="D8_UNIT" property="d8Unit" jdbcType="VARCHAR" />
<result column="D9_NM" property="d9Nm" jdbcType="VARCHAR" />
<result column="D9_VAL" property="d9Val" jdbcType="VARCHAR" />
<result column="D9_UNIT" property="d9Unit" jdbcType="VARCHAR" />
<result column="D10_NM" property="d10Nm" jdbcType="VARCHAR" />
<result column="D10_VAL" property="d10Val" jdbcType="VARCHAR" />
<result column="D10_UNIT" property="d10Unit" jdbcType="VARCHAR" />
<result column="CREATE_TIME" property="createTime" jdbcType="DATE"/>
</resultMap>
<parameterMap id="manualDispLayMap" class="java.util.Map" >
<parameter property="P_GRP_CD" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_KPI_CD" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_ORG_GRP_CD" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_ORG_DLR_CD" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_ORG_BSC_CD" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_USER_SEQ" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_SVC_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_YYYY_MM_FROM" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="P_YYYY_MM_TO" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="R_RESULT1" jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT" resultMap="rsltEntityMap1" />
<parameter property="R_RESULT2" jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT" resultMap="rsltEntityMap1" />