mysql中怎么打括号_java mysql hql 怎么进行添加括号

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");

其中的括号根本就不识别 请大神帮忙看看

展开