问题描述

SSM 查询结果COUNT返回 变成 COUNT=[B@6b522f02,

贴上xml--sql 语句

 select FUSID,REALNAME,MOBILE,COMPANY,COMPANYWORK,COUNT from (
    SELECT psf.FUSID,pam.REALNAME,pam.MOBILE,pam.COMPANY,pam.COMPANYWORK,count(psf.FUSID)  as COUNT from PRE_SHAPP_FRIENDS psf JOIN PRE_AL_MEMBER pam ON pam.USID = psf.FUSID
    where psf.USID in (select FUSID from PRE_SHAPP_FRIENDS_STATUS where STATUS = 2 and USID = #{USID}) group  BY FUSID
    UNION ALL
    select USID,REALNAME,MOBILE,COMPANY,COMPANYWORK,'' as COUNT from PRE_AL_MEMBER
    where USERNAME in (select USERNAME from PRE_AL_SHMEMBER where ISACTIVATION = 2) AND USID NOT IN (SELECT FUSID from PRE_SHAPP_FRIENDS
    where USID in (select FUSID from PRE_SHAPP_FRIENDS_STATUS where STATUS = 2 and USID = #{USID}))
) as temp ORDER BY COUNT desc limit ${x},10

数据库结果是：

Java 后台结果：

求问题解决！！

解决方案

封装的问题吧，把你接收的result封装粘出来看看