java不被系统识别_在java后台时括号不被识别请问怎么才能让他进行识别

Stringhql="SELECT";Finderfinder=Finder.create(hql);finder.append("(SELECTCAST(SUM(CASEbean.titleWHEN'不满意'THENvoteCount/b.allcount*100ELSE0END)ASDECIMAL(9,0)))不满意");...

String hql="SELECT ";

Finder finder=Finder.create(hql);

finder.append(" (SELECT CAST(SUM( CASE bean.title WHEN '不满意' THEN voteCount/b.allcount*100 ELSE 0 END ) AS DECIMAL(9,0))) 不满意 ");

finder.append(" (SELECT CAST(SUM( CASE bean.title WHEN '基本满意' THEN voteCount/b.allcount*100 ELSE 0 END) AS DECIMAL(9,0))) 基本满意, ");

finder.append(" (SELECT CAST(SUM( CASE bean.title WHEN '满意' THEN voteCount/b.allcount*100 ELSE 0 END) AS DECIMAL(9,0))) 满意, ");

finder.append(" (SELECT CAST(SUM( CASE bean.title WHEN '非常满意' THEN voteCount/b.allcount*100 ELSE 0 END) AS DECIMAL(9,0))) 非常满意");

finder.append(" FROM CmsVoteItem bean,");

finder.append(" (SELECT subTopic sid,SUM(voteCount) allcount FROM CmsVoteItem GROUP BY subTopic) b");

finder.append(" WHERE bean.subTopic=b.sid GROUP BY bean.subTopic");

大神帮忙解决下

展开