mysqls本文来源gaodai#ma#com搞@@代~&码网smcount()乱码
贴上xml–sql 语句
<code> 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</code>
数据库结果是：
Java 后台结果：
求问题解决！！
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：mysql-SSM 查询结果COUNT返回 变成 COUNT=[B@6b522f02,
转载请注明原文链接：mysql-SSM 查询结果COUNT返回 变成 COUNT=[B@6b522f02,
