getHibernateTemplateString sql = "select a.btype,count(a.btype) as 'countt' from article as a where a.auserid='"
+ user + "' and a.atype='" + atype + "' GROUP by a.btype ";上面这个SQL语句中mysql可以正常查询,但是在SSH框架中怎么解决 就是这么查询原生sql?????????????????
+ user + "' and a.atype='" + atype + "' GROUP by a.btype ";上面这个SQL语句中mysql可以正常查询,但是在SSH框架中怎么解决 就是这么查询原生sql?????????????????
Query query = session.createSQLQuery(sql);
印象中好象这样的.创建一个本地SQL.很久没用过啦.
不知道对不对.呵呵...
这样试试,
session.createSQLQuery(sql).list();2.ScrollableResults srs=session.createSQLQuery(sql).scroll();
while(srs.next()){ ******}
String sql = "select btype,count(btype) as "countt" from article where auserid='"
+ user + "' and atype='" + atype + "' GROUP by btype ";