java.sql.SQLException:ORA-00917:缺失逗号String sql1 = "insert into KAOQINSIGN (EID,MORNINGS,MORNINGX,AFTERNOONS,AFTERNOONX,riqi)" +\x05\x05\x05\x05\x05"values('"+LoginFrame.i_user+"','"+Today.getNowTime()+"','"+ null +"'," +"','"+null+"','"+null+

java.sql.SQLException:ORA-00917:缺失逗号String sql1 = "insert into KAOQINSIGN (EID,MORNINGS,MORNINGX,AFTERNOONS,AFTERNOONX,riqi)" +\x05\x05\x05\x05\x05"values('"+LoginFrame.i_user+"','"+Today.getNowTime()+"','"+ null +"'," +"','"+null+"','"+null+
java.sql.SQLException:ORA-00917:缺失逗号
String sql1 = "insert into KAOQINSIGN (EID,MORNINGS,MORNINGX,AFTERNOONS,AFTERNOONX,riqi)" +
\x05\x05\x05\x05\x05"values('"+LoginFrame.i_user+"',
'"+Today.getNowTime()+"',
'"+ null +"'," +"','"+null+"','"+null+"',
'"+Today.getNowDate()+"')";
LoginFrame.i_user是int类型,这句sql哪里错了?

java.sql.SQLException:ORA-00917:缺失逗号String sql1 = "insert into KAOQINSIGN (EID,MORNINGS,MORNINGX,AFTERNOONS,AFTERNOONX,riqi)" +\x05\x05\x05\x05\x05"values('"+LoginFrame.i_user+"','"+Today.getNowTime()+"','"+ null +"'," +"','"+null+"','"+null+
int类型如果在数据库中是number类型的话,插入的时候不要加单引号
去掉第一个值的单引号如下：
"values("+ LoginFrame.i_user+ ",'"
如果数据库中是字符型的话,就不是这个原因了
还有 在你的第一个null后面加了两个逗号,删掉一个试试