日期:2014-05-20  浏览次数:20793 次

java sql语句不执行 但在查询编辑器中可以查出来
语句如下:
select c.name,a.stu_class,a.stu_name,a.stu_sex,e.name,a.birthdate,a.bative_place,a.education,d.jparty_time from application as a join activists as b join college as c join party as d join national as e where a.app_id=b.app_id and a.col_id=c.col_id and d.act_id=b.act_id and a.nat_id=e.nat_id

------解决方案--------------------
汗 你用什么查的
------解决方案--------------------
写成存储过程的 ?
------解决方案--------------------
探讨

你这哪门子的sql语句?join不用on么?
把where改为on
SQL code


select c.name,a.stu_class,a.stu_name,a.stu_sex,e.name,a.birthdate,a.bative_place,a.education,d.jparty_time from application as a join activists as b jo……

------解决方案--------------------
你把你java里执行语句的代码块贴上来呢?
------解决方案--------------------
探讨

呵呵 谢谢大家 是我的代码的问题 有个地方多赋了一个值 O(∩_∩)O~