Home > Database > Mysql Tutorial > mysql-SSM 查询结果COUNT返回 变成 COUNT=[B@6b522f02,

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

WBOY
Release: 2016-06-06 09:34:41
Original
1285 people have browsed it

mysqlssmcount()乱码

贴上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>
Copy after login

数据库结果是:
图片说明

Java 后台结果:
图片说明

求问题解决!!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template