mybatis的返回形式（bo---map(key--value)）

来源：互联网发布：常见的公钥密码算法编辑：程序博客网时间：2024/05/17 07:12

mybatis 返回一个结果集可以用resultmap（返回一个bo），可以用resultType='bean'返回一个bo,当用resultType=‘java.util.HashMap’的时候，

返回的结果集以key----value的形式组织：

SELECT t.*,FC_GET_AREANAME(t.CITY_AREA_KEY) AREA_NAME FROM TB_CUS_FIRM_CHG t WHERE CUSTOMER_KEY=#{CUSTOMER_KEY}

</select>

易于组织复杂格式的json，当然也可bo转

{MESSAGESTAT=Y, CUSTOMER_NAME=上海冶金物资有限公司, TRADE_DIPLOMA=null, CHG_STATUS=A, PRINT_STATUS=N, COMPANY_REG_DATE=null, OPEN_BANK_NAME=null,

IS_RET_MONEY=Y, CUSTOMER_MEMO=null, MY_ROLE=null, TAX_DIPLOMA=null, CHG_APPTIME=null, FAX=1111111111, TRADE_MAN_EMAIL=616410589@qq.com, CERTIFICATE_VALID_DATE=null,

ENGLISH_NAME=Metallurgical Company, MARKET_CHECK_TYPE=A, REGISTER_DATE=2015-09-02, ZIP_CODE=201900, CERTIFICATE=3434, WEB_USERID=null, REGISTER_ADDRESS=华兹奔腾大厦,

LEGAL_MAN_FAX=null, TRADE_APT=A, OPEN_BANK_NUMBER=null, DPT_KEY=null, MARKET_KEY=1, COMPANY_TYPE=C, COMMUNICATE_ADDRESS=上海市宝山区华兹奔腾大厦, TRADE_MAN_MOBILE=15900951460,

DPT_NAMES=null, FINANCE_RANK_NUM=3, IS_BID_PUBLISH=N, BORNDATE=null, ONLINE_MARK=N, LAST_LOGIN_DATE=2016-03-22 15:01:23, PACT_NUM=0, CREDIT_RANK_NUM=3, MIAL_CHECK_STATUS=B,

TRADE_MAN_NAME=Fred, VALID_EMAIL=null, CITY_AREA_KEY=HD310113, SET_USER_NUM=null, CUSTOMER_SEX=null, CONT_MARKET_KEY=null, SELF_CARS_NUM=null, CARD_TYPE=4, LANGUAGE=CN,

LAST_LOGIN_TIME=2016-03-22 15:01:23.0, COUNTRY=null, LEGAL_MAN_NAME=null, CUSTOMER_STATUS=A, DEVELOP_STAGE=A, CHG_CHKTIME=null, BUSINESS_RANGE=null, CHECK_CODE=null,

AREA_NAME=上海市宝山区, MARKET_VALID_DATE=null, ACCOUNT_PASSWD=esteel123, BUS_ADMIN_NAME=null, CUSTOMER_CUTNAME=null, IS_BID_PARTAKE=N, MAIN_MANAGE=钢铁，冶金，矿,

HAND_INFO=null, COMPANY_KIND=I, PROVINCE_AREA_KEY=HD310000, COUNTY_AREA_KEY=null, CUSTOMER_KEY=408, LEGAL_MAN_IDENTITY=null, KF_CUSTOMER_KEY=null, QQ=null,

CONTROL_CARS_NUM=null, LEGAL_MAN_PHONE=null, IS_REC_SMS=Y, CUS_NOTE_GROUP=null, RIPE_LINE=null, OPEN_DIPLOMA=null, CUS_TRADE_KIND=A, IS_DELETE=Y, TRADE_MAN_PHONE=2221111111,

COMP_TYPE=A, CHG_BACKCAUSE=null, LEGAL_MAN_EMAIL=null, ORDER_NUM=5, NO_TRADE_BED=null, CAR_ID=null, CUSTOMER_ID=E00000004, JOIN_TYPE=A, CHINESE_NAME=上海冶金物资有限公司,

TRADE_RANK_NUM=3, LEGAL_MAN_MOBILE=null, CUS_RANK_NUM=3, CERTIFICATE_ANNUL_DATE=null, TRADE_PERIOD=null, SESSIONID=F112A33EED4D58D6128207B444EE51FB, MAIN_CAR_TYPE=null,

TRADE_MAN_IDENTITY=2222222222, TRADE_MAXNUM=null, CHK_TIME=2015-09-02 11:29:45.0, MARKET_ANNUL_DATE=null, CREDIT_GRADE=null, CERTIFICATE_CODE=12334, ENROLL_MONEY=null,

PROPERTY_SCALE=null, NO_TRADE_TYPE=null, PRINT_ACC_STATUS=N, ONLINE_IP=null}

0 0