语句
String sql="select sum(STAT_VALUE) from EP_INDICATORS_HOUR where INDICATORS_ID=:indicatorsId and STAT_DATE>=start and STAT_DATE<end";
Map<String, Object> params = new HashMap<String, Object>();
params.put("indicatorsId", indicatorId);
params.put("start", start);
params.put("end", end);
return template.queryForObject(sql, Double.class, params);
执行的时候报
PreparedStatementCallback; bad SQL grammar [select sum(STAT_VALUE) from EP_INDICATORS_HOUR where INDICATORS_ID=? and STAT_DATE>=start and STAT_DATE<end]; nested exception is java.sql.SQLException: ORA-00936: missing expression
请大虾们指教下是什么问题
String sql="select sum(STAT_VALUE) from EP_INDICATORS_HOUR where INDICATORS_ID=:indicatorsId and STAT_DATE>=start and STAT_DATE<end";
Map<String, Object> params = new HashMap<String, Object>();
params.put("indicatorsId", indicatorId);
params.put("start", start);
params.put("end", end);
return template.queryForObject(sql, Double.class, params);
执行的时候报
PreparedStatementCallback; bad SQL grammar [select sum(STAT_VALUE) from EP_INDICATORS_HOUR where INDICATORS_ID=? and STAT_DATE>=start and STAT_DATE<end]; nested exception is java.sql.SQLException: ORA-00936: missing expression
请大虾们指教下是什么问题
start
end
类型是?
是不是应该:start和:end
String sql="select sum(STAT_VALUE) from EP_INDICATORS_HOUR where INDICATORS_ID=:indicatorsId and STAT_DATE>=start and STAT_DATE<end";start和end前面缺少:号。