ORA-00928: 缺失 SELECT 关键字

String sql = "INSERT INTO JOBS" + "VALUES('" + jobs.getId() + "','" + jobs.getTitle() + "'," + jobs.getSalary() + "," + jobs.getMaxSlary() + ")";

拼接哪里有问题 麻烦各位给看看 实在觉得没有错误 看了好几遍了 没找出来

输出sql这个string再看

最好不要拼接字符串,而是用填充参数方式构造sql

http://www.tuicool.com/articles/6V3iy2

ID也是字符串吗?图片说明

String sql = "INSERT INTO JOBS " + "VALUES('" + jobs.getId() + "','" + jobs.getTitle() + "'," + jobs.getSalary() + "," + jobs.getMaxSlary() + ")";