首页 > 代码库 > ibatis返回map类型数据
ibatis返回map类型数据
有时侯不想创建javabean,或者污染现有的javaBean对象,就需要返回Map类型的数据对象;
1)最简单的方法就是将查询到的字段,使用""进行引起来,这样就可以返回map类型了;
2)或者写成ResultMap,来进行字段的映射也是可以的;
例子如下:
1)
<select id="queryProductInfo" parameterClass="java.util.HashMap" resultClass="java.util.HashMap">
select a.marketproduct_code "productCode",
a.marketproduct_name "productName",
a.product_class "productClass",
(select t.value_chinese_name
from product_base_data t
where t.collection_code = ‘CPDL‘
and t.value_code = a.product_class) "productClassName",
a.is_combined "isCombined",
a.combind_relation "packageType",
a.IS_SELF_CARD "isSelfCard",
(select decode(count(1), 0, ‘0‘, ‘1‘)
from package_info t1
where t1.id_marketproduct_info = a.id_marketproduct_info) "hasPackage",
a.is_self_card "productKind",
a.marketproduct_type "productType",
b.least_copy_num "leastInusureAmout",
b.top_copy_num "topInsureAmout",
b.insure_period_lmt_of_mon "periodSetMonth",
b.insure_period_lmt_of_day "periodSetDay",
b.least_accept_insure_age "leastAcceptInusrAge",
b.top_accept_insure_age "topAcceptInsurAge",
a.target_type "targetType",
b.PROFESSION_TYPE "professionType",
b.SPECIAL_PROMISE "specialPromise",
a.version "version"
from marketproduct_info a,
marketproduct_rule_param b,
technic_product_info c
where a.marketproduct_code = #marketproductCode#
and a.version = #version#
and a.id_marketproduct_info = b.id_marketproduct_info(+)
and a.id_technic_product_info = c.id_technic_product_info
</select>
2)
<resultMap id=“getItemsResult” class=“java.util.HashMap”>
<result property=“itemName“ column=“item_name” />
<result property=”itemValue” column=“item_value” />
</resultMap>
<select id=“getItems” resultMap=“getItemsResult”>
select item_name, item_value from item_table
</select>
ibatis返回map类型数据