insert into game(gameID,no,placeid,stime,etime,type)values('112',5,'12',to date('2006-5月-10 12:00:01','YYYY-MM-DD HH24:MI:SS'),to date('2006-5月-10 12:15:01','YYYY-MM-DD HH24:MI:SS'),'ss')这是我打印出来的SQL语句 ,总是报 缺少表达式的错误
哪位大侠来帮忙看看
哪位大侠来帮忙看看
(gameID, no, placeid, stime, etime, TYPE)
VALUES
('112',
5,
'12',
TO DATE('2006-05-10 12:00:01', 'YYYY-MM-DD HH24:MI:SS'),
TO DATE('2006-05-10 12:15:01', 'YYYY-MM-DD HH24:MI:SS'),
'ss')
sql="insert into game(gameID,no,placeid,stime,etime,type)";
sql=sql+"values('"+tgameID+"',"+no.getText()+",'"+tplaceid+"',to date('"+stime.getText();
sql=sql+"','YYYY-MM-DD HH24:MI:SS'),to date('"+etime.getText()+"','YYYY-MM-DD HH24:MI:SS'),'"+type.getText()+"')"
程序环境是netbeans 字段 类型 gameID varchar2 , no nunber, placeid varchar2 stime,date etime date ,type varchar