java.sql.SQLException: ORA-00933: SQL command not properly ended,又没有遇到过,程序以前是正确的,后来我改了sql语句,sql单独运行也是正确的,但是放在java里就不行了。
sql:
sql = "select ORI_URL, count(*) as counter, count(*)/"+total+" as ratio "+
"from KFWEB_VISIT"+
"where ORI_URL not like '%192.168.0.200%' and ORI_URL not like '%192.168.0.100%' "+
" group by ORI_URL"+
" order by counter desc";
------解决方案--------------------
还是sql语句的问题,建议你好好检查一下