ssh的sql语句出了问题

[qq_27528137]

javax.servlet.ServletException: org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: , near line 1, column 71 [select new com.model.TYudingVO(a.yudingShumu,b.shifazhan,b.daodazhan ),sum(a.yudingShumu)from com.model.TCheci as b,com.model.TYuding as a where a.checiId= b.id and a.yudingZhuantai !=2 group by a.checiId]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: , near line 1, column 71 [select new com.model.TYudingVO(a.yudingShumu,b.shifazhan,b.daodazhan ),sum(a.yudingShumu)from com.model.TCheci as b,com.model.TYuding as a where a.checiId= b.id and a.yudingZhuantai !=2 group by a.checiId]

[QWERT4745]

你这个描述的太有问题了，发的代码明显语法错误，怎么能声明两个sql变量，而且报错的语句跟你发的代码的sql不一样，既然都报错了，为什么上面又说list还能打印出值

[qq_charm]

这个sql要仔细检查，你发的这个看起太累了

[qq_27528137]

String sql="select a.shifazhan,a.daodazhan,SUM(b.yudingShumu) from TCheci a,TYuding b where b.yudingZhuantai !=2 group by b.checiId"; String sql=" from TYuding where yudingZhuantai !=2 group by checiId"; List<TCheci> liuliangList=yudingDAO.getHibernateTemplate().find(sql); Map request=(Map)ServletActionContext.getContext().get("request"); request.put("liuliangList", liuliangList); return ActionSupport.SUCCESS; 这个语句为什么在jsp页面没有值

[木子0204]

你肯定要跟踪下你的sql语句是否是有数据的 然后看liuliangList 执行的结果是什么 liuliangList 里面是否有放进去值 然后在纠结页面没有拿到值是怎么回事

[qq_27528137]

liuliangTJ打印出来是[[Ljava.lang.Object;@12f58129, [Ljava.lang.Object;@3d3310dc, [Ljava.lang.Object;@6e6b750e, [Ljava.lang.Object;@456fff18, [Ljava.lang.Object;@7b2dc255, [Ljava.lang.Object;@5ebd981c]

[qq_27528137]

liuliangList打印出来是[[Ljava.lang.Object;@12f58129, [Ljava.lang.Object;@3d3310dc, [Ljava.lang.Object;@6e6b750e, [Ljava.lang.Object;@456fff18, [Ljava.lang.Object;@7b2dc255, [Ljava.lang.Object;@5ebd981c]