diff options
| author |   hekeguang <hekeguang@chinamobile.com> | 2022-09-26 16:57:55 +0800 |
|---|---|---|
| committer | hekeguang <hekeguang@chinamobile.com> | 2022-09-26 16:58:32 +0800 |
| commit | ead03c73657e3c46f87d82a34939b84ae35e8417 (patch) | |
| tree | 98d434ad3be8930234e2c7e01928e3d76063318a /intentanalysis/src/main/resources/mybatis/sql | |
| parent | 1d3d6092e9db1daaac382eb0e859da65dc98a712 (diff) | |
Add ImfRegInfo code .
Issue-ID: USECASEUI-696
Change-Id: I143d9c9aada3d9c0dfdbf5dae8cd04be0a2a3c5a
Signed-off-by: hekeguang <hekeguang@chinamobile.com>
Diffstat (limited to 'intentanalysis/src/main/resources/mybatis/sql')
| -rw-r--r-- | intentanalysis/src/main/resources/mybatis/sql/ConditionMapper.xml | 4 | ||||
| -rw-r--r-- | intentanalysis/src/main/resources/mybatis/sql/IMFRegInfoMapper.xml | 11 |
2 files changed, 6 insertions, 9 deletions
diff --git a/intentanalysis/src/main/resources/mybatis/sql/ConditionMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/ConditionMapper.xml index 012dfca..ccce147 100644 --- a/intentanalysis/src/main/resources/mybatis/sql/ConditionMapper.xml +++ b/intentanalysis/src/main/resources/mybatis/sql/ConditionMapper.xml @@ -27,13 +27,13 @@ </insert> <!-- 这里的查询有问题--> <select id="selectConditionList" resultType="org.onap.usecaseui.intentanalysis.bean.models.Condition"> - select condition_id conditionId, condition_name conditionName, operator_type operator, condition_value conditionValue + select condition_id conditionId, condition_name conditionName, operator_type "operator", condition_value conditionValue from condition where parent_id = #{parentId} </select> <select id="selectCondition" resultType="org.onap.usecaseui.intentanalysis.bean.models.Condition"> - select condition_id conditionId, condition_name conditionName, operator_type operator, condition_value conditionValue + select condition_id conditionId, condition_name conditionName, operator_type "operator", condition_value conditionValue from condition where condition_id = #{conditionId} </select> diff --git a/intentanalysis/src/main/resources/mybatis/sql/IMFRegInfoMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/IMFRegInfoMapper.xml index fd632b3..504c244 100644 --- a/intentanalysis/src/main/resources/mybatis/sql/IMFRegInfoMapper.xml +++ b/intentanalysis/src/main/resources/mybatis/sql/IMFRegInfoMapper.xml @@ -5,19 +5,16 @@ <mapper namespace="org.onap.usecaseui.intentanalysis.mapper.IMFRegInfoMapper"> - <resultMap id="mapIMFRInfo" type="org.onap.usecaseui.intentanalysis.bean.models.IntentManagementFunctionRegInfo"> - <result column="support_area" property="supportArea" typeHandler="org.onap.usecaseui.intentanalysis.util.ListArrayTypeHandler" jdbcType="ARRAY" javaType="java.util.List"/> - <result column="support_interfaces" property="supportInterfaces" typeHandler="org.onap.usecaseui.intentanalysis.util.ListArrayTypeHandler" jdbcType="ARRAY" javaType="java.util.List"/> - </resultMap> - <insert id="insertIMFRegInfoRegInfo"> insert into intent_management_function_reg_info(imfr_info_id,imfr_info_description,support_area,support_model,support_interfaces,handle_name,intent_function_type) values (#{imfregInfo.id}, #{imfregInfo.description},#{imfregInfo.supportArea} , #{imfregInfo.supportModel},#{imfregInfo.supportInterfaces},#{imfregInfo.handleName},#{imfregInfo.intentFunctionType}) </insert> - <select id="getImfRegInfoList" resultMap="mapIMFRInfo"> - select * from intent_management_function_reg_info + <select id="getImfRegInfoList" resultType="org.onap.usecaseui.intentanalysis.bean.models.IntentManagementFunctionRegInfo"> + select imfr_info_id id,imfr_info_description description,support_area supportArea, support_model supportModel, + support_interfaces supportInterfaces,handle_name handleName,intent_function_type intentFunctionType + from intent_management_function_reg_info </select> </mapper> |