这段代码的sql查询我是最后加了别名的，但是运行的时候出来却没有，哪位大神教我

Question

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

Answer 1

你试试这样吧。

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