String sql="";
sql=sql+"insert ito wglmessage";
sql=sql+"(code,";
sql=sql+"stime,";
sql=sql+"etime,";
sql=sql+"hours,";
sql=sql+"cause,";
sql=sql+"time)";

sql=sql+" values (";
sql=sql+"'"+personid+"',";
sql=sql+"'"+sdate+"',";
sql=sql+"'"+eday+"',";
sql=sql+"'"+hours+"',";
sql=sql+"'"+cause+"',";
sql=sql+"getdate())";
ResultSet rs=stmt.executeQuery(sql);
我是这样写的,但提示说"org.apache.jasper.JasperException: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。"
痛苦!

不好意思,sql=sql+"insert ito wglmessage";这句是这样的sql=sql+"insert into wglmessage";

是请教这个插入语句的语法！

executeupdate(sql),该语句的返回值类型是int?

6楼的DX,这是提示信息:"org.apache.jasper.JasperException: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。"

谢了各位，现在可以了，我的Ｄate类有问题，定义不了对象，把getdate（）去掉，stmt.excuteQuery()改成stmt.excuteUpdate()就好了