ORACLE 缺少逗号 问题 ?
String sql = "Insert into PAYRECKON ( payreckonid , money , issuedate , operatorid , serialnumber ,
paytypeid ) values ( HIBERNATE_SEQUENCE.NextVal ,"
+ pr.getMoney()
+ " , "
+ pr.getIssuedate()
+ " , "
+ pr.getOperatorid()
+ " , '"
+ pr.getPayreckonid()
+ "' , '"
+ pr.getPaytypeid() + "' )";
一开始是这样写的SQL,然后执行时报 “缺少逗号”的错误!
String sql = "Insert into PAYRECKON ( payreckonid , money , issuedate , operatorid , serialnumber ,
paytypeid ) values ( HIBERNATE_SEQUENCE.NextVal ,"
+ pr.getMoney()
+ " , to_date("
+ pr.getIssuedate()
+ ",'YYYY-MM-DD HH24:MI:SS') , "
+ pr.getOperatorid()
+ " , '"
+ pr.getPayreckonid()
+ "' , '"
+ pr.getPaytypeid() + "' )";
然后改成这样,加了一个to_date()函数,执行后报“java.sql.SQLException: ORA-00907: 缺失右括号”错误!
这里的pr.getIssuedate() 里放的是 new Date()出来的值。
望 高手 解答该如何修改~