大家好!
刚刚的SQL语句在各位的帮助下已经好了,但是我把他写道java里面却提示错误说缺少关键字select
我把他贴出来希望各位帮忙看看是怎么回事
String sql_ev_page = " SELECT a.empid, "
+ " eva_state_code, "
+ " sum(sort_total_) "
+ " FROM ev_emp_s_result_v a,hr_employee c "
+ " WHERE a.empid =? "
+ " AND "
+ " eva_phase_no =? "
+" and a.empid=c.empid "
+" and datestarted<=to_date('2005-7-1','yyyy-mm-dd') and evatype<>'EVA_type01'"
+"union all"
+"select empid, "
+ " eva_state_code, "
+ " sum(sort_total_) "
+"from ev_emp_s_result_v "
+"where evatype='EVA_type01'"
+" and empid=?"
+"and eva_phase_no=?" ;
刚刚的SQL语句在各位的帮助下已经好了,但是我把他写道java里面却提示错误说缺少关键字select
我把他贴出来希望各位帮忙看看是怎么回事
String sql_ev_page = " SELECT a.empid, "
+ " eva_state_code, "
+ " sum(sort_total_) "
+ " FROM ev_emp_s_result_v a,hr_employee c "
+ " WHERE a.empid =? "
+ " AND "
+ " eva_phase_no =? "
+" and a.empid=c.empid "
+" and datestarted<=to_date('2005-7-1','yyyy-mm-dd') and evatype<>'EVA_type01'"
+"union all"
+"select empid, "
+ " eva_state_code, "
+ " sum(sort_total_) "
+"from ev_emp_s_result_v "
+"where evatype='EVA_type01'"
+" and empid=?"
+"and eva_phase_no=?" ;
例如 +"union all"
应该写成+" union all "所有的字符串两端最好都加空格
变成+" union all "倒数第二行+" and empid=?"的问号后面加空格
变成+" and empid=? "最后变成:
String sql_ev_page = " SELECT a.empid, "
+ " eva_state_code, "
+ " sum(sort_total_) "
+ " FROM ev_emp_s_result_v a,hr_employee c "
+ " WHERE a.empid =? "
+ " AND "
+ " eva_phase_no =? "
+" and a.empid=c.empid "
+" and datestarted<=to_date('2005-7-1','yyyy-mm-dd') and evatype<>'EVA_type01'"
+" union all "
+"select empid, "
+ " eva_state_code, "
+ " sum(sort_total_) "
+"from ev_emp_s_result_v "
+"where evatype='EVA_type01'"
+" and empid=? "
+"and eva_phase_no=?" ;
String sql_ev_page = " SELECT a.empid, "
+ " a.eva_state_code, "
+ " a.sort_total_ "
+ " FROM ev_emp_s_result_v a,hr_employee c "
+ " WHERE a.empid =? "
+ " AND "
+ " eva_phase_no =? "
+" and a.empid=c.empid "
+" and datestarted<=to_date('2005-7-1','yyyy-mm-dd') and evatype<>'EVA_type01' "
+" union all "
+" select empid, "
+ " eva_state_code, "
+ " sort_total_ "
+" from ev_emp_s_result_v "
+" where evatype='EVA_type01' "
+" and empid=? "
+" and eva_phase_no=? " ;
和
a.empid=c.empid
可以同时作为条件吗?
String sql_ev_page=sql_ev_page1+" union all" +" select empid, eva_state_code, sort_total_ from ev_emp_s_result_v where evatype='"+EVA_type01+"' and empid=? and eva_phase_no=? ";
这样试试。
“并非所有变量都已经关联”一般来说是因为sql语句中“?”没有完全替换,少了几个参数