as-這段代碼的sql查詢我是最後加了別名的，但是運行的時候出來卻沒有，哪位大神教我

這段代碼的sql查詢我是最後加了別名的，但是運行的時候出來卻沒有，哪位大神教我

Integer cnt = Integer.valueOf(payInfoDao.getCurrentSession().createSQLQuery("select count(*) from (select t.mechno,count(*) from (select * from boc_payinfo " + whereStr + ") t, mp_merinfo m where t.mechno = m.mechno group by t.mechno) as b ").list().get(0).toString());

最佳回答：

你試試這樣吧。

StringBuffer sb = new StringBuffer();
sb.append("select count(*) from (select t.mechno,count(*) from (select * from boc_payinfo");
sb.append(whereStr);
sb.append(") t, mp_merinfo m where t.mechno = m.mechno group by t.mechno) as b ");
String res = payInfoDao.getCurrentSession().createSQLQuery(sb.toString()).list().get(0).toString();
Integer cnt = Integer.valueOf(res);